Hi!
Am trying to convert a pivot table into a heat map which is updated every week with fresh data. Heat map colors are defined in the example sheet and have provided a sample view as well.
Need the below set of rules so that every time I update the file with new data;
1. Values get auto arranged in descending order for current week
2. Heat map should automatically pick up new data which gets added to the pivot table
Looking forward to hear from you.
Regards,
Dev
I was not able to open your file.
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.
@oeldere
You may find the file was renamed when downloaded (problem with some versions of some browsers - Internet Explorer does this to me too! ).
If your downloaded file has xlsx extension, change that to xls and then it should open without a problem
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Hi! I have reattached the file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks