+ Reply to Thread
Results 1 to 2 of 2

filter data in a pivottable using a macro

  1. #1
    Registered User
    Join Date
    09-16-2023
    Location
    Spain
    MS-Off Ver
    365
    Posts
    23

    filter data in a pivottable using a macro

    Hello Folks,
    who can help me please,
    I am trying to filter data inside a pivottable, using VBA or creating as a macro.
    The data I am searching for are coming from another table which is updated daily. It means I need to redo the search job daily. I am doing that manually right now, which is really timeconsuming using the filter within that pivottable.
    I need to search for 4 data which must all meet. When i have a match in my pivottable I use that match to send it to another (new table).

    I am enclosing a screenshot.
    Here is the explanation:
    The macro should work in the Tab :"O_U"
    The Datacells (where the found values should be added) are also in tab "O_U"
    The Pivottable is called "ELOd_ELOh" and is found in Tab "O_U" in cells B7 till H7 and downwards.
    The Macro must look for values which are highlighted in cells C2 till F2 and searches the whole Pivottable.
    The Pivottable is adjusted daily with new data.
    The Datacells are in column K11 and downwards.
    The Datacells will be added daily (new data are added) and the macro must fill that Datacells with its findings.
    The values the macro should look for are out from Datatable, called "Matchday". Right now the wanted data for search are being send to cells C2 till F2 by a macro called "Aus Zeile kopieren". Unfortunaltely only line by line. Very timeconsuming till now...

    Hopefully someone can help me to sort out my problem to automate that task

    Thank you
    Thomas
    Attached Images Attached Images

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: filter data in a pivottable using a macro

    Screenshots are nice, but if you expect an answer you need to provide a sample workbook.

    The best solution I have to offer is maybe you can do something with slicers.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to sync PivotTable with data source without checking (blank) in filter
    By MannStewart in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-31-2021, 11:14 PM
  2. After updating PivotTable Source data with Macro, slicer doesn't show PivotTable
    By mrdouglaswee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2018, 02:10 AM
  3. Filter primary pivottable Data Model with parameters from another table
    By George_1990 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2017, 11:01 AM
  4. Filter by Top 6 and Other in a PivotTable
    By 1953CAG in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-27-2016, 03:11 AM
  5. filter in pivottable
    By stephme55 in forum Excel General
    Replies: 4
    Last Post: 05-20-2016, 01:09 PM
  6. Macro to set pivottable-filter to next entry
    By JWFO in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2009, 05:05 AM
  7. macro that hides data fields in pivottable not working
    By fecurtis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2008, 10:36 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1