Matching two criteria, return third

[Horskrzy]

Short and sweet.

Our PO program prints out auto-generated POs (for filing and referral purposes only) that are a convoluted mess. There's repeated information and/or information that's not needed which results in a very hard to decipher printout. We have an option that will export it to a csv file so I'd like to set up a preformatted spreadsheet that will pull the data of the daily csv file (which will always have the same location and file name, it'll just be overwritten each day). If I can get this to work we'll have a clean, easy to read daily printout.

A simplified sample of data (without all of the "garbage info" columns):

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]PO[/TD]
[TD="align: center"]LINE[/TD]
[TD="align: center"]ITEM[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]83200[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]11111[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]83200[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]22222[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]83201[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]33333[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]83202[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]44444[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]84005[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]55555[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]84005[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]66666[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]84005[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]77777[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]84008[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]88888[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD="align: center"]84009[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]99999[/TD]
[/TR]
</tbody>[/TABLE]

What I need in a separate sheet:

• Multiple "pages" that will identify the next PO number in the list (and place the PO number at the top right corner of the page) and based on that PO number, list all the PO line and item numbers related to the PO in rows below the PO number (up to 27 lines)
• If the PO has more than 27 lines, the next "page" will recognize the additional lines and continue to list the remaining PO lines and item numbers.
• If the PO has less than 27 lines, the remaining rows/formulas will be blank.
• If the PO has less than 27 lines, the next "page" will show the next PO number.

Any suggestions?

Thanks,

Mark