Benoitwysocki
New Member
- Joined
- Nov 24, 2017
- Messages
- 2
Hi everyone,
I am currently working on a macro to apply a Vlookup on two different excel sheets.
Actually, I wish to make sure that What is in sheet 1 is also in sheet 2. For this I have to make sure that for the same name the amount in the worksheet 1 is the same in work sheet 2.
Example if I have securityABC = $100 in worksheet 1 I want to make sure that I have a securityABC =$100.
I have two questions:
1) The number of lines is very huge, is there any limit that will constraint me with a macro ?
2) What code should I use to do this reconciliation btw the 2excelsheets and how I can highlights discrepancies if there is any?
The objective is to replace the manual check that I do with a Vlookup.
Feel free to provide me your opinion
Best,
Ben
I am currently working on a macro to apply a Vlookup on two different excel sheets.
Actually, I wish to make sure that What is in sheet 1 is also in sheet 2. For this I have to make sure that for the same name the amount in the worksheet 1 is the same in work sheet 2.
Example if I have securityABC = $100 in worksheet 1 I want to make sure that I have a securityABC =$100.
I have two questions:
1) The number of lines is very huge, is there any limit that will constraint me with a macro ?
2) What code should I use to do this reconciliation btw the 2excelsheets and how I can highlights discrepancies if there is any?
The objective is to replace the manual check that I do with a Vlookup.
Feel free to provide me your opinion
Best,
Ben