Switching sheets and copying data

[jram]

I could do with some help as struggling with switching between sheets. I'm trying to write a code which:

1. If the data is for a new person is create a spreadsheet with their name and adds a groupnamed tab
2. If not a new person, then adds a new group in the existing sheet after the last group name
3. Copies the data from the master workbook template sheet into the current group tab (in new or existing sheet) and saves
4. If the next person is different then it closes the sheet
5. Returns to the master sheet

I would be really grateful if someone could help me solve this.
Thanks
James

Please Login or Register  to view this content.

[patel45]

your code starts with If lastperson <> Person Then
but lastperson and Person are not defined

[jram]

Yes, sorry, I have defined those earlier in the code. Can you assume the all the string variables have been defined.