Transposing formula from Row to Column
Transposing formula from Row to Column
(OP)
I have a series of formula in a row and I want to produce the same in a column on another worksheet.
I thought that thread770-25863 (which uses Notepad)would help but it does not as it increments the Row Number.
Copy, Paste special, Transpose only works on data not formula.
Any solutions?
I thought that thread770-25863 (which uses Notepad)would help but it does not as it increments the Row Number.
Copy, Paste special, Transpose only works on data not formula.
Any solutions?





RE: Transposing formula from Row to Column
RE: Transposing formula from Row to Column
RE: Transposing formula from Row to Column
RE: Transposing formula from Row to Column
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Transposing formula from Row to Column
When I do that I get #REF in the cell.
RE: Transposing formula from Row to Column
RE: Transposing formula from Row to Column
RE: Transposing formula from Row to Column
The ASAP Utilities is the answer. It works well.