mvesaas
08-23-2005, 11:25 AM
Hi, :hi:
I have a veeerrry large spreadsheet that needs some formatting help. The sheet is a list of 5,000+ records, that list account details. Each account is tracked by a KEY number. Problem is that for any given account KEY, there may be 5-6 lines of information. I need to combine all the data for each listed account into one comprehensive line, then delete the duplicate files.
For example, Acct #102460 has three lines of information. The information in each line is slightly different, but each has the same KEY 102460. I need to take the detail information, combine it onto one line of info, then delete the other lines. Then move to the next acct KEY.
I have a general idea of how the code would verify the info, format, and move forward, but I have only used VBA in WORD, and am not very familiar with Excel VBA.
Any suggestions? :dunno I have attached a small example that shows how the data starts, then how I would like it to look once formatted correctly.
I have a veeerrry large spreadsheet that needs some formatting help. The sheet is a list of 5,000+ records, that list account details. Each account is tracked by a KEY number. Problem is that for any given account KEY, there may be 5-6 lines of information. I need to combine all the data for each listed account into one comprehensive line, then delete the duplicate files.
For example, Acct #102460 has three lines of information. The information in each line is slightly different, but each has the same KEY 102460. I need to take the detail information, combine it onto one line of info, then delete the other lines. Then move to the next acct KEY.
I have a general idea of how the code would verify the info, format, and move forward, but I have only used VBA in WORD, and am not very familiar with Excel VBA.
Any suggestions? :dunno I have attached a small example that shows how the data starts, then how I would like it to look once formatted correctly.