You are exactly correct. Real bad terminology. Should have used "copy".
I have 20 columns with data assigned to a particular individual. I want to
"copy" various columns, same information and format, to a different sheet,
without having to go thru the motions of "copy-paste" on each column to the
next. Maybe what I am looking for is an array formula. Example, row "A" is
Bill with 100 data entries in the column. Then copy paste the array formula
on the second page, and the array will fill in the column. Am I still
confusing you?

"Gord Dibben" wrote:

Not clear with your description.

Transpose means rotating the data by 90 degrees.

What do column headers in either sheet have to do with that?


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 09:36:01 -0700, Going Crazy with excel
wrote:

I have a master data base of 20 columns of data. I want to transpose only 6
columns of that data to a different sheet, automatically recognizing the
column headers from the master sheet to the matching column headers on a
separte sheet. I suspect this can be acomplished with the Transpose
Function. Just can't figure out how. Any help would be greatly appreciated.


.