Excel Sheet to change based on Dropbox

[d444nyc]

Hello All,

I'm looking to create my excel sheet so that it can be changed from day to day.

For example, the Tab will be for week 1 and in that sheet you can enter what's happened in that day for sales, then can use a drop down box to select Tuesday but it will still save what was entered on Monday and allow you enter more for the rest of the week?

I've searched everywhere and have seen this being used but cant work out the code or find the code.

Any help would be greatly appreciated.