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
|