edistogumbo
New Member
- Joined
- Nov 4, 2002
- Messages
- 1
If you fill down a formula such as
=('sheet(2)'!A$3) you get this same formula in each cell you filled. How can you get the following results:
=('sheet(2)'!A$3)
=('sheet(3)'!A$3)
=('sheet(4)'!A$3)
=('sheet(5)'!A$3)
etc.
I need the sheet # in the formula to grow linearly while keeping the absolute reference cell on each sheet the same
=('sheet(2)'!A$3) you get this same formula in each cell you filled. How can you get the following results:
=('sheet(2)'!A$3)
=('sheet(3)'!A$3)
=('sheet(4)'!A$3)
=('sheet(5)'!A$3)
etc.
I need the sheet # in the formula to grow linearly while keeping the absolute reference cell on each sheet the same