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
Bookmarks