I have two drop list of the same data but in different sheets.

  • Thread starter Thread starter Damil4real
  • Start date Start date
D

Damil4real

I have two drop list of the same data but in different sheets.

Is there a way to choose a data in one list and the other list should
also automatically choose the same data?

Drop List one - A, B, C
Drop List two - A, B, C

Pick A in List one should make List two automatically show List one
without me having to pick it. I know there are several other ways I
can accomplish this specific tasks, but is there a way to do it the
way I just explained above?

Thanks!
 
try this

Go to data | validation | allow : list | source : A,B,C | ok

Now Copy the cell which has validation. Go to different sheet

Holding Shift key Go to Edit | paste picture link |

If you select the drop down , value changes.
 
try this

Go to data | validation | allow : list | source : A,B,C | ok

Now Copy the cell which has validation. Go to different sheet

Holding Shift key Go to Edit | paste picture link |

If you select the drop down , value changes.







- Show quoted text -
Click to expand...

Oh my freakin' god! You're good!

Thanks!
 
Or if you don't want picture then just reference that cell

=sheet1!A1 or copy | edit | paste special | paste link | ok ( both
are same )
 
Back
Top