Split Table into two tables in other sheet based on a column value

[vikrampnz]

Hello

I have a Master table with 250 Unit numbers and their parameters (approx. 6 columns). One of the columns is "SOLD" / "UNSOLD" which I select from drop down.

I am trying to figure out a way to automatically split "SOLD" table and "UNSOLD" table dynamically i.e. as soon I change the status of a unit from Unsold to Sold in my Master table, it should display that row in the SOLD Table (sorted Alphabetically) and disappear from the UNSOLD table.

I am using Excel 2007 and wondering if this is possible to achieve ?

Would appreciate any help !!

Thanks