I am a fairly new Excel User. What I am trying to do is create a totally
separate Excel Workbook that includes the data already populated in an
existing Excel Workbook, but in the new Workbook I only want to include a few
selected columns from the Source Workbook, rather than the entire Source
Workbook.

What I have done so far is :

a) Right-Clicked on the Column Header in my Source Workbook of the first
Column that I wanted to include in my new Target Workbook, and selected the
"Copy" Option
b) Right-Clicked on the Column Header in my Target Workbook of the Column
where I want the replicated data to appear, and selected the "Paste Special"
option (selecting Paste ALL, Operation NONE), and selecting the "Paste Link"
option.
c) I then repeated this process for each additional column in my Source
Workbook that I want to appear in my new, Target Workbook.

This process worked GREAT, copying all of the data from the columns that I
wanted into my new Workbook, but what it didn't copy is the Formatting type
attributes (Boldness, Alignment, Cell Format, etc.) from the Source Workbook.

What I would like to know is whether there is anything I could do
differently, so that I would get not only the raw data, but also the same
formatting that it has in the Source Workbook when it is displayed in my
Target Workbook.

Thanks

m_egle