Hello,
I am new to the forum. What I am trying to accomplish is to have a data entry form on a Sheet called "Data Copy" and then transfer that data that is collected into a table on the Sheet "Data". Each time a line of data is entered on the Data Copy sheet, the user will push a button to activate the macro which will transfer the line of data to the Data sheet, building a table of data, save the data/file and then clear the data on the Data Copy sheet.
I am trying to create a macro that will do the following:
1. From sheet "Data Copy", copy the values in a row of data from A2:N2. Some of the data is selected from drop down lists and I only want to copy the values.
2. Paste or insert the values A2:N2 from "Data Copy" to another sheet called "Data" after inserting a blank row or inserting the values at the top in Cells A2:N2 (row 1 will contain headers)
3. Save the data
4. Clear or delete the data/values in the "Data Copy" sheet A2:N2
Your help is much appreciated in advance.
Cheers!
Jim
Bookmarks