Hi everyone....
Could someone help me with a macro that would do the following:
I have code with formulas that look like the following:
Sheets("Application").[AMT_FINAN] = Sheets("DataSheet").[AMT_FINAN].Value
There are about 200 formulas in my code. What I need is to transpose the formula to look like this:
Sheets("DataSheet").[AMT_FINAN].Value = Sheets("Application").[AMT_FINAN]
on all 200!
The formulas all vary in length. Maybe i could copy all the formulas to a text file and do it from there? also, how would i do it?
Thanks
This message was edited by robfo0 on 2002-04-08 16:46
Could someone help me with a macro that would do the following:
I have code with formulas that look like the following:
Sheets("Application").[AMT_FINAN] = Sheets("DataSheet").[AMT_FINAN].Value
There are about 200 formulas in my code. What I need is to transpose the formula to look like this:
Sheets("DataSheet").[AMT_FINAN].Value = Sheets("Application").[AMT_FINAN]
on all 200!
The formulas all vary in length. Maybe i could copy all the formulas to a text file and do it from there? also, how would i do it?
Thanks
This message was edited by robfo0 on 2002-04-08 16:46