Hi all, looking to write a code to make my work simpler. Basically there are two tabs I work with, one is the master tab ("Master" tab) and the other tab ("Updated" tab) with updated data each month.
Hope anyone can advise on the code to fulfil the below purpose:-
1. Find, in column A (starting from cell A2 to the last cell A that is Non-Blank) of the "Updated" tab, using the text in cell B2 of the "Master" tab;
2. If the Find is successful at row X of the column A ("Updated" tab), replace cells D2, E2, F2 of the "Master" tab with values of the matched row X (in "Updated" tab), cells KX, LX, MX respectively;
3. If the Find is not successful, skip error.
4. Repeat step 1 for next cell B3 of the "Master" tab;
5. End process when the macro reaches the last cell of column B having text i.e. the next cell B is blank.
The macro needs to run fast for a few thousand iterations hence would appreciate any advice on improving my above logic as well!
Thanks for any advice!
Hope anyone can advise on the code to fulfil the below purpose:-
1. Find, in column A (starting from cell A2 to the last cell A that is Non-Blank) of the "Updated" tab, using the text in cell B2 of the "Master" tab;
2. If the Find is successful at row X of the column A ("Updated" tab), replace cells D2, E2, F2 of the "Master" tab with values of the matched row X (in "Updated" tab), cells KX, LX, MX respectively;
3. If the Find is not successful, skip error.
4. Repeat step 1 for next cell B3 of the "Master" tab;
5. End process when the macro reaches the last cell of column B having text i.e. the next cell B is blank.
The macro needs to run fast for a few thousand iterations hence would appreciate any advice on improving my above logic as well!
Thanks for any advice!