I have a form (Timesheet) that is filled out daily with dropdown boxes in some cells and formulas in others and just data in yet others. What I am trying to do is create a VBA and button so that once my form is filled out, I can click the VBA button and insert the data from certain cells in my form (Timesheet), into the first empty row of DestSheet, all in one row. The empty row has no formulas or anything in the cells. Each column will have a unique header label.
I fill out two and sometimes more forms a day, each day, so I need the information saved and added to each time I finish a form and click the VBA button. The form is saved after in another location.
Seems simple enough but it has me stumped.
Bookmarks