Excel Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Emailing select data from Excel automatically 1
Help needed 0
Plotting against Date (collating months) 1
Macro for checking data in a cell against another cell andcopying/pasting data 8
Excel Count from last specific text 3
Formula problem 3
Still not working 4
Has anybody done this? - Restructuring a row based list to column based 7

Back
Top