I'm having issues getting table 1 to clear.
See attached.
Table1 is on the tab "Input"
Table2 is on the tab "MasterTable"
When table 1 is blank, it should only have 1 entry row. If the user wants to input 3 rows, tables automatically grow if the user inputs a 2nd record, or a 3rd, and so on.
After the user inputs as much as they want, they will click the button to move the newly input data into the MasterTable (table2)
But then I need to come back to Table1 and clear what they had input, and I also want Table1 to have only 1 new row ready for input for the next user.
I think I'm close, but it just doesn't work. I currently have 3 lines of code to clear Table1 remarked out.
How do I fix this?
Bookmarks