Hi,

We are trying to copy filtered data from one Excel spreadsheet into an
Excel template. Users then save the file onto their hard-drive. We
cannot figure out a way to do this. There are numerous hidden columns
and 1/2 of the pane is frozen at column C (There are 23 columns of
data.)

When we try to copy and paste, the hidden column screws up the data,
(nothing is in the correct column. ) For example, if I had columns
titled as follows:

Title
Tracking Number (hidden column)
Department
and Sponsor


The Data would appear Follows:

Ankle Sprain Order Set, as the Title--This is correct
and Vinny Chang as the Department, This is incorrect.

When we Cut and Paste, the columns line up correctly, but all data from
the spreadsheet is copied under the filtered data.

When we copy using EditMove or Copy Sheet. . . , the filtered data is
filtered; but still there.

We are using Excel 2003.

Any suggestions.
Thanks
Kim