Copying data from one workbook to another

A

Amber T

I have a weird issue in Excel 2007

If I have two workbooks open. I choose the cell I want data to go to in
workboo1 so I put in "=" (without the quotes) in that cell. Then I go to
workbook2 and choose a cell that has data in it. I hit enter and nothing
happens. Usually it sort of highlights around the cell and when I hit enter
the data from workbook2 goes to the cell in workboob1. But that isn't
happening.

I had someone with the exact same issue, and they just kept trying it over
and over and it worked one time, then it stopped working again. What am i
missing?
 
G

Gord Dibben

Might be you have the two workbooks open in separate instances of Excel.

Close one instance and open both workbooks in one instance.


Gord Dibben MS Excel MVP
 

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

To copy Data from a row in one wrokbook and insert in a sheet of another workbook 0
Adding data to MS Access from csv file 0
Copying data from one workbook to another dependent on user select 1
STOP close button on another workbook 6
Open UserForm From A Different Workbook 17
Using VB to pull formats and data from another workbook 0
drop-down list in a workbook while the list's data's on another w/ 2
Return Rows from another workbook 7

Top