Can anyone help me?
If the result of the multiplication of a1 and b1 is in cell c1, how can I transpose the solution (contents of cell c) to another cell in a different sheet / workbook. O want the transposed value to be static such that if the original data/formulae or the sheet are changed / deleted I still retain the original value of the multiplication.
Any ideas?
If the result of the multiplication of a1 and b1 is in cell c1, how can I transpose the solution (contents of cell c) to another cell in a different sheet / workbook. O want the transposed value to be static such that if the original data/formulae or the sheet are changed / deleted I still retain the original value of the multiplication.
Any ideas?