I hope i am explaining this properly:
I have a formula =IF(Master!$B2="","",Master!$B2) on a page going down a
column and when i delete rows i want it to begin again at
=IF(Master!$B2="","",Master!$B2) not B45 or whatever the last row was. How
do it get it to go back to the beginning?

Thanks

does this idea help.
=INDIRECT("Sheet7!b"&ROW(A1))

--
Don Guillett
SalesAid Software

"Laur" wrote in message
...
I hope i am explaining this properly:
I have a formula =IF(Master!$B2="","",Master!$B2) on a page going down a
column and when i delete rows i want it to begin again at
=IF(Master!$B2="","",Master!$B2) not B45 or whatever the last row was.
How
do it get it to go back to the beginning?

Thanks

or put this on row 2
=INDIRECT("Sheet7!a"&ROW())

--
Don Guillett
SalesAid Software

"Laur" wrote in message
...
I hope i am explaining this properly:
I have a formula =IF(Master!$B2="","",Master!$B2) on a page going down a
column and when i delete rows i want it to begin again at
=IF(Master!$B2="","",Master!$B2) not B45 or whatever the last row was.
How
do it get it to go back to the beginning?

Thanks

Thanks I appreciate it but i can't even figure out what that means. Maybe
i didn't explain it right. I have a 'master' worksheet i use everyday on the
first sheet is the numbers i input and when i go to the other sheets to do
the calculations they are no longer in order (as i've sorted this way and
that way etc.) So then i have to put the formulas back in again because now
row 2 is taking the information from row 45 so i go to 100 different cells
and change all the 45's to 2's.

Thanks again.

"Don Guillett" wrote:

or put this on row 2
=INDIRECT("Sheet7!a"&ROW())

--
Don Guillett
SalesAid Software

"Laur" wrote in message
...
I hope i am explaining this properly:
I have a formula =IF(Master!$B2="","",Master!$B2) on a page going down a
column and when i delete rows i want it to begin again at
=IF(Master!$B2="","",Master!$B2) not B45 or whatever the last row was.
How
do it get it to go back to the beginning?

Thanks