VBA add row to table based on cell value

[mchavarria92]

I have created several tables on an excel worksheet and I need help creating a VBA code that will move the rows into the table that they belong in when I add more data.

For example if I have a tables based on the color of notebooks and in the table it includes the price of the notebook and the date, I want the code to separate the newly added data to the corresponding table.

 

[Ray Huber]

How is the data being entered? Do you have one large table that everything goes into, or a userform or something?

-Ray

 

[mchavarria92]

How is the data being entered? Do you have one large table that everything goes into, or a userform or something?

-Ray

Yes it is all being entered into one table and being split into several tables on the same worksheet