ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   After using "= A1" how do you merge info from the 2 spreadsheets? (https://www.excelbanter.com/setting-up-configuration-excel/88957-after-using-%3D-a1-how-do-you-merge-info-2-spreadsheets.html)

plittle

After using "= A1" how do you merge info from the 2 spreadsheets?
 
I am trying to take information already on one spreadsheet and incorporate
some of it into a second spreadsheet used for a different purpose. I have
done the
"in cell A1 of spreadsheet2 type =
then go to spreadsheet1 cell A1 and press return"

that put codes in the colums for me but now how do I get the information to
transfer/merge into the 2nd spreadsheet?

I am new at all of this so . . . . Thank you.

Paul B

After using "= A1" how do you merge info from the 2 spreadsheets?
 
plittle, sounds like the cell in spreadsheet2 was formatted as text, format
it as something else and the type = and select spreadsheet1 A1 and enter
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"plittle" wrote in message
...
I am trying to take information already on one spreadsheet and incorporate
some of it into a second spreadsheet used for a different purpose. I have
done the
"in cell A1 of spreadsheet2 type =
then go to spreadsheet1 cell A1 and press return"

that put codes in the colums for me but now how do I get the information
to
transfer/merge into the 2nd spreadsheet?

I am new at all of this so . . . . Thank you.





All times are GMT +1. The time now is 10:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com