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
Bookmarks