Creating Invoices using data from a spreadsheet
My wife's job has her filling out pages of information.
I have taken those pages and converted them into an Excel Spreadsheet relatively easily.
The first page is a summary, the 2nd, 3rd & 4th pages are the data, that contains, Contract No, Client Name, Date Received, County, Date Delivered, Director's Name & Address, Number of Copies, and Cost.
And the Last page contains a rolling total's page.
Now to make it even easier I would like to be able to take the information, on 3 of the 5 pages, and create an invoice based on the information on those pages.
I'm sure a Macro would be involved in doing this but I'm not very good at Excel Macros and would appreciate some assistance from the Guru's out there.
Thank you in advance.
Tom Cusick
|