Hi all. Really impressed with the help I got on my last thread so hoping you can help again.
I have a table of 12 rows that gets its figures from three other tables. I'd like for the data to autosort to keep the highest figure at the top (obviously the row with the highest figure may change when the other 3 tables update) I'd also like it to work out the percentage of the total each row accounts for.
I have attached a dummy copy as previously requested so you can see whats required. The table is highlighted in yellow.
Bookmarks