software

Hi All,
I hope someone can help me with this.

How can I reproduce list data with filtering on various other sheets in
my workbook.

I have a master price list done as a LIST. This includes, BRAND, MODEL,
NAME, PRICE, CATEGORY etc

I wish to display this list data on other pages, BUT need to filter it
and split it up.
For example on sheet 2 it must display as follows

MODEL, NAME, PRICE - ** but only from BRAND X and CATEGORY Y **
then a heading.. then
MODEL, NAME, PRICE - ** but only from BRAND X and CATEGORY Z **

then a few line lower on same sheet

MODEL, NAME, PRICE - ** but only from BRAND Q and CATEGORY R **

this is easy enough if I just link the cells, but when new data is
added to the main list I need all the new data to be included in each
of the sections as above, so new rows must be added and the page must
adjust automically.

There is more that I need to do, but with the information on how to
achieve the above I should be able to sort the rest.

I hope someone can help me with a data get or filter solution to make
this work well.

thanks in advance.

Bill--
quag2000
------------------------------------------------------------------------
quag2000's Profile: www.excelforum.com/member.php...oamp;userid=34363
View this thread: www.excelforum.com/showthread...hreadid=541402You could use programming, and advanced filters, to update the lists on
the second sheet. Create criteria ranges on a hidden sheet, to specify
what you need in each section.

There are Advanced Filter instructions here that may help you get started:

www.contextures.com/xladvfilter01.html

Record a macro as you perform the steps, then modify the recorded code
as required.

quag2000 wrote:
gt; Hi All,
gt; I hope someone can help me with this.
gt;
gt; How can I reproduce list data with filtering on various other sheets in
gt; my workbook.
gt;
gt; I have a master price list done as a LIST. This includes, BRAND, MODEL,
gt; NAME, PRICE, CATEGORY etc
gt;
gt; I wish to display this list data on other pages, BUT need to filter it
gt; and split it up.
gt; For example on sheet 2 it must display as follows
gt;
gt; MODEL, NAME, PRICE - ** but only from BRAND X and CATEGORY Y **
gt; then a heading.. then
gt; MODEL, NAME, PRICE - ** but only from BRAND X and CATEGORY Z **
gt;
gt; then a few line lower on same sheet
gt;
gt; MODEL, NAME, PRICE - ** but only from BRAND Q and CATEGORY R **
gt;
gt; this is easy enough if I just link the cells, but when new data is
gt; added to the main list I need all the new data to be included in each
gt; of the sections as above, so new rows must be added and the page must
gt; adjust automically.
gt;
gt; There is more that I need to do, but with the information on how to
gt; achieve the above I should be able to sort the rest.
gt;
gt; I hope someone can help me with a data get or filter solution to make
gt; this work well.
gt;
gt; thanks in advance.
gt;
gt; Bill
gt;
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html