Merge sheets to Workbook
 

I have a Shared workbook, with 5 tabs, each with a city name. I allow 2
people in each city, to make changes. Specifically, the changes are how many
persons can be scheduled in that day, =2 on Monday, 3 on Wed, etc. There is a
drop down menu to choose the number, and a colored group of cells below the
drop down. When they choose a number it uncolors the number of cells, (used
conditional formatting). My problem is, that it is as slow as mud when you
save it, or try to update to see what the new info is. Can i either creat a
seperate sheet for each city, that they can work on, that i can have a
central worksheet, each will be able to save to, making it faster, or is
there another way to speed this up. I take calls to fill the slots they give,
and wait 5 minutes to see where i can put someone.
Sorry, i'm not a coder, i'm still learning this.
Any Ideas?
--
NealMed