I cannot find a way to quickly link data in rows from one worksheet to
columns in another without using the hold = button select cell method-- which
is very slow. I dump data from a survey tool into excel. It is displayed in
rows. I would like to link that data to columns in another worksheet so that
I can line up survey results by group side by side. The questions would run
down Column A, the answers would run down columns B, C, D -- so i can do a
side by side comparison with the data. What formula will allow me to do this
quickly?