What I am working on is a template file for doing material takeoffs. I am trying to set it up so that it can reference another document and pull in data from that document. Basically all the values it is pulling in are set up as indirect links within an IF statement.
What I am hoping to do, and I am not sure if there is a better way, is have that IF statement reference a Boolean cell tied to a simple toggle button. So when I toggle it one the indirect links kick in. Obviously for that to work I need to know the file name though. Is there a way that it can be set up, preferably without VBA, so that when I toggle on that button a window will pop up so I can tell it what file to look in for those indirect links? The reason being I know the file it is looking at will always be set up the same, but the name will be different for each project we're doing.
If anyone has a better approach to this I am all ears as well. Thanks for any help!
What I am hoping to do, and I am not sure if there is a better way, is have that IF statement reference a Boolean cell tied to a simple toggle button. So when I toggle it one the indirect links kick in. Obviously for that to work I need to know the file name though. Is there a way that it can be set up, preferably without VBA, so that when I toggle on that button a window will pop up so I can tell it what file to look in for those indirect links? The reason being I know the file it is looking at will always be set up the same, but the name will be different for each project we're doing.
If anyone has a better approach to this I am all ears as well. Thanks for any help!
Last edited:
