willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 888
- Office Version
- 365
- Platform
- Windows
I need help with getting a combo box that gets it list from a particular formula to relay the selection to a linked cell with the proper value.
I will do my best to explain.
There are 3 Sheets: List, Graph Data and Dashboard
The combo boxes are on the Dashboard sheet. When the user selects the year the lists change accordingly on the List sheet. The Graph Data sheet is where the linked cells to the combo box's are however the linked cells are not displaying the proper year and I do not know why/how to fix this.
Combo Boxes:
List:
Graph Data:
I hope someone can help. My whole spreadsheet relies on these communicating properly.
I will do my best to explain.
There are 3 Sheets: List, Graph Data and Dashboard
The combo boxes are on the Dashboard sheet. When the user selects the year the lists change accordingly on the List sheet. The Graph Data sheet is where the linked cells to the combo box's are however the linked cells are not displaying the proper year and I do not know why/how to fix this.
Combo Boxes:
List:
Customer Part Analysis Dashboard.xlsm | ||||||
---|---|---|---|---|---|---|
C | D | E | F | |||
1 | Year List | Month List Start | Month List End | |||
2 | 2021 | January 1, 2021 | January 31, 2021 | 0 | ||
3 | 2020 | February 1, 2021 | February 28, 2021 | 1 | ||
4 | 2019 | March 1, 2021 | March 31, 2021 | 2 | ||
5 | 2018 | April 1, 2021 | April 30, 2021 | 3 | ||
6 | 2017 | May 1, 2021 | May 31, 2021 | 4 | ||
7 | June 1, 2021 | June 30, 2021 | 5 | |||
8 | July 1, 2021 | July 31, 2021 | 6 | |||
9 | August 1, 2021 | August 31, 2021 | 7 | |||
10 | September 1, 2021 | September 30, 2021 | 8 | |||
11 | October 1, 2021 | October 31, 2021 | 9 | |||
12 | November 1, 2021 | November 30, 2021 | 10 | |||
13 | December 1, 2021 | December 31, 2021 | 11 | |||
List |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2 | D2 | =DATE(('Graph Data'!$B$2),1,1) |
E2:E13 | E2 | =EOMONTH(D2,0) |
D3:D13 | D3 | =EDATE($D$2,F3) |
C2 | C2 | =YEAR(TODAY()) |
C3:C6 | C3 | =C2-1 |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
Month_List_Start | =List!$D$2:$D$13 | E2, D3:D13 |
Year_List | =List!$C$2:$C$6 | C3 |
Graph Data:
Customer Part Analysis Dashboard.xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
2 | Year Selected | 1900 | |||
3 | Input Date Range | January 1, 1900 | January 3, 1900 | ||
Graph Data |
I hope someone can help. My whole spreadsheet relies on these communicating properly.