Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating an advanced Macro
I am new to macros in excel but need to create one I believe to get what I
want. My problem is I am given a spreadsheet that has one one sheet. The one sheet has a class list of students for all the different classes we have this week (more than 40) each class "roster" starts and ends with the same cell first row starts with "Company Name" Last cell for that given class roster ends with "Page 1 of 1" What I would like is a macro that will separate each roster on to a new sheet, the problem some rosters are 30 rows while others can be as many as 40 so I don't know how to have excel select a range of cells to copy and paste to a new sheet by whats in the cells. I can't change how the initial sheet is setup in any way. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating an advanced Macro
Start here
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sean" wrote in message ... I am new to macros in excel but need to create one I believe to get what I want. My problem is I am given a spreadsheet that has one one sheet. The one sheet has a class list of students for all the different classes we have this week (more than 40) each class "roster" starts and ends with the same cell first row starts with "Company Name" Last cell for that given class roster ends with "Page 1 of 1" What I would like is a macro that will separate each roster on to a new sheet, the problem some rosters are 30 rows while others can be as many as 40 so I don't know how to have excel select a range of cells to copy and paste to a new sheet by whats in the cells. I can't change how the initial sheet is setup in any way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter Macro | Excel Discussion (Misc queries) | |||
Advanced Filter Macro | Excel Discussion (Misc queries) | |||
ADVANCED FILTERS WITH MACRO | Excel Discussion (Misc queries) | |||
creating an advanced employee schedule | New Users to Excel | |||
Advanced macro | Excel Discussion (Misc queries) |