Hmn! what if I need to copy to different cell location in the same sheet? My
situation is I need to copy the seleted data along with filters to a first
cell in the new sheet. Per Joel's answer I can move them to new sheet but how
can I copy it to the first cell in the new sheet? any ideas?


"Joel" wrote:

Maybe you want to start by compying the entire sheet then delete what you
don't want. Use the tab a the bottom of the worksheet (normally sheet1) and
right click. then slect move (copy). On the pop up window select Make a
Copy. Everythin on the orignal sheet will be copied including filters.

If you can't bring Mohammed to the mountain, bring the mountain to Mohammed!

"guest" wrote:

How do I copy a selected range along with existing filters to a new sheet?
Your help is appreaciated.

Thanks.