I have attached a a spreadsheet to this thread for reference.
I need to get the data from the sheet 1 added to the sheet 2 by clicking on the ADD DATA button in the sheet 1.
The sheet 1 will be filled in multiple times like a form by the users, so once the data is added to the sheet 2 I would like sheet 1 to have no data filled in the column to the right.
The data will be only filled in the right column, thus the left column should not be copied to the sheet 2.
Please hep me with a way to solve this problem.
Thanks in anticipation!
Bookmarks