Unlike other commercially available software which require you to manually select the data to be converted and can only process one file at a time, this little excel template allows you to convert an entire folder of pdf files exporting only the data you need. What's more its free!

[url]http://www.melbtest.com.au/woa/pdf-excel_download.htm[/url]

a b c D E F
1 date amt of inv less disc 2% bal due total due jan :eek:
2 jan 1, 207 100.00 n 100.00
3 jan 10, 2007 100.00 y 98.00
4 jan 31, 2007 200.00 y 96.00
5 feb 2, 2007 100.00 y 98.00
6 feb 15, 2007 200.00 n 200.00

I need a formula to put in column E line 2 -- that calulates the total due for january only, by using the date listed in column A lines 2 thru 50 and also deduct a discount if paid on time by inserting y for yes and n for n in the less 2% column C line 2 thru 50 , listing the total with or without the discount in column D line 2 thru 50 and then calculating the total due for the invoices at columm: E for the totals of column D line 2 thru 50 , only for january

[QUOTE=edymay2]a b c D E F
1 date amt of inv less disc 2% bal due total due jan :eek:
2 jan 1, 207 100.00 n 100.00
3 jan 10, 2007 100.00 y 98.00
4 jan 31, 2007 200.00 y 96.00
5 feb 2, 2007 100.00 y 98.00
6 feb 15, 2007 200.00 n 200.00

I need a formula to put in column E line 2 -- that calulates the total due for january only, by using the date listed in column A lines 2 thru 50 and also deduct a discount if paid on time by inserting y for yes and n for n in the less 2% column C line 2 thru 50 , listing the total with or without the discount in column D line 2 thru 50 and then calculating the total due for the invoices at columm: E for the totals of column D line 2 thru 50 , only for january

If you don't want to bother with software there is a service available at [URL="http://www.reportminers.com/"]http://www.reportminers.com/[/URL] to convert pdf to excel.