I think this is the safest and most reliable way to copy data between sheets.
It preserves the formating and any links stay within the new worksheet
rather than pointing to the old worksheet.

"guest" wrote:

Thanks Joel for your answers. I wish there is a better way to do this.


"Joel" wrote:

Delete the row(s) above and the column(s) to the left of the first cell.

"guest" wrote:

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.