Create an Excel Template
Hi guys, I'm stuck trying to create either a regular table or pivot table.
Here's my dilemma; I have information which needs to further sort by as follows
Monthly
Location
By type
Attached a sample file which require further analysis the data mainly monthly. I had tried to create pivot table but failed as not filter by month.
Kindly requested to help me to create a sample template I can fill the data accordingly
Thanks
Pranav
I used the code below to re-arange the data.
After that you can make a pivot table.
See the attached file.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Originally Posted by oeldere
I used the code below to re-arange the data.
After that you can make a pivot table.
See the attached file.
Please Login or Register to view this content.
Many thanks for the swift response.
I am not that much expert VBA. could you please elaborate as i need to convert big volume of data to re-arrange
Thanks & highly apricates your support
Pranav
I am not that much expert VBA
Neither am I.
If the data is the as in your example this code will work.
Try it on a dummy of your file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks