All,
I am having two problems with a UserForm
1.) First, this code is not populating the listbox with the relevant data. Sheet3 is getting the filtered data, but then I want the "Business_Unit_Test" ListBox to be populated with the filtered data. What am I doing wrong?:
2.) Then I want the data in the original source to be filtered by all the selections that the user makes (multi-select ListBoxes) to the original source sheet, and copied to Sheet5. So, I have a range of the filter selections in Sheet3 to populate the listboxes. I have a range of all items in Sheet1. And I want the Autofilter to apply the selected parameters from the listboxes to the data in sheet1 and copy to sheet5. How can I do this?
Thank you so much in advance.
I am having two problems with a UserForm
1.) First, this code is not populating the listbox with the relevant data. Sheet3 is getting the filtered data, but then I want the "Business_Unit_Test" ListBox to be populated with the filtered data. What am I doing wrong?:
Code:
With Sheet1 'Source data sheet with unfiltered data
.Range("D2", .Range("D65536").End(xlUp)).AdvancedFilter _
Action:=xlFilterCopy, CriteriaRange:="", CopyToRange:=Sheet3.Range("D2"), Unique:=True
Sheet3.Range("D2", Selection.End(xlDown)).CurrentRegion.Name = "Business_Unit"
Business_Unit_Test.RowSource = "Business_Unit"2.) Then I want the data in the original source to be filtered by all the selections that the user makes (multi-select ListBoxes) to the original source sheet, and copied to Sheet5. So, I have a range of the filter selections in Sheet3 to populate the listboxes. I have a range of all items in Sheet1. And I want the Autofilter to apply the selected parameters from the listboxes to the data in sheet1 and copy to sheet5. How can I do this?
Thank you so much in advance.
