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
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