Compare Proposal

Nothing to compare.

VBA to Compare Worksheets and Merge Data

  • Posted at : 2 months ago
  • Post Similar Project
10

Budget
7
Proposals
86
Views
Expired
Status
Skills Required

Posted By -

J

USA
0.0
Projects Posted : 1
Projects Paid : 0
Services Purchased : 0
Total Spent :
0
Feedbacks : 0 %

Project Details show (+) hide (-)

This is a signoff list for files reviewed, every time the files/folders are added to or deleted from the folder, the list should update every time it opens while reserving the Sign-Off columns aligned and intact.

Suggested solutions:
After generating files list,
'1. Compare "Keep" vs "Temp" row by row B2:Z lastrow
'2. If difference in row, copy "Temp" row to "Keep" row by inserting a new row in Keep in the current position or delete extra row in Keep
'3. In the end "Keep" B2:Z lastrow SHOULD be identical to "Temp" B2:Z lastrow without effecting other data in Keep