reference while skipping rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the easiest way to fill down referenced data from a column so that
the data skips rows? Loads to do and spread unevenly around various sheets.
e.g.
A1: 5
A2: 10
A3: 15

goes to

A1: 5
A2:
A3: 10
A4:
A5: 15
Cheers

M
 
In A1 enter 5,
In A3 enter 10,
Then select A1:A4

Click on the fill handle of the 4 cell selection, and drag down to copy as
needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


What is the easiest way to fill down referenced data from a column so that
the data skips rows? Loads to do and spread unevenly around various sheets.
e.g.
A1: 5
A2: 10
A3: 15

goes to

A1: 5
A2:
A3: 10
A4:
A5: 15
Cheers

M
 
sorry, wasn't clear
cells A1, A3, A5 etc are refering to other data spread around the worksheet
in columns
e.g.. A1, A3, A5 contain
=B1, =B2, =B3
(5, 10, 15 was just an example)
 
Back
Top