Hi Sunny, Sample workbook attached and there is a text box describing what I want to achieve. Thank you for your help 🙂 Gayle
Thanks Sunny I was hoping to avoid having to de-sensitise the data as even a small amount will take a bit of fiddling but I'll go ahead and do that an...
Thank you Mynda 🙂 My view wasn't quite the same as your example but it sent me on the right path and I have solved it now 🙂 Just in case anyone o...
Thank you Catalin and you're right I should have been clearer in my post that my date field was already formatted as a date and not as text! Your f...
I'm still trying to solve this and had a thought - does the linked table have to be a sheet in the same workbook? What I did was create a new workbook...
Oh my sincere apologies I did not even think of that as causing any issues! I will make sure that I do not make the same mistake again. Sorry for any ...
Thank you very much Mynda this works exactly as I needed 🙂 I have looked at how you wrote the query and think I have managed to follow the very creat...
Thank you Mynda but I cannot see any attachment? Where do I go to find that to download?
Hi Mynda Attached is a small example of the file - the problem I have is that site total can appear any number of rows after the site heading. Hope...