excel - Apply filter from a master worksheet to multiple worksheets -


I am trying to apply a filter to several worksheets in a single workbook from a master worksheet.

For example.

Country code , InvAmount

Countrycode, SaleMount

  1. Inventory

    P>

    When I'm FRA, JPN, and By filtering country sheets by the United States, I hope that the sales and inventory sheets will automatically follow the same filter criteria, and will display only FRA, JPN, and USA rows.

    It does not seem very complicated, but I am trying to code using VB AdvancedFilter method, there is no luck for a few days! Many thanks for your help!

    You want something that I think is, insert the category that you want to filter in each worksheet I want to do where I have kept xx . Change i, ii and iii with the country code of FA, JPN and USA.

    Please note that this country is filtering as a country code against the country because it is normal field. 

      Option Definitive sub apply_filter () Design the worksheet as a worksheet in this workbook. Worksheets with Ws. Range ("xx"). Autofilter field: = 1, criteria1: = array ("I", _ "ii", "iii"), operator: = xlfilter valve end and end and end    < / Html>

Comments

Post a Comment