Hello
I am attempting to create a macro that will use several rows of data to then filter on another sheet. Once filtered Id like to see the results on the 1st sheet. If possible it would be huge if I could also filter a second column to only include certain information. Hope this explains a little. Thanks for any help in advance. please see below
Id like to use the RUN numbers from sheet 1
to Filter the RUN column by those numbers on sheet 2
then Filter out certain paycodes on sheets 2
returning the remaining information to Sheet 1
I am attempting to create a macro that will use several rows of data to then filter on another sheet. Once filtered Id like to see the results on the 1st sheet. If possible it would be huge if I could also filter a second column to only include certain information. Hope this explains a little. Thanks for any help in advance. please see below
Id like to use the RUN numbers from sheet 1
to Filter the RUN column by those numbers on sheet 2
then Filter out certain paycodes on sheets 2
returning the remaining information to Sheet 1