Copying from one worksheet to multiple worksheets

D

davecline

How do you copy from one cell in a worksheet to a similar cell in 25 other
worksheets in the workbook/file?
 
D

David Biddulph

Select the range of sheets to group them.
Click in the destination cell in one of those sheets.
Type an = sign.
Go to your source shhet & click in the source cell.
Your formula will now show something like =Sheet1!A1; hit enter to accept
the formula.
You can now ungroup your destination sheets by selecting just one of them.
 

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

Visio to Excel 0
Embed the same Excel multiple times 0
VBA Coding Help for Beginner 0
VBA to do a mailmerge from a Specific Excel worksheet 0
Multiple worksheet summary 4
Can the IF function be used with values from multiple worksheets? 4
Cannot copy worksheet to another file 2
Auto deletion of cell entry in given circumstance 0

Top