Basically I need to be able to have a few tables for sales of specific categories e.g. pc and laptop. I also need to have a main table that displays all sales.

For input i'm using input boxes and a dropdown to select which category (pc or laptop), this input is then just put in to one large table along with the sale information. I'm just wondering what the best method for having this data put in to a separate worksheet just for that category is? I'm at a bit of a loose end where to start. I thought about possibly using an IF statement in the VB where if the input is e.g. PC then also insert into the worksheet PC but this seems like quite an inefficient way of doing this.

Your ideas are greatly appreciated.