Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected range along with filters
How do I copy a selected range along with existing filters to a new sheet?
Your help is appreaciated. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected range along with filters
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected range along with filters
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected range along with filters
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected range along with filters
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected range along with filters
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Selected Range to new sheet | Excel Programming | |||
Copy a selected Range to a Workbook | Excel Programming | |||
Sum selected Range and copy to clip board | Excel Programming | |||
How do I edit a selected range then copy the range into an new sheet??? | Excel Programming | |||
Nameing a range while still selected from copy | Excel Programming |