Formula in a cell

  • Thread starter Thread starter Robert Gillard
  • Start date Start date
R

Robert Gillard

Each month I have to add another line to a spreadsheet so that it can auto
fill from another worksheet.

However there is a formula in each cell that is increased by 15 rows each
time i.e.
A1 = sheet7A15
A2 = sheet7A30
A3 = sheet7A45
when I drag down it adds
A4 = sheet7A46 but what I want is A4 = sheet7A60.

Can anybody help with this please.

Bob
 
Robert,

Put the following formula in A1

=INDIRECT("SHeet7!A"&ROW()*15)


and then fill down as far as you need to go.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top