ExcelHelpNeeded99
New Member
- Joined
- Oct 6, 2017
- Messages
- 13
Hi there,
Hoping someone can help.
I have a workbook with hundreds of sheets and I want to copy only for the ones with a "," in the sheet name. (These are the sheets with peoples names, one sheet per person)
All sheets are formatted the exact same way but the headers for row 2 through 33 are in column A with data in column C but on row 34 they switch to header being in row 34 with data in rows 35 through 52.
On the sheet called "Master2" I want to repeat the formal name in column A and show every event attended by that person on a separate row. Then it goes to the next sheet and does the same and so on.
Please can you help with the code?
Thanks
<tbody>
</tbody>
<tbody>
</tbody>
Hoping someone can help.
I have a workbook with hundreds of sheets and I want to copy only for the ones with a "," in the sheet name. (These are the sheets with peoples names, one sheet per person)
All sheets are formatted the exact same way but the headers for row 2 through 33 are in column A with data in column C but on row 34 they switch to header being in row 34 with data in rows 35 through 52.
On the sheet called "Master2" I want to repeat the formal name in column A and show every event attended by that person on a separate row. Then it goes to the next sheet and does the same and so on.
Please can you help with the code?
Thanks
DATA on Multiple SHEETS | Column A | Column B | Column C | Column D | ||||
Row 5 | Formal Name | Miguel Smith | ||||||
Row 34 | Date | Note | Speaker | Topic | ||||
Row 35 through 52 | 5/12/16 | xyz | Y | Politics | ||||
3/31/17 | abc | n | n/A | |||||
<tbody>
</tbody>
Master 2 | Column A (Formal Name) | Column B (Date) | Column C (Note) | Column D (Speaker) | Column E (Topic) |
Row 2 | Miguel Smith | 5/12/16 | xyz | Y | Politics |
Row 3 | Miguel Smith | 3/31/17 | abc | n | n/a |
Row4 | John Roberts | ... | ... | ... | ... |
<tbody>
</tbody>
Last edited: