Would anyone know how to create macro to pick up specific figures and references from a long excel spreadsheet and when you print, these specific figures and references would print out loads of invoices with the figures and references on them? Is there a way to do it? Any help would be greatly appreciated.
OK well I presume that your "long excel spreadsheet" (let's call it 'master') has many rows, each containing information to be entered on an invoice.
I'm also assuming that you have a template for the invoice.
What I need to know is what is in each column of the Master sheet and where (cell address) it has to be entered on the invoice.
The macro would
- loop through each row on the master sheet - for each row create a copy of the invoice template - populate the copy of the template with the information - print the copy of the template then delete it (or not, depending on whether you need to save it)
but I can't do anything without knowing what is where and where it is supposed to go.
Thank you for your replies Vog. Unfortunately as this is my friends spreadsheet, I don't have it and he is reluctant to impart the information on his spreadsheet which I know doesn't really help. All I know is that he wants to know if it can be done and to be pointed in the right direction. Thank you very much for your help with this. I'll pass this info on to him and see what he wants to do. Thank you again.
This thread is now locked and can not be replied to.