VBA Database help

[wendtb]

Hey everyone,

I am currently working in excel and trying to create a database or a log of different values. This is a sample run to bring to my bosses before we approve really implementing something like this. Basically I have a table with a long list of condo's and there are three options, sold, under contract, and unsold. I want to be able to populate two fields in a different sheet each time the option changes from unsold or under contract to sold. Also, I want to be able to delete it if that changes from sold. Is this possible using VBA? If so, how would I go about implementing it?

Thanks everyone!

Brandon

 

[Beyond_avarice]

Have you considered using a Pivot table?

 

[wendtb]

Have you considered using a Pivot table?

I have tried using a pivot table. The issue is I when the unit changes to for sale I want the contract price and principal price to pull and then in the table use those values to automatically calculate distributions to respective parties. There is a chance I just do not know how to do this in a pivot table.