I would like to have cells next to a drop down list cell associate and be placed on another worksheet.
Example:
Worksheet 1, B3-B256 is a drop down list.
Worksheet 2, B3-B28 are cells to select items from Worksheet 1, B3-256
Worksheet 1, C3-C256 & D3-D256 is associated data that is unique data to the same B cell (B3,C3,D3)
I would like when a drop down list item is selected on Worksheet 2, B3=Worksheet 1 B100. B100 to Worksheet 2 B3, Worksheet 1 C100 to Worksheet 2 C3 & Worksheet 1 D100 to Worksheet 2 F3.
I am sure this is very simple, I am just lost right now.
Thanks for any help
-jonaton9
Bookmarks