But as long as they are in the same order, the plan will work. If you want,
say, columns 7, 10, 14, 15, 18 and 20 from the master copied to the new
sheet, hide columns 1 to 6, 8, 9, 11, 12, 13, 16, 17 and 19. Then copy.

If they're not in the same order, you could have a hidden row on the new
sheet which sorts the columns for you.

Or, a macro might be your best solution.

Regards,
Fred

"Going Crazy with excel"
wrote in message ...
Thought of that as well. Unfortunately, doesn't solve my problem. Master
columns are 1-20. On new sheet, they will vary in the order of the
column.
Column 1 may be in the 7th spot, etc. Good plan but.....

"Gord Dibben" wrote:

Sounds like a good plan Fred.

See what OP comes back with.


Gord

On Tue, 25 May 2010 13:26:31 -0600, "Fred Smith"
wrote:

Do you mean "transfer" as opposed to "transpose"?

If so, hopefully the columns in your two sheets are in the same order.
If
so, just hide the unwanted 14 columns in your master data base, copy the
visible cells, then unhide the columns.

Regards,
Fred

"Going Crazy with excel"
wrote in message
...
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.


.