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