K
karlcsr
Hi...first time I have posted here. I have slightly altered a long,
long column of data into a separate column that is slighly modified.
So the result in the second column might be something simple like
R1C1/2.
BUT this new column is now made of FORMULAS as opposed to hard data.
When I try to transfer this LONG column of "formulas" as opposed to
data to a different worksheet, the program won't work as it doesn't
know what the formula is referring to.
So with that background my question is: Can I convert the second
column I created to plain data? In other words the first row of the
column may display 10. I just want that cell to equal the data 10 --
NOT R1C1/2.
Thanks!
long column of data into a separate column that is slighly modified.
So the result in the second column might be something simple like
R1C1/2.
BUT this new column is now made of FORMULAS as opposed to hard data.
When I try to transfer this LONG column of "formulas" as opposed to
data to a different worksheet, the program won't work as it doesn't
know what the formula is referring to.
So with that background my question is: Can I convert the second
column I created to plain data? In other words the first row of the
column may display 10. I just want that cell to equal the data 10 --
NOT R1C1/2.
Thanks!