I am new to Excel and I have had no training but I am a fast learner. At my
new job, our scheduling system is through Excel. It is such a mess and so
many scheduling mistakes are looked over. Does anyone have any advice or
hints or anything?? ---- We fill out a master schedule on one page then we
fill out the individual schedules on other separate pages. We make many
overlap mistakes and even some gaps where something isn't covered. I want to
know how to prevent that without buying scheduling software. PLEASE HELP!
--
Leslie @ Maxxguard Security Inc.

Leslie@MaxxGuard Security wrote:
I am new to Excel and I have had no training but I am a fast learner. At my
new job, our scheduling system is through Excel. It is such a mess and so
many scheduling mistakes are looked over. Does anyone have any advice or
hints or anything?? ---- We fill out a master schedule on one page then we
fill out the individual schedules on other separate pages. We make many
overlap mistakes and even some gaps where something isn't covered. I want to
know how to prevent that without buying scheduling software. PLEASE HELP!

Not sure what you're looking for but you might try this link to
an Excel template. It may give you some ideas. Watch for line wrap
on the URL

http://office.microsoft.com/en-us/te...CT101172751033

gls858

Leslie,
I may have a suggestion for you. If you link the master sheet to the
individual sheet you can save yourself the time to copy your work over. In
order to do this you place an = in the cell on the individual sheet and then
scroll back to the master sheet and click in the cell where the information
should come from and then click the green check mark in the upper left of the
worksheet and the cell in the individual worksheet will now automatically
populate from the master reducing your errors and repetive work.

Chrisinct

"Leslie@MaxxGuard Security" wrote:

I am new to Excel and I have had no training but I am a fast learner. At my
new job, our scheduling system is through Excel. It is such a mess and so
many scheduling mistakes are looked over. Does anyone have any advice or
hints or anything?? ---- We fill out a master schedule on one page then we
fill out the individual schedules on other separate pages. We make many
overlap mistakes and even some gaps where something isn't covered. I want to
know how to prevent that without buying scheduling software. PLEASE HELP!
--
Leslie @ Maxxguard Security Inc.