Hi,

I need to display a set of information in both Horizontal and Vertical fields on separate sheets for different functions. I know how to paste the fields from Horizontal to Vertical ( basically converting a Row of data into columns. But I also want to link the data so if I fill in the Rows, the column cells stay sync'd

Its easy to do Row to Row or Column to Column, but I'm stuck on how to do it with the conversion ( aside from doing it one cell at a time)

Any Help would be appreciated

Regards,