I have two spreadsheets. One has customer information, Name, address, account number, sales rep, etc.
The second spreadsheet has catalog product information – Item#, description, cost, discount, etc.
I need to have a program/macro make unique spreadsheets for each customer with the customers information on the cover sheet, and the product ordering information following.
I realize that this can be done with a database, but Im just a salesman looking for a quick and clean solution.
The resulting file needs to be emailed to the customers once a month. when anything changes in the customer file, the resulting Customer file needs to be updated.
I am looking for ideas and solutions. I realize that this is not defined in detail yet, just concept. Please submit ideas and budgets.
Thanks,![Can you complete the project? [Microsoft Excel Programming]](http://www.freelance-help.com/doTheJob.jpg)
