copy part of large WS to another sheet

[Guest]

Excel 2000 - I'm trying to help a co-worker with this, but I'm only a bit
more proficient than she is. She has a very large worksheet and would like
to copy sections of it to individual sheets (in the same workbook), so that
she can work on the smaller sheets - easier to read, not so much scrolling,
etc. and update the larger, original worksheet at the same time. I can copy
one formula and have it reference back to the original sheet, but when I try
to copy the whole section, the formulas are copied, but they don't reference
back to the large sheet. I'm pretty sure this is not difficult to do, but I
don't know if I've worded the problem clearly enough for someone to help us.
Thanks.

 

[Guest]

Try Edit/Paste Special and use the PasteLink button.

 

[Guest]

Thank you so much! I'd never even noticed that there was a Paste Link option.
I realized after I posted the question though, that even if we get the links
(and now I know how) we still won't be able to do what we wanted - change the
info on the new sheet and have it update the original one. We can make the
changes on the original one and the new, smaller sheet will be updated. Is
there a way, or should she just stick to working on the large sheet? The
whole purpose of copying sections of the large 'summary' sheet was to have
fewer rows/columns to deal with at one time.

 

[Gord Dibben]

With the Filtering functions Excel provides under Data>Filter you wopuld be
better off keeping everything on one sheet.

Easier to manage.


Gord Dibben MS Excel MVP