I had a value in dropdown in excel and on selecting value the excel generate data into another sheet i want to copy that data.

[PuneetSingh1982]

I had a value in dropdown in excel and on selecting value the excel generate data into another sheet i want to copy that data but here issue is the cell number is changing on every select in dropdown column is remaing but row is changing. how we get data.

 

[PuneetSingh1982]

I had a value in dropdown in excel and on selecting value the excel generate data into another sheet i want to copy that data but here issue is the cell number is changing on every select in dropdown column is remaing but row is changing. how we get data.

or let me know how i copy and paste value in D1 column for below code. I will write that for all the cases and get the value in D1

If Not Application.Intersect(Range("B13"), Range(Target.Address)) Is Nothing Then
Select Case Target.Value
Case Is = "BAY - UNDEGROUND PLACEMENT": Sheet13.Rows("1:4").EntireRow.Hidden = False
Sheet13.Rows("5:34").EntireRow.Hidden = True
Sheet13.Rows("35:37").EntireRow.Hidden = False
Sheet13.Rows("38:88").EntireRow.Hidden = True

 

[PuneetSingh1982]

This is really urgent.