Hi all,
I hope you can help me (otherwise my gf will loose her work...).
I have to make an excel that It will contain a calendar (daily per month).
If the calendar can be done with a drop down menu (choose month), or even better button (vba) to make month choice it will be great.
Now, the calendar will be used to a bar. With this excel employees will insert the closing of the day, amount (only money).
So what I need to do is that , lets say that the calendar is in sheet1, June 30 days. All cell dates will have yellow color. When I press i.e. Day 25 a sheet will unhide with that date as a name (25062021) In there the bar crew will need to insert all the necessary info for the day. When all data have be inserted, the cell of the calendar day will turn to Red (meaning that day is closed and ready).
Also, if it is possible when press that day (25) and the cell is red to unhide 25062021 sheet in order boss to see that day.
I know how to hide / unhide sheets based on cell value (vba) but I am stuck on all others.
Can someone please tell me what to do, give me some directions as I am not good on VBA.
Thank you in advance,
Sheet Contents
I hope you can help me (otherwise my gf will loose her work...).
I have to make an excel that It will contain a calendar (daily per month).
If the calendar can be done with a drop down menu (choose month), or even better button (vba) to make month choice it will be great.
Now, the calendar will be used to a bar. With this excel employees will insert the closing of the day, amount (only money).
So what I need to do is that , lets say that the calendar is in sheet1, June 30 days. All cell dates will have yellow color. When I press i.e. Day 25 a sheet will unhide with that date as a name (25062021) In there the bar crew will need to insert all the necessary info for the day. When all data have be inserted, the cell of the calendar day will turn to Red (meaning that day is closed and ready).
Also, if it is possible when press that day (25) and the cell is red to unhide 25062021 sheet in order boss to see that day.
I know how to hide / unhide sheets based on cell value (vba) but I am stuck on all others.
Can someone please tell me what to do, give me some directions as I am not good on VBA.
Thank you in advance,
Sheet Contents
calendar1.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ZONE Α (10:00- 18:00) | |||||||
Φύλλο1 |