Hi Lucas,

Thank you for your help in starting me off in my query.

I can certainly use what you have kindly provided to get me going in the right direction. I do however need a bit of assistant in ensuring the code does not include other names worksheets that i wish not to include in the macro.

I have tried various ways but to no avail.

Could you or anyone else please help in refining the following code to include another worksheet i.e called Rawdata that i wish not to be included in the macro.[vba]If Sheet.Name <> "Summary" Then ... rest of code[/vba]

Any help would be apprecaited.

BT