Target Address

[Legacy 185509]

Hi
here is what I am trying to do, I have attached file
in sheet1 u select whichever you want
if U select A051 it will go sheet2 and in cell A1 will select B233_Tag_Id from drop down menu .

this is one way I am trying to do this

here is another way
by using case

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
     
    Select Case Target.Address
         
    Case "$A$11"
        Sheets("Sheet2").Select
        Range("A2").Select
        ActiveCell.FormulaR1C1 = Range("S12")
        
    Case "$A$12"
               Sheets("Sheet2").Select
        Range("A2").Select
        ActiveCell.FormulaR1C1 = Range("S13")
    
     Case "$B$21"
               Sheets("Sheet3").Select
        Range("A2").Select
        ActiveCell.FormulaR1C1 = Range("S2")
    End Select
End Sub

I will do for rest of them myself that was just example of what i am trying to do
please help

I wasn't able to upload any file to this thread
here is link to download it
http://www.mediafire.com/?dzbab5f9zsptywj
thanks