C
Chris
I have 2 worksheets, on worksheet 2 I created figures by using formulas
using refrences to the other worksheet (worksheet1). I now need to use the
new figures on worksheet 2 to create a new worksheet using different
formulas to create yet a different set of figures.
Every time I try to use the new formula on worksheet 2 it just puts a 0 in
the cell and says something about Circular formula. I have tried to copy
and paste the worksheet into a new excel window but it just copies the
formula with it.
I want to be able to get rid of all the formula on wsheet2 but still leave
the figures it created using those formulas with wsheet1.
Any ideas? I have tried everything the only thing I can see of doing is
having to manually create a new table and type all the figures back in which
wil take me ages as its 100 rows and 100 columns!!!
using refrences to the other worksheet (worksheet1). I now need to use the
new figures on worksheet 2 to create a new worksheet using different
formulas to create yet a different set of figures.
Every time I try to use the new formula on worksheet 2 it just puts a 0 in
the cell and says something about Circular formula. I have tried to copy
and paste the worksheet into a new excel window but it just copies the
formula with it.
I want to be able to get rid of all the formula on wsheet2 but still leave
the figures it created using those formulas with wsheet1.
Any ideas? I have tried everything the only thing I can see of doing is
having to manually create a new table and type all the figures back in which
wil take me ages as its 100 rows and 100 columns!!!