Extracting Excel data into a separate file

May 5, 2009 at 10:35:53
Specs: Windows XP
I'm working in a large Excel workbook with multiple sheets. I want to take one range of data, call it "Data1", and extract it into a separate Excel workbook that only contains that data. And its going to have to be done many, many times so a macro will be necessary. The problem is I cannot figure out how to extract a chunk of data from a workbook into a separate workbook.

See More: Extracting Excel data into a separate file

Report •

May 5, 2009 at 11:34:03
This site has downloadable examples of how to extract data from a closed workbook, including using named ranges.


Report •
Related Solutions

Ask Question