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]

View / Bid