Microsoft Office Forums Setting up Analysis Sheet when data does not exist, yet.

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-13-2008, 05:57 AM
burnoutdetective burnoutdetective is offline
Novice
Setting up Analysis Sheet when data does not exist, yet.
 
Join Date: Oct 2008
Posts: 1
burnoutdetective is on a distinguished road
Default 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?
Reply With Quote
Reply

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
Setting up Analysis Sheet when data does not exist, yet. 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


All times are GMT -7. The time now is 05:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft