transporting repetitive data from another sheet

  • Thread starter Thread starter drmcleod
  • Start date Start date
D

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.
 
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
 
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
 
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
 
Back
Top