Macro to extract certain data from a source and reformat it

Hi,

Got a bit of a tricky one.

I've got a list of data that I need to change into a table in a different format.

If you look at the attached spreadsheet - I need to look at the order numbers of each row and create one "POH" line per order number and multiple "POL" lines per order number (based on how many rows there are per "POL".

So if we look at the first 2 rows of order number 115074 this would translate to one "POH" line on the output file and two "POL" line. 117373 would translate to one "POH" line and three "POL" lines. Each line extracting data from the columns noted and placing it within the table.

Hope this makes sense as it's pretty awkward to explain.

Any help would be reeaaaly appreciated as I've struggled with this for a while.

Hi,

the second option so 115074's POH line followed by 115074's POL lines followed by 11737's POH line followed by 11737's POL line (which I think makes it more difficult :S)

I only wish to transfer that data that I've mentioned and in those specific columns.

Thanks for taking the time to look at this

It isn't my most elegant work, but the procedure below seems to work for me. Take a look:

Please Login or Register  to view this content.

Sorry, I just noticed I had the order date targeted incorrectly. Fixed:

Please Login or Register  to view this content.

I honestly can't thank you enough, this is a massive help.

Thanks man