Macro to move data to another format

[jsmilke]

I'm looking for a macro to select data from a larger data set, and then put it in another worksheet. Basically, I want to select any cell in column A that contains "SO5" and move those to the column A of a separate worksheet. Then, for each cell that contains "SO5" would like to move to the right 5 columns and down 3 rows and select from that cell all the way to the end of the table. There may or may not be data in all of the table cells, so the selection should be based off of the column headers which will always have values. I would like to take that data and put it with the corresponding "SO5" in the new sheet.
Here's a sample:

MacroSample.xlsm

This is a simplified version, but I'm trying to get the data from sheet1 into the format in sheet2. Keep in mind that the number of columns and rows may change so it needs to be as dynamic as possible.

Any help would be greatly appreciated!

[Richard Buttrey]

Hi,

Make sure sheet2 is empty then run the following macro

Please Login or Register  to view this content.

Incidentally, would you mind changing your location to something more sensible than 'Somewhere'. It often helps when we are faced with implying what your date or other regional settings might be.