Dear Friends,
I have attached sample worksheet which contains two sheets 1. Data sheet which will be updated with data of supplies 2. Customer Invoice format
I want a macro which can do the following task for me.
1. Once I update the data sheet and run MACRO it should generate the invoices for all my customers with sheet name as customer name and values updated for the headers colored in red (In customer sheets ) according to the customer data from the data sheet.
It will make my job easy.....
Thanks in advance
Bookmarks