But that does not work, because the weeks are arranged as columns like this:
Name Product Week1 Week2 Week3..
I want the data to be so that the "Week" columns are put in rows:
Name Product Week1
Week2
Week3
Again the example does not show correctly above, but pretend that "Week2" and...
I have some data arranged like this:
week 1 week 2 week 3 week 4
a b c 50 60 70 80
d e f 2 3 4 5
g h i 44 45 46 47
But I would like to have it like this:
a b c week 1 50
a b c week 2 60
a b c week 3 70
a b c week 4 80
d e f week 1 2
d e f week 2 3
d e f week 3 4
d e f...
Hello!
I'm Marko from Helsinki, Finland. I work in a chemicals company as a controller, and currently I'm trying to build different kinds of dashboards in Excel for various reports that I do monthly. I took a VBA course in my university a few years ago, but my interest in macros was recently...
Hi!
I have several pivot tables in a file, and in some of them a pivotField called "Month number" among the report filters.
I also have a macro which, whenever I modify the "Month number" pivotField in the report filter in any of the pivot tables, sets the other pivot table filters equal as...
I do enable macros, but I have not saved the pivot tables with the underlying data to keep the file size small. I get the following error message when trying to use the PT:
"The PivotTable report was saved without the underlying data. Use the Refresh Data command to update the report."
This...
I have a problem with a macro, which changes pivot table filter values when I choose an item from a drop-down list in another worksheet.
Everytime I open the file, the macro doesn't work before I refresh the pivot tables, and because all underlying data is stored in other Excel files the...