Copying from one workbook to another
I want to copy data from a cell in one workbook into another. I've typed an
equal sign (=) into the target cell, switch to the other workbook, select the cell with the data I want to copy, then click enter. Sometimes it works, but other times the only thing that shows up in the target cell is the name of the workbook, cell, etc. of the workbook I'm trying to copy data from. Help, please!!! |
Copying from one workbook to another
Hi,
It sounfs like those cells for which it doesn't work are formatted as text before you enter the formula. Select one of those cells and format as general then tap F2 & enter. Mike "ptg1" wrote: I want to copy data from a cell in one workbook into another. I've typed an equal sign (=) into the target cell, switch to the other workbook, select the cell with the data I want to copy, then click enter. Sometimes it works, but other times the only thing that shows up in the target cell is the name of the workbook, cell, etc. of the workbook I'm trying to copy data from. Help, please!!! |
Copying from one workbook to another
Hi Mike,
What does the F2 and enter do? "Mike H" wrote: Hi, It sounfs like those cells for which it doesn't work are formatted as text before you enter the formula. Select one of those cells and format as general then tap F2 & enter. Mike "ptg1" wrote: I want to copy data from a cell in one workbook into another. I've typed an equal sign (=) into the target cell, switch to the other workbook, select the cell with the data I want to copy, then click enter. Sometimes it works, but other times the only thing that shows up in the target cell is the name of the workbook, cell, etc. of the workbook I'm trying to copy data from. Help, please!!! |
Copying from one workbook to another
Mike,
Thanks for your reply. Unfortunately, it didn't work. Perhaps I didn't articulate my problem well: I have the name of an organization, the org's address, phone number, etc. in separate cells in one workbook. When I use the equal sign to copy the data in those cells into the target workbook, I get the data I want for address, phone number, etc., but not for the organization's name. All of the cells in both workbooks are formatted the same. This is a real head-scratcher. Lou "Mike H" wrote: Hi, It sounfs like those cells for which it doesn't work are formatted as text before you enter the formula. Select one of those cells and format as general then tap F2 & enter. Mike "ptg1" wrote: I want to copy data from a cell in one workbook into another. I've typed an equal sign (=) into the target cell, switch to the other workbook, select the cell with the data I want to copy, then click enter. Sometimes it works, but other times the only thing that shows up in the target cell is the name of the workbook, cell, etc. of the workbook I'm trying to copy data from. Help, please!!! |
Copying from one workbook to another
Gilbert,
On it's own reformatting as general changes nothing so tapping F2 puts you into edit mode in that cell and pressing enter re-enters the formula. Mike "Gilbert" wrote: Hi Mike, What does the F2 and enter do? "Mike H" wrote: Hi, It sounfs like those cells for which it doesn't work are formatted as text before you enter the formula. Select one of those cells and format as general then tap F2 & enter. Mike "ptg1" wrote: I want to copy data from a cell in one workbook into another. I've typed an equal sign (=) into the target cell, switch to the other workbook, select the cell with the data I want to copy, then click enter. Sometimes it works, but other times the only thing that shows up in the target cell is the name of the workbook, cell, etc. of the workbook I'm trying to copy data from. Help, please!!! |
All times are GMT +1. The time now is 12:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com