It works fine within one spreadsheet but fails when I try to copy a
cell including a formula to a new excel spreadsheet and copies only
the value. Is there a way to force it to copy the formula so it
automatically applies to relative positions of cells containing
values? What I mean by that is if the formulas location is in A2 and
it applies to values in A1,B1 then if I copy it to the new spreadsheet
into say A4 than it will apply to values contained in cells A3,B3.
yaro