Highlighing values on todays date

[JamStev]

Hi im pretty new to this forum, tho dabbled in a bit of excel before.

Basically i have the following

FName SName Install Date
aaa bbb 12/02/06
abb bcc 12/02/06
acc bdd 14/02/06
add bee 15/02/06
aee bff 15/02/06
aff bgg 18/02/06
agg bzz 12/02/06
etc

What i wanted todo was, if todays date was 12/02/06 then on another
sheet the the first and last name would be listed.

I know this could probably be quite easliy done with a macro , but
could this be automated or done with a count feature?

 

[systemx]

Hi JamStev,

I usually have an abstract way of looking at things....so this can
probably be done in an easier way.

Lets assume your worksheets are 'Sheet1' and 'Sheet2'.

Your data is contained in columns A:C

On 'Sheet2' in cell A1 I used the function '=TODAY()'. So this cell
will always contain the current date.

In cell A3 I has the following -

=IF(A1='Sheet1!'C2,'Sheet1!'A2&" "&'Sheet1!'B2,0)

This also concantenates the first name and surname into the one cell.
You could split the formula up over two cells.

I'm assuming this a list you want to look at each day for some type of
reporting purpose - so when the clock ticks over - the previous days
list is also lost.

Just use a filter to get rid of the zero's so you have a list you can
review.

Hope this helps.

Cheers

Rob

 

[JamStev]

Im currently working on this, and it seems to be the right track! thanks
very much for your reply!!!

 

[JamStev]

Hi,

The code works fine! will be a bit of a pain if/when i have to add ne
users to the list but i cant grumble, it does exactly what i need! t
again.

Now i was wondering......

At the moment ive have auto filtered out the 0's (by using custom an
then show values that do not equal 0) this works fine but if i the
save the document and come back the next day the list doesn't up dat
its self. its just blank.

I was wondering if there was a way to get around this so it does i
automatically? at the moment im thinking of creting a macro that wil
goto the auto filter set it back to 'all' then do the custom filter t
get rid of the macros. this seems to work