nzrocketman
New Member
- Joined
- Mar 15, 2014
- Messages
- 11
Hi,
Having trouble with 2 areas.
Issue 1 - Dropdown List
I am trying to Create a dropdown list at "Sheet1" D1 from the data shown in photo 1 Sheet "Calculations" Cells B1:XY1 and only have it show the one that have an 1 underneath in B2:XY2
Issue 2 - Auto Populate
So then i am trying to make a Cell, = the data in the Calculation sheet based upon the Select column in the dropdown list.
So if you are compare the 2 photos
for example, Cell M13 wants to look up the number in Column C (0210) and grab the data from the correct VO column in the calculation sheet and match the Column C Number with the list in the A Column and insert the value into the M13
Hope this makes sense
Cheers
Brendon
Having trouble with 2 areas.
Issue 1 - Dropdown List
I am trying to Create a dropdown list at "Sheet1" D1 from the data shown in photo 1 Sheet "Calculations" Cells B1:XY1 and only have it show the one that have an 1 underneath in B2:XY2
Issue 2 - Auto Populate
So then i am trying to make a Cell, = the data in the Calculation sheet based upon the Select column in the dropdown list.
So if you are compare the 2 photos
for example, Cell M13 wants to look up the number in Column C (0210) and grab the data from the correct VO column in the calculation sheet and match the Column C Number with the list in the A Column and insert the value into the M13
Hope this makes sense
Cheers
Brendon