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

[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!

 

[muddan madhu]

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.

 

[Damil4real]

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 -

Oh my freakin' god! You're good!

Thanks!

 

[muddan madhu]

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 )