Posted By -
J
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
Copyright © 2021 | Truelancer.com