data filter via VBA
I have a command button that runs code in order to assign a random number and save a workbook. I would like to add a step to this code so that it takes the number that is in WorkSheet Start cell D1, and uses that number in a data filter that is on another worksheet. The location of the filter is: APsheet cell E3, and I would like that to filter for anything that contains the number from Start D1.
Is this possible, or should I find another method?
Thanks in advance!
Paul
|