clintonjh said:Thnaks for the response.
The problem is the reference cells are not always formulas but values. eg. Sheet 1: A1=10, A2=20, A3=30 to be sent to Sheet 2: B1, C1, D1.
If the values in Sheet 1 change, we want them reflected in Sheet 2. Formulas are much easier as you can always make them absolute as you say.
Though Im sure there's a better way I got this to work
Lets assume you want to transpose formula in B1:D1 of Sheet2 that links to A1:A3 of Sheet1 ... OK ?
DO all steps in Sheet 2:
Step 1:
in cell A1 put =sheet1!$A1
...