how do I copy the contents of a cell from one workbook to another

G

Guest

How do I copy the contents of a cell from one workbook to another (as a
formula)? I tried '=[workbook name]worksheet name!cell name' but that
doesn't seem to work
 
G

Guest

Start by selecting the cell where you want to 'copy' the other cell to. Type
an equal sign, press Ctrl-F6 until you get to the other workbook, and select
the cell you want. Press Enter
 

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
Excel Highlighting duplicates 0
Get location of match in another worksheet 2
Reference to a Defined Name in another Workbook 1
Excel Protection 2
Can I use a worksheet name in a formula? 4
trouble copying a cell from one workbook to a new one 2
Using names referencing a cell in another workbook 2

Top