MasterBash
New Member
- Joined
- Jan 22, 2022
- Messages
- 47
- Office Version
- 365
- 2021
- Platform
- Windows
Hello,
I am almost done with my project. I sincerely appreciate the help, so does my team. They really like the improvements.
I believe this will be my last question involving this project.
Now... I am looking to dynamically extract data from a table. Currently, I did something manually, but I *think* simply using a PivotTable may be a better option ? I would like some thoughts. Please see the screenshot.
Why a PivotTable ? It doesn't show the rows and columns when the sum of the values = 0. However, the problem that I am facing is that... When that row or column does not equal 0 anymore, I have to add that specific data back under "Values" everytime.
The screenshot contains some explanations.
Thank you.![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I am almost done with my project. I sincerely appreciate the help, so does my team. They really like the improvements.
I believe this will be my last question involving this project.
Now... I am looking to dynamically extract data from a table. Currently, I did something manually, but I *think* simply using a PivotTable may be a better option ? I would like some thoughts. Please see the screenshot.
Why a PivotTable ? It doesn't show the rows and columns when the sum of the values = 0. However, the problem that I am facing is that... When that row or column does not equal 0 anymore, I have to add that specific data back under "Values" everytime.
The screenshot contains some explanations.
Thank you.