software

I am trying to find out how Copy/Paste works during an Autofilter.
I have a shared Excel file. I create a copy and put it on our ipaq pocket
pc's.
It uses pocket excel.
When the ipaq comes back, I want to copy/paste the new data from it, into
the main excel file. I get different results-usually the wrong one.
I have both files open, put the same autofilter on both, and copy/paste
special- values/skip blanks.
Sometimes it works, but most of the time, it also copies the data that is
hidden in the autofilter-which shifts all my data into the wrong cells.
My question is:
I want to copy/paste the visible data in autofilter into another sheet with
the same autofilter on.
Does anyone know how to do it properly, or know where to find info on how it
works, so I can try to change what I am doing.
Thanks,
Joe

Select the filtered list, press F5, special and select visible cells only,
copy and paste

--

Regards,

Peo Sjoblom

quot;honyackerquot; gt; wrote in message
...
gt; I am trying to find out how Copy/Paste works during an Autofilter.
gt; I have a shared Excel file. I create a copy and put it on our ipaq pocket
gt; pc's.
gt; It uses pocket excel.
gt; When the ipaq comes back, I want to copy/paste the new data from it, into
gt; the main excel file. I get different results-usually the wrong one.
gt; I have both files open, put the same autofilter on both, and copy/paste
gt; special- values/skip blanks.
gt; Sometimes it works, but most of the time, it also copies the data that is
gt; hidden in the autofilter-which shifts all my data into the wrong cells.
gt; My question is:
gt; I want to copy/paste the visible data in autofilter into another sheet
with
gt; the same autofilter on.
gt; Does anyone know how to do it properly, or know where to find info on how
it
gt; works, so I can try to change what I am doing.
gt; Thanks,
gt; Joe
gt;
gt;
gt;
Thank you Peo!
Works perfectly.
Joe

quot;honyackerquot; gt; wrote in message
...
gt;I am trying to find out how Copy/Paste works during an Autofilter.
gt; I have a shared Excel file. I create a copy and put it on our ipaq pocket
gt; pc's.
gt; It uses pocket excel.
gt; When the ipaq comes back, I want to copy/paste the new data from it, into
gt; the main excel file. I get different results-usually the wrong one.
gt; I have both files open, put the same autofilter on both, and copy/paste
gt; special- values/skip blanks.
gt; Sometimes it works, but most of the time, it also copies the data that is
gt; hidden in the autofilter-which shifts all my data into the wrong cells.
gt; My question is:
gt; I want to copy/paste the visible data in autofilter into another sheet
gt; with the same autofilter on.
gt; Does anyone know how to do it properly, or know where to find info on how
gt; it works, so I can try to change what I am doing.
gt; Thanks,
gt; Joe
gt;
gt;
gt;