Updating Summary Sheet from Newly Created Sheet

**Applem21** · 09-03-2010, 01:44 PM

I have a workbook that contains a sheet with data for each workshop we conducted on a project. When a new workshop is conducted, a new worksheet is created from a template. When the new worksheet is created, I need to update the master (or summary sheet) with a row of the new data. The worksheets are all set up the same, and all the data I need is in one row. I am new to creating Macros, but below is what I tried to do. Instead of copying from the new sheet, it always copies from the same one. How do I get it to always copy from the new sheet into the last row in the master?

Please Login or Register  to view this content.

**mrice** · 09-04-2010, 08:01 AM

Can you post a copy of the actual workbook - this would make it much easier to deduce what is going on.

**snb** · 09-04-2010, 08:20 AM

Maybe:

Please Login or Register  to view this content.

**royUK** · 09-04-2010, 09:08 AM

See the summary sheet example

**Applem21** · 09-07-2010, 01:11 PM

The sheet is not actually a summary sheet based on the way that a summary sheet is described in the link RoyUK provided. It is not a sum of the data, it's just a master sheet with all the data listed in one worksheet. The worksheet I want to move the new data to is a master tab. The new data I want to move over to the master sheet is all in one row on the template (or new worksheet). I want to copy the data from the row in the new worksheet to the last row on the master sheet. And each time I have a new worksheet (based on the template), I want the last row on the master sheet to update.