Excel Functions
 

I am stuck... I am trying to find the last date that a piece of equipment was
worked on and transfer that date to another summary worksheet. I want to
search through one column and if it equals a specific piece of equipment say
("Meter #1") I want to see the last time anything was entered in an adjacent
cell which would mean work was performed. Upon finding the last entry in a
column for ("Meter #1") I want to return the date in column 1 to another
sheet in the workbook and do this for meters #1 thru #10. I can do it just
fine for one piece of equipment but the multiple ones are giving me a
problem. Thanks

Excel Functions
 

do you have code written for it to do it the one time? or are you doing
it by hand? If you have code, then you can do a Do...While statement,
to repeat the process.


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=531105