Hi Riny, Apologies for the late reply. You are correct in that I achieved the result. However I went to and watched the link Jessica mentioned and ...
Hi Riny, Thanks for the reply. I tried to simplify it for better understanding of what I'm after. which contains a nested list or [TableFFromli...
Hi Jessica, Thanks for your tips. I tried Phil's method. and it does pull data from a table based on cell containing a 'value'. However I'm tryi...
Hi, I have a speed query also. I'm using excel 2016 and the data is in a sheet within my workbook. the data is 144000 rows. Th...
Awesome. Thanks. To assist I made a 'dummy' table and renamed the approriate columns & the table to match your code. I then copied the code ...