This needs to be scripted using Visual Basic. Find an Excel programmer who
can do this for you.


"Karina" wrote in message
...
I would like to make one worksheet pull from the master worksheet, so that
if
a row is added in the master, it is automatically added into the new
worksheet. This does not work by using a formula new B2=Master!B2. I need
a
formula that is something like new B2=Master!B1+1 where 1 is not a number
but
is the cell below B1 (ie B2 or what used to be B3 etc etc)