Summary Sheet - A Macros???

[JamestheLion73]

I have a Spread sheet I am working on. It is a template for our clients who are sending us registration information for various classes. What we want is for them to enter in information per week, so I alrady have one sheet for every week. What I want is a final sheet that will give a summary - so that they can look at one sheet and see all the names of the people they have sent us - sort of a summary of all the prior sheets - or a global list. Ideally it would be great for it to be automatically exported to the final sheet. Is there a way to do this?!?!?! I assume it will be a macros. I just need the final sheet to capture the names (or all the info) of the people entered on the previous sheets.

Any help is greatly appreciated! Thanks.

 

[WillR]

Why have a sheet for every week??

Why not just add a field (column) to the data they send you which is date releted (i.e. Week Number or Week Commencing Date)

Then you could just sort your data by weeks, Months etc, adding subtotals between periods if you need to...

 

[jimboy]

Try this, copy for each sheet you have

Sub copy_to_master()

Sheets("Sheet1").Select
Range("A65536").Select
Selection.End(xlUp).Select
ActiveCell.Activate
Range("H1", ActiveCell).Select 'change to last column (if you have headers in row 1 change to H2
Selection.Copy
Sheets("Master").Select
Application.Goto Reference:="R65536C1"
Selection.End(xlUp).Select
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
End Sub

 

[JamestheLion73]

First in reply to jimboy - THANK YOU THANK YOU THANK YOU. I will try this and let you know if it fails miserably or if it works ok... I really do appreciate the help!


Second in reply to Will - the reason we need a sheet for each week is because there is usually quite a bit of data on each sheet and when they send us the info - it is usually a hardcopy. What we wanted was to be able to keep from sorting through 20 - 30+ sheets for the new info. We could rely on them to sort it before sending, but in reality we can't expect them to do that consistently. So the sheet for each week was the best solution.... or so we are hoping