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.