First I want to say thank you for everyone on here. I am not new to excel, but I am new to what it can actually do. From reading the posts on here I have learned a lot about how powerful excel really is.
I have been creating a spreadsheet that enables engineering to sort thru a large amount of data by using a configuration sheet and database. Based on the pull down menus I am able to create unique part numbers. Within the document I have numerous worsheets with a unique database. I have figured out how to filter the databases to get the part number I have entered. However, based on my selection on the 1st worksheet, I then have to go back to the worsheet with the data on it and hit "enter" to update the filter I have in place. I used the following code to update, but I still need to hit enter.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A7:F19").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range _
("A4:F5"), Unique:=False
End Sub
Is there a way I can get this to update automatically without having to hit enter. So no matter what I enter in the frst workbook the database updates per the selections?
I have been creating a spreadsheet that enables engineering to sort thru a large amount of data by using a configuration sheet and database. Based on the pull down menus I am able to create unique part numbers. Within the document I have numerous worsheets with a unique database. I have figured out how to filter the databases to get the part number I have entered. However, based on my selection on the 1st worksheet, I then have to go back to the worsheet with the data on it and hit "enter" to update the filter I have in place. I used the following code to update, but I still need to hit enter.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A7:F19").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range _
("A4:F5"), Unique:=False
End Sub
Is there a way I can get this to update automatically without having to hit enter. So no matter what I enter in the frst workbook the database updates per the selections?