excel tagging specific dates 2

[crows27]

I was wondering if i can setup an excel spreadsheet to keep track of files (legal documents) removed from the file cabinet. I want to have the dates the file is removed and the date due....then have excel tag the entry if the file hasn't been returned. is this possible ? or what would you recommend?

thanks

 

[Dreamboat]

You may want to add a new column that has text formatted as bold RED, then put this formula in it:

=IF(CELL2>(CELL1+14),"OVERDUE","&quot

Cell2 contains the due date
Cell1 contains the sign-out date
14 = the number of days they're allowed to have it out

Otherwise, a conditional formatting formula could be tough to figure out, but maybe someone here has what it takes to create it.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[crows27]

thanks dreamboat....

 

[DaleWatson123321]

Hi crows27,

I've taken up the challenge, and created a working model with "VBA-code-driven-buttons" to extract "Outstanding" documents based on a "user-specified" number of days, along with other "sorting" options.

The file works now, but is "not quite complete". I should have it completed shortly - perhaps by tomorrow.

I wanted to advise you now, though, so that you can "put a hold" on your efforts to search for and/or create your own working model.

Also, in order for me to email you the file, I'll need your email address. You can email me at the following address, and I'll send the file by return email.

I can send the file right now, so that you can gain an appreciation for how it functions, but understand that it is not yet "complete".

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[DaleWatson123321]

Update... This "custom" file is NOW COMPLETE.

It is automated with "Sort Buttons" and "Extract Buttons".

It allows the user to specify the Number of Days after which records are considered "Outstanding". With the click of a button, these records are extracted to a separate sheet and automatically formatted for printing. ...i.e. the user only has to click the Excel "Print" icon (or the "Preview" icon).

It allows the user to extract all "Taken / Not Returned" records - i.e. all "missing" records, whether or not they are beyond the specified "Outstanding Period".

If ANYONE would like a copy of this, simply email me and I'll send a copy via return email.

The file is called: "Library Document Control Log.xls"

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[DaleWatson123321]

Further UPDATE... Due to a request, I have now FULLY DOCUMENTED this file (comments WITHIN the VBA code).

This will therefore now serve as BOTH a working file, and ALSO an example for Tek-Tips users who are NEW to VBA.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[DaleWatson123321]

Update, and a Message to "crows27".

Two Tek-Tips users have emailed me for this "custom" file I created and offered, and have responed with "gratitude" for receiving the file. They say it is EXACTLY what they were looking for. And, in one case, the point was made that this file will serve as an EXCELLENT example of how to set up similar applications using the "DATABASE functionality" of Excel. As well, one said he really appreciated the VBA code WITH the detailed documentation. As mentioned, this code is FULLY documented, and will therefore be of significant benefit to users relatively new to Visual Basic.

"crows27" ... Because you were the one for whom I created this "custom" file and you have'nt yet asked for a copy of the file, I'm wondering if you have resolved the task with another method, or perhaps you've just missed seeing the updates to this posting ? ? ? Please advise.

Again, for ANYONE ELSE who might want a copy of this file, simply email me, and I'll send you a copy via return email.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca