Export to sub tables by category.

[avraham711]

Hi,

I have main table with products, and there is a column of category among other 6 columns.

I am trying to make sheet with the same columns for every category (with all products with this category) so that the sheets are steel connected to the main sheet (both side connected to each other),
if I change the price for example in the main sheet the price should change in the specific sheet related to this product and the opposite direction is allowed.

Thanks

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.