You are soooooooooooooooooooooooo better off designing an MS Access database!

:-)

"Benjamin M" wrote:

I'm using Excel 2003. I can create columns, rows, data, new worksheets, etc.,
so I have a very basic knowledge of using Excel.

With that said, here is what I'm trying to accomplish:


First of all, I'm the manager of several apartment complexes. We have
seperate worksheets for each complex. Each worksheet contains unit #, move-in
date, lease expiration, etc. Just general information. There are also columns
we mark 'R' for when we have requested that trash, paint, maintenance,
cleaning and carpet cleaning be performed. We then update the 'R' to 'X' when
they are completed.

What I'd like to do is create a new worksheet titled Maintenance and have
sections for Cleaning, Carpet Cleaning, etc. Each section would reflect the
units that need to be cleaned, for example, and also display the move-in
date. So if they are organized by move-in date, then we'll know which ones
are top priority, etc. The same needs to be done for carpet cleaning, etc.

So for each section (Cleaning, Carpet cleaning, etc), I'll need it to first
lookup the move-in dates. Then display the move-in date and the Unit number.
Also, a column that looks up whether the task (cleaning, carpet cleaning) has
been requested.


I know this is a complex question (or at least it is to me), but how would I
display that data?


Also, I've done a little bit of research online to find some Excel 2003
tutorials but I can't find any intermediate ones, per se. I can find very
basic ones and pretty advanced ones but none that seem to explain what the
LOOKUP function is used for, etc. Are there any sites you can suggest?


Thanks,
Ben