worksheets equaling other worksheets

C

Chrissy

I have a main workbook that I would like to feed a scenerios workbook. How
can I make an entire worksheet equal another worksheet (value & format),
without making formulas in each cell? Once these two worksheets are linked,
I need to make rows in other sheets equal specific rows is the main scenerio
worksheet.
Any suggestions...
 
G

Gord Dibben

Pretty difficult to link sheets to one another without formulas.

Make a copy of the main worksheet.

Select the specific rows on the main sheet and copy then switch to the copied
sheet then select where you want to paste and Edit>Paste Special>Paste
Links>OK>Esc.


Gord Dibben MS Excel MVP
 

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

Top