How to paste across 20 worksheets within one workbook

D

Del

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

Mike H

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
 
M

Max

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
Click to expand...

which makes his issue considerably more complex
 
M

Mike H

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
 
Top