View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Doucette Paul Doucette is offline
external usenet poster
 
Posts: 40
Default 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