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
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