I have a row of 50 cells in one sheet and want to replicate those formulas in a separate sheet but as a column rather than a row. I'm trying to find a way of setting up = formulas in the second sheet without having to manually enter =E6; =F6; =G6 etc. I've tried copying and moving the row and transposing the copy formulas but no luck. There must be an easy way!!!