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.