I need to create ~700 excel files from a template and would like to save them with a specifc name. Is there a way to auto generate the files from a template and have files auto named from a table?
I need to create ~700 excel files from a template and would like to save them with a specifc name. Is there a way to auto generate the files from a template and have files auto named from a table?
Hi,
Yes it is possible, but we would need a little bit of more information (read yellow banner at the top of your page)
But for creating this, you'll need VBA.
Cheers
John.
"I excel at jumping to conclusions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks