formula for visible cells

J

jpstormy

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.
 
J

jpstormy

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?
 
J

jpstormy

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top