Hi Guys
Need some help here,
Looking to automate my daily task using VBA.
Got this master file with list of customer's id (column A - Alphanumeric). What I'm trying to do is to run a code from the master file which will :-
1) Loop Master file - column A starting from cell A3 and try to find a match from a bunch of Data files located in a different folder.
2) When there's a match, VBA will copy & paste the whole row from Data to the Master (paste in B3)
3) Loop will continue with next row A4, A5 and so on until cell value =equals blank
Thanks in advance, really hope there's something to make my work easier.
Need some help here,
Looking to automate my daily task using VBA.
Got this master file with list of customer's id (column A - Alphanumeric). What I'm trying to do is to run a code from the master file which will :-
1) Loop Master file - column A starting from cell A3 and try to find a match from a bunch of Data files located in a different folder.
2) When there's a match, VBA will copy & paste the whole row from Data to the Master (paste in B3)
3) Loop will continue with next row A4, A5 and so on until cell value =equals blank
Thanks in advance, really hope there's something to make my work easier.