kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
Hello,
I am looking for a macro that will take user input from an InputBox then filter all rows that contain the input numbers and display the outcome into a listbox.
That is, when the InputBox appears, it takes the first number then second number and then searches through the range of data and locate all rows containing the numbers entered into the InputBox.
The row must have both numbers not just one of them. The order of the input does not matter.
Thanks in advance
Kelly
I am looking for a macro that will take user input from an InputBox then filter all rows that contain the input numbers and display the outcome into a listbox.
That is, when the InputBox appears, it takes the first number then second number and then searches through the range of data and locate all rows containing the numbers entered into the InputBox.
The row must have both numbers not just one of them. The order of the input does not matter.
Thanks in advance
Kelly