Invoice Data Extraction Query/VBA/???

[billsfree]

I have an invoice which I need to extract data from on weekly basis. (file is attached)

We need to extract the 4 lines in each column beginning with the first line that has a sequential number order in the PIN column (numbers in red from 1 to 17). this sequential number could be as high as 600...and the number of pages would also increase...but not the number of worksheets.

Any advice as to the easiest way to do this??? Not really sure where to start...

Thanks very much for any help or advice as to the best way to proceed...

Bill

[Leith Ross]

Hello billsfree,

Welcome to the Forum!

The macro below will need some changes made since you didn't provide any information about exporting the invoice. Let me know how you want to export the invoices and I can make the needed changes.

This macro assumes the Customer Name is in red font as it is in the sample workbook. If this not the case, let know.

Please Login or Register  to view this content.

[ThirtyTwo]

Hi billsfree

I'm presuming that data in Shee1 will always be presented in the same format

To enable us to fully assist you, could you design a template in Sheet2 of how you want data to be presented ? (don't worry about keeping it simple, give an example of how complex a report could appear)

Once you've created the template, the experts will then be able to do the technical stuff of how to achieve your requirements

Or.............

If you just want to display rows that have a PIN you could put a formula in column E

Please Login or Register  to view this content.

copy and paste that down for as many rows as you have data

then apply a filter where column E = 1

If you want to also display in info below each customer name then use this formula in column E

Please Login or Register  to view this content.

then apply a filter to column E to show non blanks

[ThirtyTwo]

i've uploaded a file with a filter applied

[billsfree]

cannot seem to get the revised workbook to attach...paperclip icon is there but does nothing when clicked? nor does manage attachments when clicked...