Increment Cell Reference using Indirect

Joined
Aug 25, 2010
Messages
2
Reaction score
0
Hi guys,

I have a master sheet with a bunch of shots. I want to be able to update it, and have another sheet accomodate the insertion or deletion of shots. I was trying to do this by using the INDIRECT function to reference the page "master" but with a formula that I could easily copy down several rows and it would increment. Basically, I want all of my second sheet rows to correspond with the master sheet rows, but if i insert or delete something, i want them to keep the value of that current row and not slide with the adding or removing of rows. Does that make sense? Appreciate any help.

T
 
Back
Top