Formula in a cell

[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

 

[Chip Pearson]

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)

 

[Derrick]

How about if I want this:
A1 = sheet7!A15
A2 = sheet7!B15
A3 = sheet7!C15
Thanks.