In Page 1 I want to setup a drop down menu selection in A1 from a list that is in Page 2 (C10) Additionally, whatever is selected in A1 drop-down I need it to display in B1 whatever corresponding cell contents are in Page 2 (C11). Example - here is data on page 2:
C10 C11
Gretzky 99
Lemieux 66
Bertuzzi. 44
Neely 8
Roy. 33
For Page 1 the drop-downs for A1, A2, etc. will be the player names & whatever name is selected will automatically populate their corresponding numbers in B1, B2, etc.
C10 C11
Gretzky 99
Lemieux 66
Bertuzzi. 44
Neely 8
Roy. 33
For Page 1 the drop-downs for A1, A2, etc. will be the player names & whatever name is selected will automatically populate their corresponding numbers in B1, B2, etc.
