Hi, is there any way to assign a macro button so that when i click it it: print page 1 to page x according to the vlookup datasets?
I have a datapage with all my clients. For each client I have to make an invoice which I compose with the VLookupfunction.
Right now: I have to type client 15, change to the invoice page, press print and go back again to the first page, to start with nr 16.
This takes a lot of time.
I'm looking for a macro that lets me print the invoice of all clients between 15-45 for instance...
I'm a total newbie in the world of macros and have but a little knowledge of excel :-)
Thx for the help
Pablo1976
Bookmarks