Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to combine variable rows
I have an excel file that has several people listed several times in
different rows. The only common information that shows these individuals as the same person is their SSN. The same individual is listed several times in different rows due to each row showing the same individual with different products that they have purchased. Is their a macro that will read the SSN column - looking for the same SSN, and if the same SSN exists, combine the information into one row? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to combine variable rows
perhaps a couple representative rows of data with an indication of what
columns they are in and if there are multiple products in a single row, what you want the output to look like. -- regards, Tom Ogilvy "Help?" wrote: I have an excel file that has several people listed several times in different rows. The only common information that shows these individuals as the same person is their SSN. The same individual is listed several times in different rows due to each row showing the same individual with different products that they have purchased. Is their a macro that will read the SSN column - looking for the same SSN, and if the same SSN exists, combine the information into one row? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to combine variable rows
The data looks like:
Amy burden 111-11-1111 LTD John Burden 111-11-1111 STD sam burden 111-11-1111 CHILD kim swafford 111-11-1112 PS 1000 ale swafford 111-11-1112 PS PLUS The reason their are repetive SSNs, but different names are due to family members will sign up for different products but they will be listed under owners SSN, that is at the beginning of each repetitive SSN. I would like the data to look like: Amy burden 111-11-1111 LTD STD CHILD kim swafford 111-11-1112 PS 1000 PS PLUS "Tom Ogilvy" wrote: perhaps a couple representative rows of data with an indication of what columns they are in and if there are multiple products in a single row, what you want the output to look like. -- regards, Tom Ogilvy "Help?" wrote: I have an excel file that has several people listed several times in different rows. The only common information that shows these individuals as the same person is their SSN. The same individual is listed several times in different rows due to each row showing the same individual with different products that they have purchased. Is their a macro that will read the SSN column - looking for the same SSN, and if the same SSN exists, combine the information into one row? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to combine 'like' rows | Excel Discussion (Misc queries) | |||
Macro for copying a value to a variable no. of rows | Excel Discussion (Misc queries) | |||
Combine Excel rows - macro needed. | Excel Programming | |||
How do I sum variable rows in a macro? | Excel Programming | |||
macro with variable rows | Excel Programming |