Hello everyone,
I'm new to VBA and google is my teacher. I have a difficult time finding or combing the appropriate VBA codes to do this task. I would appreciate it if someone could give me a hand!
I have a Pivit table called "PivitSpeed" with two columns: "Time" (txt format) and "Average of Speed" (number), and filters of location and month and day.
What I would like to do is to copy the data that meet the criteria (mentioned below) to a table in the same sheet (same location each time). The final goal is to plot both original pivot data and selected data into one graph, like this one I drew manually.
My criteria are period of time (in table "MPE_Period"), there are start time and end time, which varies on different dates. I used INDEX to get those to a table and it changes when the filter of location changes (but too bad it doesn't synchronize with date).
the original criteria table("MPE_C") looks like this:
Since I have 52 locations and a month of data. I hope to at least get the filtered data that meet the time period (time in between the start and end time) when my pivot filter changes. For example, when I select location 3, and Aug. 5 or 5-9, the data should be automatically screened and copied to a table. Even better, they are plotted in one graph!
I'm not sure if I'm clear about my question. Please let me know if more info is needed. Thank you all!!!!!
I'm new to VBA and google is my teacher. I have a difficult time finding or combing the appropriate VBA codes to do this task. I would appreciate it if someone could give me a hand!
I have a Pivit table called "PivitSpeed" with two columns: "Time" (txt format) and "Average of Speed" (number), and filters of location and month and day.
What I would like to do is to copy the data that meet the criteria (mentioned below) to a table in the same sheet (same location each time). The final goal is to plot both original pivot data and selected data into one graph, like this one I drew manually.
My criteria are period of time (in table "MPE_Period"), there are start time and end time, which varies on different dates. I used INDEX to get those to a table and it changes when the filter of location changes (but too bad it doesn't synchronize with date).
Since I have 52 locations and a month of data. I hope to at least get the filtered data that meet the time period (time in between the start and end time) when my pivot filter changes. For example, when I select location 3, and Aug. 5 or 5-9, the data should be automatically screened and copied to a table. Even better, they are plotted in one graph!
I'm not sure if I'm clear about my question. Please let me know if more info is needed. Thank you all!!!!!
