Please help me to create VBA code
I have saved 5 excel files in one folder (as sample). C:\test\
Each Files having unique data in column B, C and J
I want to track the changes of column J amount in each excel files.
if any row having variance in one workbook to another, then this need to be copied to the result excel file as above.
All version of excel file data updated in result file ( only for if its changed from one work book to another workbook)
Result
Column B and C is from the Work book 1 to %
Row D4 to G4 is file name which we are comparing
wherever the numbers are varying that need to be populated
And Column B and C is fixed one. Column J is not fixed one this may be column I or column K…..
So before running the macro column J(amount) to inputed through message box. Like if its K then all work book its K only
Bookmarks