All Questions
6
questions
1
vote
0
answers
69
views
How do I extract design information from a pivot table in an external worksheet (properties) (Excel)
I am teaching a course in Microsoft Excel, using Excel 2019. As part of an exam in this course, I ask students to create pivot tables. I will then need to grade these exams.
Each student submits an ...
0
votes
0
answers
22
views
How to move specific cells in a row from one worksheet to another based on Month in Month Due column
I have been googling for a while trying to find a solution for how to copy specific cells in a row from one sheet to another. I have only been finding ways to copy entire rows. I have a workbook and ...
0
votes
1
answer
816
views
Excel pivot values column to Text
I have data in Excel pivot and my text data in value column shows number instead of Text . Any one can help me please. In below image of pivot value field red circled:
0
votes
1
answer
6k
views
Add Slicer Selections to sheet in a list - Excel VBA
I have a pivot table With a slicer that a user can make multiple selections in. I am trying to list the selected values in the slicer so they can then be joined together in another cell using ...
0
votes
0
answers
357
views
Excel - Pivot table drill down using SUMIF
Not sure if this is possible, maybe with VBA but I can't work it out.
I have a pivot table that I want to be able to filter totals to separate totals less than/greater than a value. (eg all totals >5)...
1
vote
4
answers
421
views
Determining whether VBA is necessary in Excel, or if a pivot chart/table can suffice
I wish that I had a more precisely descriptive title for this question, but I am not very knowledgeable with Excel spreadsheets or VBA (I'm primarily a Java developer, and don't play much in the ...