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

Embed the same Excel multiple times 0
Visio to Excel 0
VBA Coding Help for Beginner 0
Pasting a cell into bookmarked table from excel vba 1
How to paste this down? 3
Copy addition formula of non-consecutive horizontal cells 2
How to make repeating drop-down lists? 2
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0

Top