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
...about project management (there are some questions to answer) The 2nd is asking to create 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
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 Data Files based on template and taxonomy. File generation should work for 10 kinds of templates Data needs to be randomly generated adhering to various taxonomy rules like DATES, LIST FIELDS ALPHANUM INTEGER DECIMAL NUTS CODE etc. Ability to select # of data records Ability to select values for few fields which will be static throughout
...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
...someone who can create a boilerplate template for asp.net MVC 5 and react.js using visual studio with webpack. What I need: 1) Asp.net MVC 5 project integrated with react.js and (webpack) 2) One simple registration form to submit data and Login ( I will provide API'S) 3) One sample page to Read data from API and show in Datagrid or Datatable 4) Authenticate
...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
...of good example files with definitive 'markers' that will require processing differently. Main Requirements: * VB.Net Forms Application * Push to a pre-created SQL Server DataTable (that you define based upon the columns) * Ability to process all CSV Files in a folder (easy - recursive) Datatables needed: 1. Node Database with Unique Identifier and
...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.
I need the first spreadsheet cross-checked with the second one. 1) In the first spreadsheet "Contacts for Seminar" -- there are yellow highlighted contacts (i...spreadsheet. Keep them at the bottom so that I can see how many were added and who. You are only updating the 20180803 File with any missing contacts from the Contacts for Seminar workbook.