In a Worbook if you have an item in cell A1 and have all the items in the "A" column available as a drop-down box on another sheet can you create a rule to say anytime the contents from cell A1 on sheet one is selected in another sheet then the contents from cell B2 on sheet 1 will automaticlly be placed in the cell to the right of it?
Example Example
Sheet 1 Sheet 2
Cell A1=Cat B2=Dog Cell A1 from Drop down is Monkey B2 would = lion
Cell A2=Mouse B2= Bird
Cell A3 = Monkey B2= Lion
All contents from Sheet 1 in column A would be available as a drop-down box in the other sheets. If anywhere in other sheets A1 is chosen then whatever is in the immediate cell to the right of it in sheet 1 would follow it in the new sheet?
Sorry if I am not making sense. Any help is greatly appreciated!
Bookmarks