Yes. First I tried copying the row of stock prices and then paste special transpose into another worksheet-that works fine but I just get the values so each time the stock prices refresh I have to copy/transpose...
So, I figured let's 'convert' the share prices into formula by going =the cell in which the stock price result is.
A B C
My row is IBM GE BAC
117.16 14.50 17.02
So I go in another worksheet =117.16 to 'convert' the 117.16 into a 'formula' and try copy paste special transpose and I get A1, A2, A3 instead of A1,B1,C1.......
No, with paste special you are just copying static values. With the transpose function however a link will be maintained between the copied cells and the transposed cells so that any change in the original cell will be reflected in the transpose cell. I can give you the steps for creating these formulas, or set it up for you on your own file. Let me know which one you prefer.
Ok, here you go:
The file contains the instructions as well as an example. Hope it is clear. Let me know if you have any questions
If you found that helpful thanks you for clicking Accept.