| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
append worksheet with data from another
I have 2 worksheets that I need to bring together into a single worksheet.
The first column of each worksheet is the "persons" ID number. I want to append the data 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? example... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i append old and new data in excel | Excel Worksheet Functions | |||
| Auto append data | Excel Discussion (Misc queries) | |||
| How do I append data in several cells in one column | Excel Discussion (Misc queries) | |||
| How to Append the Data to the Master Table | Excel Worksheet Functions | |||
| How to append/combine (not add) data in several sheets into one? | Excel Discussion (Misc queries) | |||
Threaded Mode
