Autofilter and the Copy result Into another sheet

  • Re: Autofilter and the Copy result Into another sheet


    One additional info - This is going to be a part of a larger macro.


    Hence need a code.

  • Re: Autofilter and the Copy result Into another sheet


    Ok...i was able to record a macro.


    However, I am worried about the "AutoFilter Field:=5" bit. This field may move from month to month as raw data columns get added/deleted. Hence macro will fail as it will filter on incorrent column. Is there any way to tie it with the heading "Geography".


    Request your help. Thanks.


  • Re: Autofilter and the Copy result Into another sheet


    Try this

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!