HELP replacing cell references in equations with $X$Y format
Hi all,
Let me explain what I am trying to do.
I am trying to create a form where data can be input horizontally on
one worksheet of a document and then transposed automatically to
columns on a seperate worksheet within the same document.
I am on a short time line so I have to be able to do this quickly.
What I tried to do was copy over the reference to each cell but got a
REF error. After reading a few posts I found that the references
needed to be in a $x$y format for this to work. I have unfortunately
255 x 30 cells to change and would take quite some time to do this.
I am not very good at macros yet so I was wondering how would I be
able to make this change quickly?
Thanks,
John
|