- Nov 5, 2007
I would like to copy/paste a column from one spreadsheet into another spreadsheet. The problem is that the source column shows values based on a calculation (eg. =(M1465/B1465+D1465)*C1465). My intention is to have the resulting value copied as a $ figure to the other spreadsheet but not updated or linked to the souce. How would I do this.