Forum Discussion
VBA Find (What:="") tied to dropdown list box
In the VBA Find(What:=), I want the What:=" " to get it's value from a drop down list box in sheet1. I have two worksheets, 1) sheet with three dropdown list boxes 2) sheet with unstructured data w...
Hi Fred,
I see the mistake that I made. I hope that the attached version works correctly. You'll notice that there is no Teams dropdown anymore. It isn't needed because the macro loops through all teams.
You only need to select a week, then click the button.
Thanks. Do you really want to use three separate workbooks, instead of three worksheets in a single workbook?
Hello Hans,
I made a macro to make the Drive Count worksheet and did that just because there was going to be more data to capture. I still run the macro to populate the Dropdownlistbox range I3:ac35 for the weeks. We could take the headers from the Drive Count worksheet and copy them down to row 40 starting in column B in the Dropdownlistbox. That way we just use two worksheets.
I made a macro to make the Drive Count worksheet and did that just because there was going to be more data to capture. I still run the macro to populate the Dropdownlistbox range I3:ac35 for the weeks. We could take the headers from the Drive Count worksheet and copy them down to row 40 starting in column B in the Dropdownlistbox. That way we just use two worksheets.
- Hans,
After looking at the change I suggested that's not going to work. So, let's just put those headers in range AE3:EJ4
