Ideally, I need to sort the data in TABLE A to 30 tables similar to TABLE B
TABLE B is for a sole Category eg Skin, Hair. Row 17 will indicate the price point (Numbers in columns B,D etc of TABLE A ) from TABLE B (B4), Row 18 the price point for Brand B (B5). The indication could be a 1...