Automatically copy a cell from one worksheet to another

  • Thread starter Thread starter SHARON
  • Start date Start date
S

SHARON

This seems to be a simple task, however it is not working for me right now...

I want to be able to type in cell C5 on one worksheet. I want that cell to
automatically copy over to another worksheet in cell D3...
 
Hi Sharon,
Suppose that the worksheet which contains the information in cell C5 is
called AA and the folder is named Month Differences so in cell D3 enter the
formula as follow

='[AA.xls]Month Differences'!$C$5 change names to fit your sheet and tab names

If this helped please say yes, thank you
 
Both sheets in same workbook then use this in D3
=Sheet1!C5

assuming that the C5 you want is in Sheet1

Easiest way is to type
=
in D3 then switchover to the sheet having D5 and click on D5 and then press
enter...
 
In your D3 cell, enter

='Sheet1'!C5

Change "Sheet1" to the appropriate sheet. This formula will pull the
value from C5 on Sheet1.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top