I have a restaurant chain sales table, spread on multiple sheets. Each sheet represents weekday. rows applied for to shift (Morning, noon, evening - each one 10 lines - assuming that no more than 10 meals are sold in each shift). Meals are typed in manually by waiters. Columns for Branches/shops.
Each one of the regions under my responsibility has different number of shops. I want each of my regional managers, which are not the sharpest ones, to have the option to:
1. choose their region name from dropdown - that will be good mostly for file title, but it will also come with a "default" list of correspond branches.
2. I want to leave them the option and flexibility to add/reduce branches.
3. Once that done, The table width will be as wide as the number of branches- to remind you each branch is the header of column, apart from the end column(s), which are default (summation function I'll put later).
4. After they created the relevant table, I want to give them the further option: by choosing shift, and then clicking 1 button (macro), they will be able to print which meals of each kind were sold in each shift, i.e., if one manager has 8 shops, so by clicking he would get 8 pages with the details for relevant shift. For instance, Michael, Scranton's regional manager, will get 8 pages, each one contains the information about the number of meals that each one of 8 Scranton restaurants sold this evening (or morning, or noon...)
lets say for comfort that shop names are in ROW(1) COL(2:*), the word "morning" in (2,1), the word "noon" in (12,1), the word "evening" in (22,1), and table content (meals) b2:*31. col [*+1) is my function]
I hope I was clear enough.
If someone think I wasn't clear and wish to help - Am more than willing to share the sheets on different channels.
Thanks for everybody who's willing to help!