Bingo - thats it....Power Query......arrr rookie error. Thank you
Yeah thats what I thought - sadly VBA, MACRO, etc all blocked for security.....so formula is the only way I can think of. I can get a cell address ea...
Hi Sorry, to explain - the master sheet is a table format from query, with dashboards. It has country, site within the sheet also. I plan to only se...
Hi Mynda The VLOOKUP worked - thank you . Although I have left myself in a challenging next phase. The problem - I have a dashboard/s...
Mynda Thats what I was looking for big thank you - how do I make the icons dynamically change if the adjacent cell changes - so NO to YES sho...
That's ok....just started your dashboard course, had me thinking. If I am displaying my data from a sheet, could I actually create a front end to act...
Thought as much.was hoping a non VBA way due to organisations that tend to block macro and vba.