Help with Excel VBA to copy data to a template and save it as a different filename.

**avalite** · 01-11-2022, 06:04 PM

Hello everyone,

So I have tried solving this problem, but I just cant come up with a solution. I have 2 files (see attached). Master File and a template. I need a macro that copies data from the Masterfile columns per row to the template and then save it with a new file name lets say "Template-110122". SO if the masterfile has 10 rows, that means that there will be 10 new files generated. Will really appreciate your help with this one.

Thanks in advance.

**Norie** · 01-11-2022, 06:35 PM

This should get you started.

Note I've used the date/time including milliseconds to create unique filenames, you probably want to look at using some other method/pattern for that.

Please Login or Register  to view this content.

Help with Excel VBA to copy data to a template and save it as a different filename.

LinkBack

Thread Tools

Rate This Thread

Display

Help with Excel VBA to copy data to a template and save it as a different filename.

Re: Help with Excel VBA to copy data to a template and save it as a different filename.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copy 4 sheets from template and dynamically name, Save template and leave workin file open

[SOLVED] Excel macro-Enabled template set default save as filename

[SOLVED] looper to copy tabs of a data file into template and save as

Need a loop script to copy from one 'data' workbook' to a template, make some edits, save.

Copy new row data to specific cells in formatted excel template and save based on cell val

Copy and paste data from a worksheet to template, save it with a name and location.

[SOLVED] Date + Filename using save copy as

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions