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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging worksheets within the same workbook 3
SUM function across multiple worksheets within one workbook 4
how to synchronize data value across two worksheets in one workbook? 2
copy one row at a time to different worksheets 1
Paste, Paste Special 2
Identical Cells in Multiple Worksheets in one Workbook. 4
How to copy & paste a worksheet but change 1 bit of the formula? 1
autofilters on worksheets within workbook 4

Top