software

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 SponsorThe 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 Editgt;Move or Copy Sheet. . . , the filtered data is
filtered; but still there.

We are using Excel 2003.

Any suggestions.
Thanks
KimOnly copy the visible cells
See this example for AutoFilter

www.contextures.com/xlautofilter03.html#Copy
--
Regards Ron de Bruin
www.rondebruin.nlgt; wrote in message oups.com...
gt; Hi,
gt;
gt; We are trying to copy filtered data from one Excel spreadsheet into an
gt; Excel template. Users then save the file onto their hard-drive. We
gt; cannot figure out a way to do this. There are numerous hidden columns
gt; and 1/2 of the pane is frozen at column C (There are 23 columns of
gt; data.)
gt;
gt; When we try to copy and paste, the hidden column screws up the data,
gt; (nothing is in the correct column. ) For example, if I had columns
gt; titled as follows:
gt;
gt; Title
gt; Tracking Number (hidden column)
gt; Department
gt; and Sponsor
gt;
gt;
gt; The Data would appear Follows:
gt;
gt; Ankle Sprain Order Set, as the Title--This is correct
gt; and Vinny Chang as the Department, This is incorrect.
gt;
gt; When we Cut and Paste, the columns line up correctly, but all data from
gt; the spreadsheet is copied under the filtered data.
gt;
gt; When we copy using Editgt;Move or Copy Sheet. . . , the filtered data is
gt; filtered; but still there.
gt;
gt; We are using Excel 2003.
gt;
gt; Any suggestions.
gt; Thanks
gt; Kim
gt;
Hi,

I tried it, and it still gets gets messed up by the hidden columns.

Thanks though!When you paste, the data is pasted into a contiguous block of cells,
even if columns or rows in that range are hidden.

Perhaps the hidden columns in the destination workbooks could be moved
to the far right of the table, so they don't interfere with the copy and
paste.
wrote:
gt; Hi,
gt;
gt; I tried it, and it still gets gets messed up by the hidden columns.
gt;
gt; Thanks though!
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html