G
Guest
How do I export or copy a long list of ranges to another workbook
oldjay
oldjay
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
See if any of this helps -
http://www.microsoft.com/office/com...misc&mid=1ba03b5f-e6b6-465c-8f99-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.
http://www.microsoft.com/office/com...misc&mid=1ba03b5f-e6b6-465c-8f99-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.
G
Guest
copy the addresses associated with each range into cells in a single column.
Then copy the cells to the other workbook.
Then copy the cells to the other workbook.
G
Guest
I should have said defined ranges. The ones you see when you pull down the
name box
name box
G
Guest
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?
range and select it all. You can then do Copy and Paste easily.
Does that solve the problem?
G
Guest
Thanks I was wishing their was a quick way
JLatham said: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?
G
Guest
You're welcome, as always.
Oldjay said:Thanks I was wishing their was a quick way