Ron de Bruin offers a number of ways to work with the different workbooks, such as working through all workbooks in a set folder or looping through a user defined selection of workbooks.
I have chosen to go with the latter option so that I can easily flick through each months SLAM folders.
As this macro is to work across multiple workbooks it needs to be saved in a normal module.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133 This has worked quite nicely for me.
We will respond with a solution with in couple of days and publish here to make it available for all VBA Users.
Tutorials to learn Excel 2003, 2007, 2010, 2013 Macros and Mastering in VBA.
I’ve been working on some VBA macro code to pull the data range from each tab of the monthly return and then stack them on top of each other.
I found snippets of code all over the web but I think the original code writer was Ron de Bruin who has some excellent VBA macro examples.
This particular culprit has somewhere in the region of 20 tabs relating to a particular care type – such as outpatients, admitted patient care, A&E etc, we then get 5 copies of this for each PCT.
Multiply this by 12 for each month of the year and you start to have quite an horrendous copy and paste task if you want to pull it all together manually.