PDA

View Full Version : A continuation... Question of method...



Papadopoulos
12-15-2010, 02:04 PM
So I have, actually xld has, got me through part one of my current project (http://www.vbaexpress.com/forum/showthread.php?t=35372).
Now I need to rearrange the nicely limited set of current data to a new order.
My question is one of procedure.
Do I work row by row and go cell by cell from source sheet to destination?
(more details in a second)
Or do I just copy the columns from their old location to their new one?

If I were just shuffling columns this would be a no-brainer. The trick is the destination sheet will require that I concatenate data from 2 columns into 1, fill in columns with missing data and, based on a match to a reference column, fill in two columns in the destination sheet.
(That match has to be done line by line)

I have attached the file that I am working with because, as I write this, I realize that no one is going to make sense of it without seeing something.
"Raw Import" is where I start.
The code that xld gave me lands my current subset on "Sheet1"
"Final is where this mess is going to end up.
"Final (2)" is what it should look like (but without the header and this is also missing the Adjusted Height and Adjusted Width data)

Bob Phillips
12-15-2010, 04:57 PM
I would just do a block copy, then add some helper columns and inject formulae that do the concatentaion and another that does thematch and split, then copy and paste values those columns and delete the originals.