I get invoice in the notepad form as attached.
I get quite a few invoices like this every week.
I need a VB macro to convert this invoice into excel sheet as attached.
Once converted save the file with name as Date-Store#-Vendor-InvNumber; 2010-05-18-XYZ-ABC#454061
Let me know if you have any further question.
Please help ....
RIZ MOMIN
Bookmarks