Riny - thank you, this is absolutely spot on. I think merging the table with itself is amazing. Thank you again. David
Hi Alan Sorry for the delay in responding - the holiday season seems to make everything busier... Please see a sample sheet below (cant add fil...
Hi Anders Thank you so much for your response - what you have shown is very interesting, and will be of use on some other issues I am having. Ho...
Hi Mynda - thank you for the response I am using 365 - and have never used FILTER before... I will take a look into this but it does look as if it...
Hi Catalin Thank you so much fro the response - this makes an amazing difference in speed. Certainly one to remember for the future. Thank y...
Thanks Mynda After scratching around for a while i found this solution - not too elegant, but works I grab the new data, demote the headers,...
Hi Mynda Thank you for the reply - this is a really good solution - I can manage to copy all data from one table to another at time of workbook clo...