Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. paulasky220

    Updating Pivot Table

    what's the showpages method?
  2. paulasky220

    Updating Pivot Table

    Basically, I have 3 years worth of data by quarters..2007-2009, I deleted 2007 and replaced info with 2010 and when I refresh my pivot tables 2008 info is populated in the other spreadsheet. The pivot tables are my source of info where the information is being pulled from for another summary...
  3. paulasky220

    Updating Pivot Table

    I would like to create a macro where once the master data worksheet is updated with a new year, the pivot table will update this information.. example 1Q07 below will become 1Q08. Have no idea if this is possible... ActiveSheet.PivotTables("PivotTable101").PivotFields("Date").ClearAllFilters...
  4. paulasky220

    Code

    Thanks!! :)
  5. paulasky220

    Code

    Hi Skip, Thanks for the code. That's the one I need. I'm recorded the below macro and then hid the worksheets and then tried to run the macro again but it won't work cause the worksheets are hidden. Is there a code to unhide each of the worksheets so it can run? Thanks for your help. I'm really...
  6. paulasky220

    Code

    What's the code so that you can't see the macro as it's running and also the code so that you can run a macro after hiding worksheets

Part and Inventory Search

Back
Top