Transpose values all cells from Sheet2 to Sheet1

[bdb1974]

For all that's interested... what i did was... on the sheet I wanted to transpose to,Starting w/ the first cell, click, in the formula box, type ,=
then goto the other sheet w/data and click. Excel will autofill the formula.
Then, using that newly transposed cell , copy and paste to all the other cells.
This will auto transpose the rest of the cells in direct relationship to Cell column and row of the other sheet. Next, I went back to and did copy and
pasted the formats of the cells. After completion, I've got a mirror copy
of my sheet. There's still probably a simpler way of doing this. But this
worked for me.

----------------------------------------------
Need a
Simple VBA code or excel formula to display values and cell coloring generated from the formulas or vba code from sheet2 onto sheet1

thanks,
BDB

[shg]

Why not just copy the whole sheet?

[bdb1974]

Basically that's what I have done. But, I want my sheet 1 to not contain the formulas.
The cells should just mirror sheet 2 values and update when sheet 2 is updated.
When I want to sort my roles by a drop down list box , I want all the data in every column to be correct after the sort. Sorting the sheet with the formulas causes the
incorrect results or loss of data to the cells w/ formulas