View Single Post
 
Old 12-04-2013, 01:47 PM
tjcusick tjcusick is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Dec 2013
Location: McElhattan, PA
Posts: 2
tjcusick is on a distinguished road
Default 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
Reply With Quote