Creating an archive sheet.

[Arganth]

Hi all, please could someone help a newbie poster?

Basically I've a workbook which is full of sheets copied from a master, plus a summary sheet, an archive sheet and the master. I want to create a macro which will take certain data from sheet n, copy just that data into the next available row on the archive sheet, then delete sheet n without losing the newly added data in the archive.

Is this possible? The problem I seem to be having so far is referencing a sheet which has just been deleted!

Thanks in advance.

 

[royUK]

Don't delete the sheet, just clear the cells contents (if not formula) and use the same sheet. in other words set up a form to enter your data then transfer the data before clearing it

 

[Arganth]

Thanks for the suggestion.

The problem is there won't necessarily be a fixed amount of sheets in the book, and removing a sheet is fairly important to keep things simple for the user.