I'm hoping someone can direct me to a link or assist me in answering what I'm trying to get .
I'm currently creating a template/checklist with Data Validation, but would like the data stored based on the selection I make.
In my attached dummy sheet, I want data of column B, C, D and E all reflective of the selection in A7. Ideally when I select the dropdown in A7 I want all the data in the sheet to change based on that selection.
Any help will be appreciated
I'm currently creating a template/checklist with Data Validation, but would like the data stored based on the selection I make.
In my attached dummy sheet, I want data of column B, C, D and E all reflective of the selection in A7. Ideally when I select the dropdown in A7 I want all the data in the sheet to change based on that selection.
Any help will be appreciated
Checklist.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
2 | Preperation Sheet & Checklist | |||||||
3 | ||||||||
4 | ||||||||
5 | Informatiuon | |||||||
6 | Supplier Name | Negotiaition Start Date | Date Contract Expires | Targeted Completion Date | Recommended Process Start Date | |||
7 | F | 3/10/2021 | 3/9/2021 | 3/24/2021 | ||||
Checklist |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B7 | B7 | =TODAY() |
C7 | C7 | =TODAY()-1 |
D7 | D7 | =B7+14 |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
A7 | List | =DataValidation!$A$2:$A$3 |