thorpyuk
Well-known Member
- Joined
- Mar 14, 2006
- Messages
- 1,453
Hiya,
I have a spreadsheet that you can enter customer details onto. I can 'import' these details by using a search, and then change them at will.
The one problem is that I wish to export changes into a sheet called 'export'
Therein lies the problem..... I can easily enough just copy everything into the export spreadsheet, but then I can forsee the conversation approaching: "cant you just give us what has changed?"
Now, i've seen a few macros that can either add comments to a cell, or add text to an adjecant cell if anything changes, but these are no good for me for 2 reasons:
1) I use a macro to import into the sheet in the first place, and this constitues several change events in the worksheet_change module.
2) I would then need to easily export the changes, and I dont see me being able to do this easily given the method above.
Please can anyone point me in the right direction? I'm not necessarily looking for code, but any ideas you may have would be great! Thanks
I have a spreadsheet that you can enter customer details onto. I can 'import' these details by using a search, and then change them at will.
The one problem is that I wish to export changes into a sheet called 'export'
Therein lies the problem..... I can easily enough just copy everything into the export spreadsheet, but then I can forsee the conversation approaching: "cant you just give us what has changed?"
Now, i've seen a few macros that can either add comments to a cell, or add text to an adjecant cell if anything changes, but these are no good for me for 2 reasons:
1) I use a macro to import into the sheet in the first place, and this constitues several change events in the worksheet_change module.
2) I would then need to easily export the changes, and I dont see me being able to do this easily given the method above.
Please can anyone point me in the right direction? I'm not necessarily looking for code, but any ideas you may have would be great! Thanks