Template Folder with Excel Macros in Sub-Folders??


Joined
Oct 17, 2011
Messages
1
Reaction score
0
I am not sure if I am explaining this correctly but here we go:

I want to create a master template file folder on a server that will be used by numerous people.
The template folder would be copied and renamed to a specific project.
Once you open this main folder there are 5-7 sub-folders, each containing their own excel documents that information being populated by a master INFO sheet in another sub folder.

How can I link these all together? When I copy the folders and fill in the blanks on the INFO sheet then it doesn't populate anything because it is still looking for the main template folder's information.
I thought I outsmarted this and pulled all the excel sheets into the main folder, filled in the INFO sheet and then put them into the appropriate sub-folder. Once I put them in there it broke the link again!!! Grr. I am not a very knowledgeable computer person but am wondering if this is even possible.

THANKS FOR ANY AND ALL HELP / SUGGESTIONS
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top