Hi All,



I am new to VBA and need help.



I am trying to use the below code but its not helping me to get what I want


Please Login or Register  to view this content.


-----------------



What I want is, when Globally Saleable is entered in worksheet 1 (which has another VBA attached to it), the same is reflected in Worksheet 2(Worksheet1!c10) column C, whenever Globally Saleable is entered in any of the row in Worksheet 1 , it gets copied in worksheet 2(Worksheet1!c10) and I want the 6th to 10th row below it hidden, and the cell is blank or when the value is removed or changed to something else,all the rows should unhide.



for e.g, if Globally Saleable is entered in Worksheet 1 in suppose say c10, the same value is reflected in c10 worksheet 2 and the vba should pick this and hide c16 to c20 and when globbaly saleable is removed or replaced with anything else in Worksheet 1 it gets reflected in sheet 2(Worksheet1!c10) and all the rows should unhide

The code above does not work till I go to Worksheet 2 and manually enter the value and doed not hide c16 to c20, it works if i enter the code as Rows(Target.Row + 6 & ":" & Target.Row + 10), then is successfully hides 10 rows from target+6th row. The code does not work if the 2nd value is below 6


Please Help!!