Rock_Lobster
New Member
- Joined
- May 16, 2017
- Messages
- 1
Hello all,
I have gone through every link I can find on the subject, and simply cannot find an answer to my problem.
I consider myself pretty decent with VBA, but this one has had me stumped for three weeks.
I have an OLAP pivot table that has a filter for Order Numbers, and a slicer to control said filter. The table shows all SKUs related to these Order Numbers, and the Quantities sold for four regions.
On a second tab, I have a table that I can plug in all orders for the last week, and the Order Number field in this table is a dynamic range.
The idea behind this whole project is that the pivot brings up the SKUs and Quantities which I need, based on the Order Numbers that are in the table on the second tab. This would eliminate the need to individually click into each order in our Intranet, and copy the details to a sheet each time I am working.
What I am attempting to do is utilize VBA to only select those Order Numbers in the slicer that are in the dynamic range, so that the respective SKUs and Quantities show.
*Side Note* - I have tried to run this based on date (the last week), but the issue was that if anything was back ordered from before, but was fulfilled in the last "week", then it brings in all of that old information.
Please help! I would be forever grateful!
I have gone through every link I can find on the subject, and simply cannot find an answer to my problem.
I consider myself pretty decent with VBA, but this one has had me stumped for three weeks.
I have an OLAP pivot table that has a filter for Order Numbers, and a slicer to control said filter. The table shows all SKUs related to these Order Numbers, and the Quantities sold for four regions.
On a second tab, I have a table that I can plug in all orders for the last week, and the Order Number field in this table is a dynamic range.
The idea behind this whole project is that the pivot brings up the SKUs and Quantities which I need, based on the Order Numbers that are in the table on the second tab. This would eliminate the need to individually click into each order in our Intranet, and copy the details to a sheet each time I am working.
What I am attempting to do is utilize VBA to only select those Order Numbers in the slicer that are in the dynamic range, so that the respective SKUs and Quantities show.
*Side Note* - I have tried to run this based on date (the last week), but the issue was that if anything was back ordered from before, but was fulfilled in the last "week", then it brings in all of that old information.
Please help! I would be forever grateful!
