Okay, I have a challenging one for the genius' on this forum. I hope you guys can help me.
So I'm tracking the waste of a restaurant on a day to day basis, and I've created a UserForm to make inputting the figures easier, since this is not the only thing tracked on this spreadsheet. The Waste sheet is separated into Days of the Week, Sunday, Monday... etc. I was wondering if it would be possible have the sheet detect the day of week based on the value of a separate cell, and input the values into the day specified. For example, something like (assuming A1 = the day of the week, B1 through B7 are the waste fields and "x" is the value being inserted.)
If A1 = Monday, then B1 = x
If A1 = Tuesday, then B2 = x
So on and so forth...
And have the coding executed during a button press event.
Bookmarks