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

Easier to manage.


Gord Dibben MS Excel MVP

On Tue, 19 Jun 2007 05:46:00 -0700, Aurise
wrote:

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.

"Jovan Timotijevic" wrote:

Try Edit/Paste Special and use the PasteLink button.