Hello experts and members!
I'd appreciate some assistance with an issue I'm having with Excel.
I have an issue with a client invoice system I’m trying to create on Excel 2003.
I have created an invoice template, but the data such as Client Name, Address, Monthly Billing are all variables stored in a different worksheet in a list.
Each row of this customer list contains information for each of many clients.
The issue comes in when I want to figure out how I can expedite printing invoices for several clients at the push of one button.
There is one worksheet that serves as a template, but upon print command, I would like this template to look through the client list and search for rows that are checked with a checkmark and print only those selected clients.
If I select 10 clients out of 100, it would be great to print 10 invoices at the push of a single button using data stored in the client list worksheet.
I’m assuming that this is a fairly difficult task. Is it even possible?
I’d appreciate any help I can get, including which related sources I can see and study from it even.
Thank you very much.
Please see the attached file.
Bookmarks