I want to setup my excel spread sheet a sideways so that I can import the
data properly into a different program. This means that all of the data in
ROW 1 would become COLUMN A etc. etc. What is the best way to reference all
the data from another sheet and put it onto the new sheet? Can I do this
without a macro?