After using "= A1" how do you merge info from the 2 spreadsheets?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

plittle - 16 May 2006 19:41 GMT

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 to this Message

Paul B - 16 May 2006 20:09 GMT

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

Signature

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

>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
[quoted text clipped - 7 lines]
>
> I am new at all of this so . . . . Thank you.

Reply to this Message