Hello All, first post on the forum!
I have a spreadsheet thats filled by Production Planning Analysts with the amount of part supplied to the factory each day.
This way of filling the info is confortable for them, but it makes it impossible for me to make a Pivot Table out of it, so I would like to know:
1. Is there a way to directly make it into a Pivot table without sorting it?
2. Is there a way, out of VBA, to sort the data in a way it is possible to make a pivot table? I can do it manually, but thats not what excel is paid for
I'm working to change the filling method itself, but the amount of backlog data is humongous.
Thanks!
Bookmarks