HI Can anyone recommended a tutorial which shows me how to: From a tab which will contain Country name and variable client data apply info across multiple sheets in preset areas lists will be dynamic Save as CountryName_Move_Doc_Date Or something along the lines of having a template but adding in variable data from a dynamic range and saving with new name. As the file will be saved by different people it will have to ask where they want to save. Many thanks Melissa

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA to Create new workbook with templated tables but reading from dynamic range

Thread starter Melimob
Start date Apr 9, 2019
Tags

data dynamic range save variable

Melimob

Active Member

Apr 9, 2019

HI

Can anyone recommended a tutorial which shows me how to:

From a tab which will contain Country name and variable client data
apply info across multiple sheets in preset areas
lists will be dynamic
Save as CountryName_Move_Doc_Date

Or something along the lines of having a template but adding in variable data from a dynamic range and saving with new name. As the file will be saved by different people it will have to ask where they want to save.

Many thanks
Melissa