I have a spread sheet with one tab that has a master list of phone numbers. It has to go and look at 3 other tabs to see if the exact match exhists. One of the tabs has multiple columns where it needs to check.
What im looking for is VBA to:
1)Create a new tab and name it something of my choice.
2)Copys columns from all tabs identified and places them into essentially 4 columns with appropriate headers
3)A new column that does the lookup (against the master column) and reports back if/what the match is and what column is resides in.
Im open to other suggestions but i need something quick and repeatable. I have nearly 100 excel sheets that need to be validated
30 freelancers are bidding on average $35 for this job
Dear client I can write the macro code for the requirements you mentioned. I ensure you will be happy after hiring me. Kindly contact me for further details. Roy
Hello thee, as an expert in excel and VBA, i can help you automate your lookup and validation process. Please contact me and let us talk more about your project. Thanks
Hi. I can easily do this. You are sure you want formulas and not some VBA solution? I can do it both ways. Instead of Vlookup I'll probably use a combination of Index match. Kind regards Fredrik
Hello! I can help you. If you can send me some of the sheets you need to validate, i can write a code for you, that will perform those actions. Let me know if you need anything else!