Move data from one database to many sheets

I will explaine what i used to have to do.]

The weekly sheets tell us whos eating what, and tallys the amount on the bottom. This is to tell me what to make each day. I would normally have to sit down with 30 or so menus that have the residents choices on it, and 7 sheets of paper mon-sun. then i would have to go ok mike wants 1 for lunch and 2 for dinner on mon, mike wants 2 for lunch and no dinner on tues. and so on. this takes about 2 hours. I created the weekly sheet so i could make it faster by just having to look at a summary page vs the 30 plus menus. But the end result needs to be 7 sheets mon-sun with there choices.

If we worked in reverse the weekly tally sheet would have no use.

I would like it to work automatically, dont know if i need to have a trigger switch for the macro.
I would like to just go on the weekly tally and change all the numbers and have it automatically change the 7 other days to match the weeks choices.

Thank you for your responce!

The easiest way, I see, is to create a hidden table/database where choices are stored. Then the weekly/daily sheets simply call the data via macro or formula. I will do up a mock workbook and post it here. Give me some time (a day or two), however. I am short staffed this week due to vacations and so cannot devote much time to this project.

Feel free to prod me with private messages if a few days have gone by and I haven't responded here.

This works great, now if only i can remember the formula to add the all together.

Originally Posted by darknessheir

This works great, now if only i can remember the formula to add the all together.

What do you mean, exactly? If you mean to add a total into the boxes at the bottom of each selection, then this should do the trick.

=COUNTA(B6:B22) - COUNTIF(B6:B22,"")

yeah like that, but the form i had before was simpiler, count something, it didnt count the empty cells, so if was half the length of the one you just gave me.

In this case you need to count the empty cells, because count or counta will also count anything with a formula, even if that formula evaluates to "". So, what the formula I provided does is count the cells that evaluate to "" and subtract them from the total number of cells.

Is there anyway I can enter mondays date, like the start date for the week over the monday colum on the weekly sheet and have it automatically generate the other 6 days into there positions?

Yes. Attached is an example of that.

Glad you did that, I figured out how to do it, and then saw your post and realized I forgot to link all the sheets to the weekly tab. This is the final copy I think. With instructions on how to work it for my employees.

Thanks alot, this will save us tons of time.