Login or sign up Lost password?
Login or sign up
There are 7 sectors of the club and they each have a sheet in this workbook. Hi jwchestnut2, Ok, for that request I need the following info: 1) Which column is used for the labels "Mechanical", "E&I" and "HSE"? Best regards, Trowa Trowa, Michael - This post really helped me at some extend. :) I'm still getting some bug to implement the same on my requirements. Even though the Type is correct, it is not being populated in respective child sheet. Below is the query I used - Private Sub Worksheet_Change(By Val Target As Range) If Intersect(Target, Columns("A: A")) Is Nothing Then Exit Sub If Target.