Hello from Steved

Sorry please ignore as 2007 allows you to copy then paste in several
worksheets after you have saved the previos worksheets. Earlier versions did
not allow this.

Cheers

"Steved" wrote:

Hello from Steved

Copy then Paste Special, Value ( Excel 2007 version )

I would like to copy a Value from a workbook to several other workbooks

What I reqiure is a Macro that when I copy a value it allows me to paste in
other Workbooks even if I save each workbook as I go along please.

Thankyou