gathering multiple spreadsheets into one
 

I have 2 worksheets (2 individual XLS files) that I need to bring together
into a single worksheet.

The first column of each spreadsheet is the "persons" ID number.

I want to append the in worksheet 1 with the data in worksheet 2, based upon
the ID number. The data in worksheet 2 is a mix of text, number, phone
number, etc.

Is there a single formula I can use to bring it all in based upon the ID
numbers in column A?

eg.

WS1 WS2
123|Mark 157|trans|(201)646|2008 Event|Yes
124|Harry 123|mortg|(732)995|2008 Event|No
129|Dave 762|rund|(676)423|2007 Event|Maybe
129|mortg|(212)123|2008 - Trip|Yes
124|party|(919)222|2006 - Trip|No

DESIRED RESULT IN WS1
123|Mark|mortg|(732)995|2008 Event|No
124|Harry|party|(919)222|2006 - Trip|No
129|Dave |mortg|(212)123|2008 - Trip|Yes

gathering multiple spreadsheets into one
 

Are the | representing a tab? or is it a character?
I believe you first need to do a Text to columns on each of the worksheets,
then you can easily create a vlookup based on WS1 returning from WS2 and if
you need it all together concatenating afterwards.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Mark B" wrote:

I have 2 worksheets (2 individual XLS files) that I need to bring together
into a single worksheet.

The first column of each spreadsheet is the "persons" ID number.

I want to append the in worksheet 1 with the data in worksheet 2, based upon
the ID number. The data in worksheet 2 is a mix of text, number, phone
number, etc.

Is there a single formula I can use to bring it all in based upon the ID
numbers in column A?

eg.

WS1 WS2
123|Mark 157|trans|(201)646|2008 Event|Yes
124|Harry 123|mortg|(732)995|2008 Event|No
129|Dave 762|rund|(676)423|2007 Event|Maybe
129|mortg|(212)123|2008 - Trip|Yes
124|party|(919)222|2006 - Trip|No

DESIRED RESULT IN WS1
123|Mark|mortg|(732)995|2008 Event|No
124|Harry|party|(919)222|2006 - Trip|No
129|Dave |mortg|(212)123|2008 - Trip|Yes

gathering multiple spreadsheets into one
 

The | repersents seperate cells, or maybe I should have used a comma, but
either way I have no clue what you are recommending....