Last seen: Jul 10, 2025
Hi I wondered if you could help. Is there a way of cobining all the worsheets in my data folder into one worksheet - solely to make it easier to h...
Sorted!!! I looked in the file explorer at the files in data folder - most were 30kb or so...but one was 90k and two were 45k. So I opened those f...
What I did do was take a blank workbook, data, from file, from folder etc I then loaded 4million plus rows ! clearly something is amiss. Yesterd...
I don't know!!!
Sorry - forgot to add - no sliders, just the six pivot tables
Good morning Riny Thankyou for your reply. Apologies for using the wrong terms. Each file contains the data for one month "...2025_06" for example...
Good afternoon Charles Thank you so much for your reply and script. I played around with it - silly me - and in the end got myself in a real twist...
Fantastic Wonderful Superb Can you help with VBA as well? Best wishes Chris
Thank you - worked perfectly. I have now amended each of the colums on the Schools and Data sheets which I hope makes things clearer. On reflectio...
Apologies - the heading was wrong - it should have read Data Validation across two worksheets