I am a building a database. I need to remove $ from one part of a formula and add $ to another part of a formula.
I need to do this same action over and over again for the formula to calculate with the correct references?
How would one build this?
For example,
=PITimeDat(worksheet1!DY4,worksheet1!$A$5,"pi3","interpolated")
needs to become
=PITimeDat(worksheet1!$DY$4,worksheet1!A5,"pi3","interpolated")
The DY4 becomes fixed and A5 becomes unfixed.
Thank you in advance.