Prev: Identifying a label.
Next: averaging a range
From: jpstormy on 4 May 2010 14:32
Can I copy a worksheet so that the new worksheet looks exactly like the
visible portion of the old worksheet. For example, if I filter and sort, I
only want what is left visible to appear in my new worksheet, and I want it
to do it automatically without my having to copy and paste.
From: Gord Dibben on 4 May 2010 15:07
Automatic means VBA code.

See Ron de Bruin's site for copying filtered results.

http://www.rondebruin.nl/copy5.htm


Gord Dibben MS Excel MVP

On Tue, 4 May 2010 11:32:01 -0700, jpstormy
<jpstormy(a)discussions.microsoft.com> wrote:

>Can I copy a worksheet so that the new worksheet looks exactly like the
>visible portion of the old worksheet. For example, if I filter and sort, I
>only want what is left visible to appear in my new worksheet, and I want it
>to do it automatically without my having to copy and paste.

From: jpstormy on 5 May 2010 09:36
Maybe I am making this too complicated. I have a grocery list that I put
what I need in Column A and then autofilter non-blank cells and sort by store
isle. I want this file to sync to my ipaq, but my ipaq uses pocket excel,
which does not support the autofilter. I thought if I could create a new
file that just showed what was visible in my other file, it could sync
without the autofilter. Is there an easier way to do this? Or does anyone
know how to make the autofilter sync to the pocket excel?

"Gord Dibben" wrote:

> Automatic means VBA code.
>
> See Ron de Bruin's site for copying filtered results.
>
> http://www.rondebruin.nl/copy5.htm
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 4 May 2010 11:32:01 -0700, jpstormy
> <jpstormy(a)discussions.microsoft.com> wrote:
>
> >Can I copy a worksheet so that the new worksheet looks exactly like the
> >visible portion of the old worksheet. For example, if I filter and sort, I
> >only want what is left visible to appear in my new worksheet, and I want it
> >to do it automatically without my having to copy and paste.
>
> .
From: jpstormy on 14 May 2010 11:13
Got it! Just undo the "convert" option on the ipaq. I did figure out how to
make it work the other way, but this was much simpler. Thanks for your time!

"jpstormy" wrote:

> Maybe I am making this too complicated. I have a grocery list that I put
> what I need in Column A and then autofilter non-blank cells and sort by store
> isle. I want this file to sync to my ipaq, but my ipaq uses pocket excel,
> which does not support the autofilter. I thought if I could create a new
> file that just showed what was visible in my other file, it could sync
> without the autofilter. Is there an easier way to do this? Or does anyone
> know how to make the autofilter sync to the pocket excel?
>
> "Gord Dibben" wrote:
>
> > Automatic means VBA code.
> >
> > See Ron de Bruin's site for copying filtered results.
> >
> > http://www.rondebruin.nl/copy5.htm
> >
> >
> > Gord Dibben MS Excel MVP
> >
> > On Tue, 4 May 2010 11:32:01 -0700, jpstormy
> > <jpstormy(a)discussions.microsoft.com> wrote:
> >
> > >Can I copy a worksheet so that the new worksheet looks exactly like the
> > >visible portion of the old worksheet. For example, if I filter and sort, I
> > >only want what is left visible to appear in my new worksheet, and I want it
> > >to do it automatically without my having to copy and paste.
> >
> > .
 | 
Pages: 1
Prev: Identifying a label.
Next: averaging a range