Cerberus wrote:
I made this spread sheet and I started putting all my formulas and a matrix
on sheet 1 since it was to be a small project. The project went from a
simple spread sheet to a major project and now I have dozens of matrices on
sheet 1. Now that I look back at what I have done I see a sheet that is
using information in column DT. Is there a way to take the information and
formulas from say columns E-DT to sheet 2 and make it reference sheet 1 and
vise versa without completely re-writing the formulas? I am sure I will have
to modify the formulas some but I dont know how to go about this. Thanks in
advance for any help.


Why don't you try and CUT a portion of your spreadsheet and PASTE to another
worksheet (not too much)
Then if it still works, save it under a new filename, then do a bit more and
so on and on and on etc.
You might then see if you can carry on doing it that way

Good luck

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200802/1