How to paste across 20 worksheets within one workbook
 

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 ? ...

How to paste across 20 worksheets within one workbook
 

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 ? ...

How to paste across 20 worksheets within one workbook
 

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
---

How to paste across 20 worksheets within one workbook
 

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
---