I have a rather large worksheet loaded with complex formulated cells. I need to copy the sheet and add it in other worksheets related to other dates. When I do this, within the formulated cell, there is a reference to the original worksheet i.e. October2010 example:
=SUM('T:\[October2010.xls]input'!AL102:AL111)
How do I copy the formulated cells worksheet without the references? I need to do this for every month of the year for several different venues and add it into existing worksheets.
=SUM('T:\[October2010.xls]input'!AL102:AL111)
How do I copy the formulated cells worksheet without the references? I need to do this for every month of the year for several different venues and add it into existing worksheets.
