G
Guest
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!
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!