Hi Leith,
Thankyou so much for your reply. In response to your first msg, yes I just need values (not formulas). I am reasonably new to these macros, but have copied the script you have written with my document names replacing WkbA or WkbB - but when I went to run the macro, it came up with 'Subscript out of Range'.....?
This is what my script looks like -
Is this correct? Or do I somehow have to give it the limits of the tabs I have in the workbook?
Thanks again for your help!
[QUOTE=Leith Ross;2328176]Hello ,
This macro will copy the data values from workbook "A" to workbook "B". You will need to change the name of workbook "A" to what you are using. Copy the macro into a VBA module in workbook "B".
Bookmarks