Advancing Down A List

M

Minitman

Greetings,

I have a list of names in column A of sheet 1, I want to have a
dynamic copy of this list in column A of sheet 2. Sheet 2 uses 3 rows
per record and sheet one uses one row per record.
I tried the usual A2+1 in A3 and got the #VALUE! error.

How can I advance each record on sheet 2 so that it matches sheet 1?

Any help would be appreciated.

-Minitman
 
M

Max

Assuming names are listed in Sheet1, in A1 down

In Sheet2,

Put in the starting cell, say, A1:
=IF(MOD(ROW(A1),3)=1,
INDIRECT("Sheet1!A"&INT((ROWS($A$1:A1)-1)/3)+1),"")

Copy A1 down as far as required

The above will return the names from Sheet1 in sequence,
interspersed with 2 blank rows in-between each name
 
M

Max

And if you're simply wanting to "triplicate" the names over from Sheet1,
just use in the starting cell in Sheet2, and copy down:
=INDIRECT("'Sheet1'!A"&INT((ROWS($A$1:A1)-1)/3)+1)
 
M

Minitman

Hey Max,

Thanks for the reply.

Does it make any difference if each set of three cells on sheet 2 are
merged or do I need to unmerge them?

Looking forward to your reply.

-Minitman
 
M

Max

Minitman said:
.. Does it make any difference if each set of three cells
on sheet 2 are merged or do I need to unmerge them?
Click to expand...

The assumption is that no cells are merged (but of course! <g>)
 
M

Minitman

Hey Max,

Thanks for the clarification.

That part is now complete, on to the next step.....

-Minitman
 
Top