Extracting source data that I want

I wanted to know whether it is possible to extract certain information from one excel worksheet to another excel worksheet. I only want certain columns and I can't figure out how to get them. For instance, there is a column that represents the regions (denoted by r) of the United States. There are 9 values that r can take on (Census Divisions). I want to extract all the data that I need from each of these regions and put them into separate worksheets.

That is, I'd like to have one .xls file with 10 sheets (Source Data and then the regional data all extracted from the source data).

I'm using Excel 97... I'd like to upgrade but it seems that there are protections on this computer. I've considered treating the source data as a separate .xls file. I was trying to figure out how I can retrieve the information I wanted if I imported data and it seems that I need a query. I tried this method, but I don't have Microsoft Query installed.

Anyways, I'd appreciate any help on this.

I like to keep all my data in one spot, but...

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Chris435435 wrote:
>
> I wanted to know whether it is possible to extract certain information
> from one excel worksheet to another excel worksheet. I only want
> certain columns and I can't figure out how to get them. For instance,
> there is a column that represents the regions (denoted by r) of the
> United States. There are 9 values that r can take on (Census
> Divisions). I want to extract all the data that I need from each of
> these regions and put them into separate worksheets.
>
> That is, I'd like to have one .xls file with 10 sheets (Source Data and
> then the regional data all extracted from the source data).
>
> I'm using Excel 97... I'd like to upgrade but it seems that there are
> protections on this computer. I've considered treating the source data
> as a separate .xls file. I was trying to figure out how I can retrieve
> the information I wanted if I imported data and it seems that I need a
> query. I tried this method, but I don't have Microsoft Query
> installed.
>
> Anyways, I'd appreciate any help on this.
>
> --
> Chris435435
> ------------------------------------------------------------------------
> Chris435435's Profile: http://www.excelforum.com/member.php...o&userid=35906
> View this thread: http://www.excelforum.com/showthread...hreadid=556969

--

Dave Peterson

Thanks for your response Dave...

I forgot to mention one detail though. Every year, the source data will be updated. My objective is to design my spreadsheets so that I can just replace the source file and all the regional data is automatically updated. The linking is the easy part, its just extracting the information that is difficult for me.

I replied while glazing over some of the references you gave me. So, I haven't looked at everything yet.

I just thought I'd mention this just in case you had other references to give me. Thanks.