I am creating an expense report that has a macro that sends the filled out
report to the employee's manager and then clears the form. I want to add a
macro to the same button that will take the data from the cells and transfer
it into a database that will add a line on 'page 2' of the worksheet. For
example, person 1 fills out the form and when they click the button it saves
their data in row 2 on page 2. Person 2 fills out the form and it saves
their data in row 3 on page 2.
How would I do this? Thanks.