MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need advise please

Posted by Jimmy on August 21, 2001 12:12 PM

I want to delevop a spreadsheet in which I can track property(stolen and recovered). What I would like is to have three sheets one for stolen property, one for found and one for recovered stolen property. On the found and recovered sheet I would like for it to be able to automatically go to the stolen property sheet and check to see if that property has been entered. It can check by serial number, brand, model and then create another sheet and copy and paste the matches if any to it. On the found and recovered sheet I would also like for it to be able to highlight (in some color) the row in which 90 days has passed since it report date. The fields for for the sheets would be something like this:

Case # | Report Date | Brand | Model | Serial # | Description

The fields would be the same on all sheets. If some one could point me in the right direction, it would be greatly appreciated. I have some knowledge of Excel and have played some with VBA, but mostly very limited. If I am going in the totally wrong direction on this I would appreciate knowing that also.

Thanks In Advance

Posted by Eric on August 21, 2001 12:58 PM

one idea

I would start with a central list of all property on one sheet, and add extra columns to describe whether the property is stolen, found, or stolen and recovered. You could then filter or sort the data as needed for your different interpretations.