Formulas?

L

Laur

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
 
L

Laur

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