So I have 2 workbooks, 1 which is always open for editing, and another which just stores data.
When a userform is opened in the first workbook, the user fills the form in, clicks submit, which opens the 2nd workbook, posts the data to the first empty row of sheet1, saves the 2nd workbook and then closes it.
However what I want to add, is between saving and closing the 2nd workbook, I would like to replace sheet1 in the 1st workbook with a copy of sheet1 in the 2nd workbook.
How would I go about doing this?
When a userform is opened in the first workbook, the user fills the form in, clicks submit, which opens the 2nd workbook, posts the data to the first empty row of sheet1, saves the 2nd workbook and then closes it.
However what I want to add, is between saving and closing the 2nd workbook, I would like to replace sheet1 in the 1st workbook with a copy of sheet1 in the 2nd workbook.
How would I go about doing this?
