varunwalla
New Member
- Joined
- Aug 13, 2020
- Messages
- 32
- Office Version
- 365
- 2019
- Platform
- Windows
- Mobile
- Web
In Sheet1 Cell A1 should show a drop down list from sheet2 i.e
- Bob Sales Value,
- Josh Sales Value,
- Ricky Sales Value
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Dropdown List | Output | ||
Sheet1 |
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | No | Bob Sales Value | Josh Sales Value | Ricky Sales Value | ||
2 | 1 | 100 | 133 | 224 | ||
3 | 2 | 125 | 22 | 22 | ||
4 | 3 | 65 | 33 | 24 | ||
5 | 4 | 22 | 2 | 21 | ||
6 | 5 | 44 | 11 | 242 | ||
Sheet2 |