Reference spreadsheet needs to be open
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
I have created a database query spreadsheet that pulls Customer ID's and corresponding Job ID's. There are a lot of calculations in this. I am using it as a reference for a separate Time Entry spreadsheet. If I use the Time Entry spreadsheet, I need to have the reference open. That might be too much for the user. I have 3 questions. 1. Is there a way to write a script that will open the reference and keep it invisible? 2. Should I just copy the cells from the reference into the timesheet and hide the tabs? 3. Will the CPU Usage be saved by choosing eother or will it stay the same? My Brain hurts. Thanks, Nicole Sohenick