software

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?--
JamStev
------------------------------------------------------------------------
JamStev's Profile: www.excelforum.com/member.php...oamp;userid=31619
View this thread: www.excelforum.com/showthread...hreadid=527103
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!'A2amp;quot; quot;amp;'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--
systemx
------------------------------------------------------------------------
systemx's Profile: www.excelforum.com/member.php...oamp;userid=29254
View this thread: www.excelforum.com/showthread...hreadid=527103
Im currently working on this, and it seems to be the right track! thanks
very much for your reply!!!--
JamStev
------------------------------------------------------------------------
JamStev's Profile: www.excelforum.com/member.php...oamp;userid=31619
View this thread: www.excelforum.com/showthread...hreadid=527103
Hi,

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

Now i was wondering......

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

I was wondering if there was a way to get around this so it does it
automatically? at the moment im thinking of creting a macro that will
goto the auto filter set it back to 'all' then do the custom filter to
get rid of the macros. this seems to work.--
JamStev
------------------------------------------------------------------------
JamStev's Profile: www.excelforum.com/member.php...oamp;userid=31619
View this thread: www.excelforum.com/showthread...hreadid=527103