...MAC FORMATTED VBA!! You will write a Macro for Office that will work on an Apple Mac. It must work on Apple computers with Office for Mac Version 16.16.1 We have an Excel workbook with multiple worksheets. Each worksheet contains several formatted sections. The Macro needs to do the following: 1) Select the worksheet (by worksheet tab name) 2) Select
...points and items I need to edit it translate some pages from english to arabic. format and create a document (booklet) size a5 designed (attached is the poster where this workbook will be presented for the workshop) ّ I have uploaded the working document, that has arabic and english pieces, what is required is to format the styling of the arabic, translate
Hello, I have an excell workbook that I frequently extract on a weekly basis from one of our databases. Wehve to spend hours sometimes sorting, filtering for specific data. What i need is to provide the sheet with a set of Data and have it filter based on that set. Example: assuming i need the sheet to spit out 1, 2, 3. These numbers are all over
...need to be able to refresh the data to allow for the second half totals/lines with odds to be updated and displayed as they become available. Please see the attached sample workbook for further details. I only need/want the data from Heritage which shows as (section data-vertical-sbid="169" data-index="5") in source data. An example worksheet has been
...complex excel macro (depending on your level of Excel Expertise) that needs to be created or modified based on our existing macro. Background: We have two worksheets in a given workbook file. We need to have various "column transpose" and lookups from sheet2 to sheet1. This is an ongoing progject meaning, if we need to add functionality to this macro or
...- DONE. 2. Tool should look for a keyword in all the existing workbooks in the folder only and copy paste the entire row in the search tool. - DONE 3. It should paste the workbook name and the sheet name while pasting the entire row of occurrences. - DONE 4. No limitation on the case sensitivity. - DONE 5. Data could be in merged cell, so paste all
Hello Freelancers! We have an excel workbook which contains three sheets connect to each other using VBA. There are lists and buttons in the sheet which do have some associate functionality and ultimately reflects the changes in data tables. We would like to implement the same using trello power-ups API so that our users don't need to access the excel
...test Students cannot access the course content, videos and supplemental materials except for technical support information. □ Students cannot open and print the student workbook during the exam. □ Students cannot print and make screen shots of the exam. □ Students cannot create multiple, concurrent log-on sessions. □ If a file or ele...
I need an excel vba expert to write a two phase code for me, with the first phas...with the first phase being to import data from two different workbooks based on a userform where a certain value is entered, and the second phase to import data from another workbook based on certain letters that are entered for the value talked about in the first phase
I have a project to design an A4 bookl...work to show off. Design inspiration needs to look like the attached. Not exact but something like that. Minimal, clean and modern look and feel. The document is like a workbook where you fill in each section. More detail once you get the job. I don't have a hard deadline so I'm looking for good work here.
...consistency of design and layout you must: • Ensure Columns are wide enough to display data properly and are evenly spaced. • Include a header containing the file name of the workbook. • Today’s date and a Branch name area must appear on the worksheet. (The branch name will be filled in when the template is used.) • Format the spreadsheet so it is clear
...a project in 4 steps. I need this assessment completed before August 16th. because I will study this documents and answers on weekend. *The task is simple: You read the workbook and you answer what is asked about it. *The last one I've done took me 4 hours. *It can be more or less (depending on your English skills and knowledge about the content)
...such as Cell A8 in Sheet ‘Toll’ where there are two invoice numbers. In the ‘EFM’ sheet, the invoice numbers also include another set of numbers that are irrelevant to the workbook. For example, Cell A2, only relevant data is 27264, therefore V49779732 needs to be discarded. Also, A32 has this data “V50088895,27633, 27646, 27646,27633, S50075896”, t...
Needing a quick macro developed that will use one source of data and compare it to an Excel workbook with multiple sheets. It will identify matches within these sheets and change the matching text in GREEN and the non-matching text in RED. Must be able to accept uploaded information, not cut and paste.
In each tab in the associated excel workbook, there are 3 tabs. In each tab there is a source1 data and source2 data columns. Need to match the dealer_names in source1 and source2 by examining each of thecolumns in the sources and mark the the last "correct" column as 1 for match, 0 for different, and 2 if not sure. Needs fuzzy matching on dealer_name