Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge 2 spreadsheets info to 1 | Excel Worksheet Functions | |||
How do I merge 2 excel spreadsheets containing some common info? | Excel Worksheet Functions | |||
How do I merge two spreadsheets so it removes the duplicates? | Excel Worksheet Functions | |||
merge 2 spreadsheets | Excel Discussion (Misc queries) | |||
How do you merge two spreadsheets to update data. | Excel Discussion (Misc queries) |