Formula using cell reference from different sheet

  • Thread starter Thread starter SLaney
  • Start date Start date
S

SLaney

I need to know how to show what is in a cell from another
worksheet. The catch is that the cell on the other
worksheet is constantly changing.

Example: Worksheet A is a log of all incoming requests:
Column A is the request number, Col B is "To", Col C
is "From" and Col D are the items requested.

Worksheet B is a form that can be printed. It has cells in
it that reflect the data in Worksheet A. As a new order
comes in and the data is entered in on Worksheet A I want
it to be reflected on Worksheet B so I can print a copy.

How do I reference the last row in Worksheet A, because it
will be constantly changing each time a new order comes in.

For example if I want to show the data in cell D4 on
Worksheet A how do I do that when I add a new row (ie.
5,6,7,etc)

Any help would be great.

Thanks,

-Shon
 
Hi
if you do not have any blanks in this column try the following:
=OFFSET('worksheet A'!$D$1,COUNTA('worksheet A'!$D$:$D)-1,0)

Frank
 
Back
Top