I would like to copy information from one worksheet and paste across 20
different worksheets within one workbook.

Not all of the information copied in worksheet one needs to be pasted into
all of the other worksheets.

Is there a way to do this without clicking copy and paste lots and lots of
times ? ...

Try this,

Copy your data in (say) sheet 1 and then select sheet 2. Hold down the
control key and select each of the sheet s yo want to paste to.
Click Ctrl + V

Mike

"Del" wrote:

I would like to copy information from one worksheet and paste across 20
different worksheets within one workbook.

Not all of the information copied in worksheet one needs to be pasted into
all of the other worksheets.

Is there a way to do this without clicking copy and paste lots and lots of
times ? ...

I'm not sure, Mike, but I don't have a suggestion

OP did mention:
Not all of the information copied in worksheet one
needs to be pasted into all of the other worksheets

which makes his issue considerably more complex
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Max

I'm not sure either but if that doesn't work then I agree it's more
complicated and almost certailnly a macro.

Mike

"Max" wrote:

I'm not sure, Mike, but I don't have a suggestion

OP did mention:
Not all of the information copied in worksheet one
needs to be pasted into all of the other worksheets

which makes his issue considerably more complex
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---