Repeat Macro until until blank cell/row

Hi Everyone,

Hoping you can help me with a macro I'm trying to write. I am trying to create a series of templates (over 1000) so would love for a macro to create them for me. I have the form in excel populated from row 2 in another sheet. I have successfully got it to save as a pdf:

Please Login or Register  to view this content.

However when I try to get it to loop until no more data on the other sheet it doesn't work. This is the code I have tried to write:

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Cheers,

Andrew

Hi Andrew,

Could you attach a copy of the workbook (devoid of sensitive data) as it's quite hard to write a solution without having that. Also, won't the file name in cell C14 need be changed each time?

Robert

Hi Robert - added attachment to original post now.

Also the file name in C14 will update from the other sheet "Store List" as the details are moved up to row 2.

Thanks,

Andrew

I have to dash now but I'll try and have look later tonight.

My thought is to loop through all the records in the Store List tab, change the formulas in the Payment Form tab to the appropriate row in the Store List tab, PDF the result and start again.

Would this suffice?

Robert

Hi Andrew,

Try this:

Please Login or Register  to view this content.

Note you have the same formula in cells C12 and C16 of the Payment Form (hopefully the way I've set the macro up you'll easily see where that would have to be changed).

Regards,

Robert

Thanks very much for this - works like a dream!

You're welcome. Thanks for marking the thread as solved and for the rep

Regards,

Robert