| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Gathering data from multiple worksheets | Excel Discussion (Misc queries) | |||
| Gathering and Combinging Data in 2 Spreadsheets | Excel Worksheet Functions | |||
| gathering data | Excel Discussion (Misc queries) | |||
| Statistic Gathering | Excel Discussion (Misc queries) | |||
| How to update multiple links in multiple spreadsheets followin mo. | Excel Worksheet Functions | |||
Linear Mode
