Excell VBA - combine 3 spreadsheets in 1.
- or -
Post a project like this3480
£20(approx. $25)
- Posted:
- Proposals: 21
- Remote
- #573000
- Awarded
Description
Experience Level: Entry
Description of excel work: I need someone to write me a VBA script to combine data from 3 excel spreadsheets to enable me to upload the information to a new program.
The spreadsheet will have 3 sheets as follows:
1) Customer List. This will be the master list. I want to be able to copy and paste all the names into this sheet and press and button to automatically process and add the information from the others other sheets.
2) Customer address list. Take the address from this sheet (on in preset locations) and add to the Customer list sheet
3) Customer Activity. This is a list of all companys that have made a transaction in the last 5 years. I want the software to look up if the company name appears this sheet and input “Y” for yes and “N” for no.
Extra notes: I have an example sheet to help for credible PPHs.
The spreadsheet will have 3 sheets as follows:
1) Customer List. This will be the master list. I want to be able to copy and paste all the names into this sheet and press and button to automatically process and add the information from the others other sheets.
2) Customer address list. Take the address from this sheet (on in preset locations) and add to the Customer list sheet
3) Customer Activity. This is a list of all companys that have made a transaction in the last 5 years. I want the software to look up if the company name appears this sheet and input “Y” for yes and “N” for no.
Extra notes: I have an example sheet to help for credible PPHs.
Matt Y.
100% (7)Projects Completed
8
Freelancers worked with
6
Projects awarded
8%
Last project
7 Jan 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies