Automatically copy a cell from one worksheet to another

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

Eduardo

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
 
S

Sheeloo

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

Chip Pearson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Grabbing a number from another cell on another worksheet 2
Worksheet Change Event - copy cell to another sheet 2
Pulling data from one cell to another 3
Copy data from once worksheet to another using formula 2
If/Then Formula Help Needed 3
Sending data from one cell to another 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Top