This looks and works great
One question what to you mean by a Centre Across Selection? Never heard of that.
Take Order
When you hit the Add Child Name and then hit cancel it adds a blank row instead of stopping.. Again not a big deal just did not know if it was suppose to stop and is not for some reason
Combined
I don’t mind the totals at the top. I have them just to verify the other info any way.
SS Hours Sheet
I don’t mind the totals at the top.
Take Order
1. Looks good. The time lag is more for me than you, but not a problem as long as I put that in the instructions. Might be a little annoying when adding kids at the start of the year.
a. Question with this. Can we add a lot of names at once like a copy and
paste from a roster? With out using the button and not messing anything
up? Or is it better to enter each kid one at a time.
2. I updated an equation in the Balance, is there a way to get excel to not show the O or – when the equation yields a zero. Just let the cell be blank?
NEXT THING--- if this is again asking too much I understand so you have been awesome with helping so. Deleting a record or deleting all data to start the new year is critical but the rest is just again trying to simplify for the end user. If we can simply just select all the white spaces and delete that is fine too.
1. To delete an individual record if needed
2. To delete all the data to make it ready for a new year. So this data is for 2020 and when we do this in 2021 we would need to start from scratch.
a. TAKE ORDER
i. We would delete everything from with the exception of Rows 2 and 3
ii. We would also keep row 46-48
iii. If we would just delete rows then does the button work to start over or
since it is locked in to add from row 32 you could not delete all the rows?
b. SS Hours
i. We would delete all the data entry since the names come from Take order,
they would already be deleted
c. Inventory Counts
i. We would delete data where date and business name is
ii. Zero out the Start and End inventory
3. Inventory Counts
a. As we add product (row 1 and 2) Add Events with dates and Times is there
a way to get that data to auto populate in the SS hours then?
i. May be too complicated vs just doing a manual insert just trying to
make things uber user friendly. A lot of our parents don’t use excel
or even have a computer.
b. Then with in SS Hours the green box adjusts as well?
4. The final thing then would be the report for take orders. This is for picking the product. So when it is delivered it is delivered in cases 1 case of Carmel 1 case of cheddar and so on. So the report would be used to hand out to people on paper so when they are picking an order its easy to read. The big issue with the one we have is it does not refresh well and you have to manipulate the page breaks to get one order on a page if it ends up being split.
Thanks again. Again if some stuff is complicating it rather than just being simple with the manual version I am fine with that too just let me know.
|