Hi,
I was working on a spreadsheet for work. I wanted to make a dropdown list where I am able to type text in the dropdown box. I then need to update the dropdown every week. I also need the previous entries to appear when I click on the arrow.
For example: Week 1: Drop dow list has 1 entered
Week 2: I enter 2 in the dropdown list
When someone clicks on the arrow to view the drop down list. I want it to have the current entry (2) and the previous entry (1). Basically like a history log so every knows what was in the box before. If that makes sense.
Thank you in advance.
I was working on a spreadsheet for work. I wanted to make a dropdown list where I am able to type text in the dropdown box. I then need to update the dropdown every week. I also need the previous entries to appear when I click on the arrow.
For example: Week 1: Drop dow list has 1 entered
Week 2: I enter 2 in the dropdown list
When someone clicks on the arrow to view the drop down list. I want it to have the current entry (2) and the previous entry (1). Basically like a history log so every knows what was in the box before. If that makes sense.
Thank you in advance.
