Good morning,
I am looking to produce a dashboard for analysing Incident statistics.
The data I have been given is in a Cross table format.
I need to rearrange the data into 4 x columns named "Station" "Meeting date" "Incident Type" "Number of Incidents"
I have seen macros that can do this but I can't seem to adapt the code to my needs.
Any help will be gratefully received.
Many thanks
Phil
Last edited by sa1ntj0hn; 11-24-2017 at 08:12 AM.
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Hi Mike,
Thanks for the heads up.
I have now attached a before and after in the example file.
Thanks
Phil
Coded this up before I seen your last post.
Please Login or Register to view this content.
Just remove the If statement from my previous post
Please Login or Register to view this content.
That is brilliant Mike thank you so much for your help.
Phil
Your Welcome... Thanks for the Rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks