I have a master worksheet with data under different columns. I wish to
filter the master worksheet into various worksheets based on one criteria
e.g. by geographical location. The second thing I want to do is to have only
selected columns filtered into various worksheets. Is there a way to do this
easily in Excel? Thanks.

Wai Meng

Hi Waimeng

See
http://www.rondebruin.nl/copy5.htm

Or use my EasyFilter add-in
http://www.rondebruin.nl/easyfilter.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Waimeng" wrote in message ...
I have a master worksheet with data under different columns. I wish to
filter the master worksheet into various worksheets based on one criteria
e.g. by geographical location. The second thing I want to do is to have only
selected columns filtered into various worksheets. Is there a way to do this
easily in Excel? Thanks.

Wai Meng

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

=====
It may be easier to take all the data to each sheet, then go through those
sheets and delete the columns you don't want.

Manually, you could select the sheets (click on the first, and ctrl-click on
subsequent and then delete the columns you don't want.

When you're done, make sure you ungroup those sheets (rightclick on any of the
sheets and select Ungroup sheets).

Waimeng wrote:

I have a master worksheet with data under different columns. I wish to
filter the master worksheet into various worksheets based on one criteria
e.g. by geographical location. The second thing I want to do is to have only
selected columns filtered into various worksheets. Is there a way to do this
easily in Excel? Thanks.

Wai Meng

--

Dave Peterson