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