I need help....

[filling cells from different tabs]

I am trying to do something simple I am sure but I can not figure it out..

I have 2 different sheets/tabs and on (sheet1) cell A3 I want the number to
automatically be filled in on (sheet 2) cell B7

So what ever I fill out on the 1st sheet will be filled in on the 2nd..

Is there a way?

 

[JMay]

Click on your cell B7, sheet2

enter = (then click on the tab of sheet1 and click on cell A3 then
press the enter key. Done

 

[pfsardella]

Place this formula in cell B7 on Sheet2
=Sheet1!A3

Paul

 

[Dave Peterson]

Another technique:

Select the "sending" cell.
Edit|copy

Select the "receiving" cell.
Edit|Paste special|click Paste Link

You'll end up with a formula like:
=sheet1!a3

You may want to modify it to:
=if(sheet1!a3="","",sheet1!a3)

This formula will make it look like the cell is blank when the sending cell is
really empty.

(The simple formula will return 0 if the sending cell is really empty.)

 

[filling cells from different tabs]

Awesome, Thank you so much.....

Click on your cell B7, sheet2

enter = (then click on the tab of sheet1 and click on cell A3 then
press the enter key. Done