Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export ranges
How do I export or copy a long list of ranges to another workbook
oldjay |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export ranges
See if any of this helps -
http://www.microsoft.com/office/comm...9-233d83647308 If not, explain in a little more detail: how do you want to do the export/copy? Simple copy and paste may be all you need. Or copy and Paste Special w/Values chosen. "Oldjay" wrote: How do I export or copy a long list of ranges to another workbook oldjay |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export ranges
copy the addresses associated with each range into cells in a single column.
Then copy the cells to the other workbook. -- Gary''s Student - gsnu200736 "Oldjay" wrote: How do I export or copy a long list of ranges to another workbook oldjay |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export ranges
I should have said defined ranges. The ones you see when you pull down the
name box "Oldjay" wrote: How do I export or copy a long list of ranges to another workbook oldjay |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export ranges
Click on a named range in the list and immediately Excel will go to that
range and select it all. You can then do Copy and Paste easily. Does that solve the problem? "Oldjay" wrote: I should have said defined ranges. The ones you see when you pull down the name box "Oldjay" wrote: How do I export or copy a long list of ranges to another workbook oldjay |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export ranges
Thanks I was wishing their was a quick way
"JLatham" wrote: Click on a named range in the list and immediately Excel will go to that range and select it all. You can then do Copy and Paste easily. Does that solve the problem? "Oldjay" wrote: I should have said defined ranges. The ones you see when you pull down the name box "Oldjay" wrote: How do I export or copy a long list of ranges to another workbook oldjay |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export ranges
You're welcome, as always.
"Oldjay" wrote: Thanks I was wishing their was a quick way "JLatham" wrote: Click on a named range in the list and immediately Excel will go to that range and select it all. You can then do Copy and Paste easily. Does that solve the problem? "Oldjay" wrote: I should have said defined ranges. The ones you see when you pull down the name box "Oldjay" wrote: How do I export or copy a long list of ranges to another workbook oldjay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export as csv | Setting up and Configuration of Excel | |||
CSV export help | Excel Discussion (Misc queries) | |||
Export XML | Excel Discussion (Misc queries) | |||
how do I name ranges of data in Excel to export to Outlook? | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) |