Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grouping Rows
Just as a follow up to this, now that i have the project rows in Sheet 2, i need to group them in 3's so that i can collape and expand to overall project overviews or detailed view. It there an easy way to group each project without doing them individually by highlighting and going to DATA -- GROUP AND OUTLINE -- GROUP, which will take some time if i have to do it for each project set! "Seftyby" wrote: Perfect!!! Just what i was looking for, thanks mama! "Teethless mama" wrote: Try this: =INDEX(Sheet1!C:C,INT((ROWS($1:1)-1)/3)+1) copy down as far as needed "Seftyby" wrote: Hi, Hopefully someone can help, this seems easy but just can't think how to do it without macros etc... I have 2 sheets, on sheet 1 i have a list of project titles in column C, now in sheet 2 i have a resource planner that dedicates 3 rows to each project in sheet 1. As i am doing VLOOKUPS in Sheet 2 i need to reference the project titles, so in the second sheet in column A i want to copy each project title 3 times in column A on consecutive rows, then move onto the next for a further 3 times etc... So i want Sheet 2 to look like this: Project A Project A Project A Project B Project B Project B etc... and i need to copy paste this all the way down the spreadsheet for any newly added project in Sheet1. What formula do i need to use so i can copy down easily and pull in the project names to sheet 2 in the way that i need. Thanks for any help in advance. NP |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grouping Rows
Select your range Data Subtotals OK out
"Seftyby" wrote: Just as a follow up to this, now that i have the project rows in Sheet 2, i need to group them in 3's so that i can collape and expand to overall project overviews or detailed view. It there an easy way to group each project without doing them individually by highlighting and going to DATA -- GROUP AND OUTLINE -- GROUP, which will take some time if i have to do it for each project set! "Seftyby" wrote: Perfect!!! Just what i was looking for, thanks mama! "Teethless mama" wrote: Try this: =INDEX(Sheet1!C:C,INT((ROWS($1:1)-1)/3)+1) copy down as far as needed "Seftyby" wrote: Hi, Hopefully someone can help, this seems easy but just can't think how to do it without macros etc... I have 2 sheets, on sheet 1 i have a list of project titles in column C, now in sheet 2 i have a resource planner that dedicates 3 rows to each project in sheet 1. As i am doing VLOOKUPS in Sheet 2 i need to reference the project titles, so in the second sheet in column A i want to copy each project title 3 times in column A on consecutive rows, then move onto the next for a further 3 times etc... So i want Sheet 2 to look like this: Project A Project A Project A Project B Project B Project B etc... and i need to copy paste this all the way down the spreadsheet for any newly added project in Sheet1. What formula do i need to use so i can copy down easily and pull in the project names to sheet 2 in the way that i need. Thanks for any help in advance. NP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grouping rows | Excel Discussion (Misc queries) | |||
grouping rows... | New Users to Excel | |||
Empty rows after grouping | Excel Discussion (Misc queries) | |||
Grouping Rows | Excel Discussion (Misc queries) | |||
Grouping rows together | Excel Worksheet Functions |