...small project. 1. Search tool to be placed in a folder along with multiple data excel workbooks. - 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
...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 file. While bidding
...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 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
...consolidated Group Daily Sales Summary Excel report from separate (and slightly differently formatted) Excel spreadsheets from each of 10 different brands. The Group Daily Sales Summary report Excel template (1 page) has already been designed and already uses the data from each of 10 separate Sheets in the same Workbook onto the consolidated Daily Sales
...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)
I am looking for a quoting workbook for our sales teams to use. I want to be able to update the products, cost price, margin and retail price in the "backend" which will make it easy for our sales people to quote.
Create Sample Dat...NUTS CODE etc. Ability to select # of data records Ability to select values for few fields which will be static throughout the sample data file. Deliverable is an excel macro workbook which takes some input parameters including the static field values, # of data records, type of template and then the output is a sample data file.
...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.
Macro: ORDERMENTUM_IMPORT Purpose: To open a file exported from the ordering website and populate the the excel order spreadsheet with quantities matched to the product codes for matching customers. Pre-processing: Prior to populating the spreadsheet, a number of checks should be performed on the exported data. Any negative results of the checks should
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
...not budget/spent, but more attributes for ownership, project health, status, etc. - We want the project owners to input their update into SharePoint and pull that into this workbook, mapping to the data elements in the dashboard - We want to leverage a VBA button to produce a PowerPoint slide of the dashboard to automate our deck production. We hope
We are Financial Planners in Australia who have developed an excel spreadsheet workbook to take notes called "Interview and Paraplanning Notes". However my excel is very basic and the workbook needs to look more professional and there is a number of formulae that need to be corrected The second spreadsheet called "Copy of ANNUAL REVIEW" is not to be
...Title, email address, and Company Phone Number. You should have most of the information already in the spreadsheet, the only thing that might be missing is the Job Title. The workbook is divided by industry (Architects, Developers, General Contractors, and Mechanical Contractors) and then broken up by project name, and some of the projects may not have
I am looking for one Excel workbook. One tab will be employee data, one tab with employee authorized numbers and 3 tabs of pivot tables using that data. Looks and ease of use are very important. The workbook needs good security to prevent users from editing areas they don’t have access to.