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.