Best to keep to your original thread you posted in the other news group.

Posting an identical question just fragments your replies and wastes the
time and effort of those who are replying.

See one reply at your other post................you will need VBA to do it
automatically.


Gord Dibben MS Excel MVP

On Tue, 8 Dec 2009 07:34:03 -0800, Brian Ness
wrote:

I am using Excel 2007. On sheet one I have a database of text and numerical
data in which I am using filters to narrow down. What I want to be able to do
is to transfer only the shown data (that is filtered) on sheet 1 to another
sheet automatically. The reason for this is that some of the info of the
filtered data needs to be put into a different format on sheet 2. Is there a
way to do this?
Thanks for any help.