transporting repetitive data from another sheet

[drmcleod]

How do I transport data from another sheet in a repetitive order?

For example:

In Column A I would like to transport data from sheet 3, however the data in
sheet 3 skips every 4th line (row 4, 8, 12, 16, etc.).

I have the formula ='Sheet3'!$E4
The next row should have ='Sheet3'!$E8
etc.

When I highlight a series of these cells (all typed correctly and skipping
by 4's) and drag the fill tool down (cross hair at bottom right of cell) it
does not fill properly.

 

[Bernard Liengme]

Try =INDIRECT("Sheet3!E"&ROW(A1)*4)
Do not alter the A1 - this just gets serial numbers 1,2,3, as you copy down
any column
best wishes

 

[drmcleod]

Thank you but this did not work.

Try =INDIRECT("Sheet3!E"&ROW(A1)*4)
Do not alter the A1 - this just gets serial numbers 1,2,3, as you copy down
any column
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

 

[Bernard Liengme]

Can you expand on "did mot work"?
It seemed to do just what you wanted when I rand it I got links to
E4,E4,E12... on the other sheet
Happy to have you send me a file (remove TRUENORTH.)
best wishes

 

[Gord Dibben]

First you stated your data in sheet3 "skips" every 4th line(row 4, 8, 12,
16, etc.)

Then you posted your formulas which would retrieve every 4th line.

Which do you want............."skip" or "retrieve"?

Bernie's formula will retrieve every 4th line.


Gord Dibben MS Excel MVP