1 Attachment(s)
Macro to export data from certain cells
Hello,
I have a sheet (sheet1) which is used by different users many times to create some documents.
After creating the document, the data entered is deleted and new data is entered.
I want to capture information from certain cells each time to another sheet (sheet2) and data should remain there even if the data in sheet1 is deleted for new data entry.
The new data entered should get added to sheet2 below first data and so on.
I have attached a sample sheet.
Can anybody help?
Thanks in advance