Hi - I'm very new to this so bear with me!
I am currently working on a Macro for an invoice template that picks all the details from my table of data based on the invoice number and then exports the template to a PDF. I need to loop through a column of invoice numbers so I can repeat the process for each different invoice number but I am having trouble setting up the loop in VBA.
The table I am working with is called "Schedule_Invoice" & the column within this that I need to loop through is called "Invoice #". I just need to paste each invoice number into cell U6 in my "Invoice Template" worksheet so I can proceed with exporting into PDF and then move on to the next invoice number in the column and repeat.
I feel as though this should be quite straightforward for those who know what they are doing but unfortunately I don't have the VBA experience.
If anyone could give me some pointers that would be great.
Thank you.
Bookmarks