Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help 'cleaning up' a spreadsheet
I have a spreadsheet that is formatted incorrectly and would like to
know if the following can be done (and if someone can help with the code)... - For a highlighted group of cells (single column) - Take all data in the cell below the current cell except the last line and add it to the current cell - For each cell all the way down The spreadsheet I have (long - too long to manually edit) looks like this Test1 A Test2 B C A Test3 B C A So what I want is to highlight the ABC column of cells and have BC from Test2 added to the end of Test1, and BC from Test3 added to Test2... and so on. The only thing static is that I want to keep the last line only... there are cells with 3 lines, some with 4 (BCDA), etc. This spreadsheet is the result of a very large PDF that was converted wrong... and is the only copy we have to work with. I hope this is clear enough... Thank you so much for any help! Cory |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cleaning Up | Excel Programming | |||
Cleaning Up | Excel Programming | |||
"Cleaning Up" Spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet cleaning | Excel Discussion (Misc queries) | |||
Cleaning up some VB | Excel Programming |