Update new Sheet only with Modified rows from parent sheet

[Nomas]

Hi,

Hopefully I can explain what I'm looking for. I have created a tool (with the help of several on this site) that populates a sheet for exporting (only certain columns) to a .csv from a master sheet. The master sheet has 10,000 or so rows that are fixed for the most part but many columns in these rows may be modified. What I am looking for is a way for the sheet that needs to be exported to excel to only grab rows from the master sheet that have been modified from the last time I exported or opened the file, til the time I run the export macro. I had thought about having a check field on the master if modified and only copy the line if the field is checked but my concern is modifications done and the field isn't checked and they aren't exported. Sorry for the long explanation. Appreciate any guidance

 

[VoG]

The simplest way would be to delete the contents of the csv then run the code.

 

[Nomas]

Thanks, the problem is creating a safety check to make sure that needed rows arent accidentally deleted on top of excess manual labor. I'm assuming what I was looking for would be pretty hard to do. Manually removing rows means I would have to keep track of the rows modified. What I was thinking is that basically upon startup the workbook creates a mirror image of the master file as its currently populated. The export tab prior to exporting would need a formula that would check the master tab with the mirror image file row by row and if there was a variance in any of the cells in the row it would populate to the export tab to be exported as a csv. I ll play around with it a bit, thanks for responding.