johnstewartjr
New Member
- Joined
- Dec 10, 2009
- Messages
- 16
Dear Mr. Excel,
I need to copy values that will be updated from "Sheet1" and transpose these values in "Sheet2". CopyPaste Transpose will not work because the values in "Sheet1" are based on formulas that will be updated frequently. Will Indirect Address work, and if so what is the best method?
Thanks
I need to copy values that will be updated from "Sheet1" and transpose these values in "Sheet2". CopyPaste Transpose will not work because the values in "Sheet1" are based on formulas that will be updated frequently. Will Indirect Address work, and if so what is the best method?
Thanks