Dear Friends,
I hope you can help me to come up with some VBA programming with the following pseudocode.
I try to search around the internet but unable to find one best fit with my requirement.
Pseudocode below:
Workbook1, sheet 'master'
Workbook2, sheet 'client'
workbook1 ALL column A is date, column B onwards is interger
workbook2 ALL column A is date, column B onwards is interger
A button contain the VBA programming name as "RUN" in workbook1 which will execute the algorithm below.
Compare workbook1, A2 column onwards with workbook2, A2 column onward until null
IF MATCH
copy entire row data from workbook2 to workbook1 position where it detect A column matched.
End IF
many thanks in advance.
Bookmarks