Hi,

I want to combine multiple workbooks into one tab without losing any data, please tell me what macro can I use?

Secondly sometimes I cannot copy over data from one tab/worksheet to another and I get this message, can someone tell me what this means?

Capture.1.JPG

My Excel version is 2010

Thanks
Sahrky