#1
|
|||
|
|||
Setting up Analysis Sheet when data does not exist, yet.
I'm trying to setup a data analysis sheet for 10 employees that compiles their activity for each day throughout the year. Each employee completes his daily sheet and copies it into his respective folder. The analysis sheet looks to each employee's folder and gathers the data off each sheet. The problem I have is that I'm setting up the analysis sheet before the daily data sheets are completed and I end up with nothing but reference errors because I'm telling it to look for data that does not exist yet. How can I set up my analysis sheet to gather the data when that data is completed and copied to the correct folder?
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I get some help setting this up please? | Moiraes Fate | Office | 0 | 05-18-2007 12:22 PM |
sheet linking, sorting | nickbfe | Excel | 0 | 05-19-2006 11:00 AM |
Enter Number on any sheet one time only. | paulrm906 | Excel | 1 | 04-28-2006 07:35 AM |
setting rules | isapaine | Misc | 0 | 01-11-2006 07:51 AM |
Microsoft Access - Form For Sales Analysis | kennyharrill | Office | 0 | 09-15-2005 08:49 AM |