Excel Help.jpg
If I enter a Pump Number (016PC234B) in cell A9, I need the code to enter today's date in cell B9. Then it should lookup the last time this pump has failed (02-Feb-14) and enter it into cell C9. The last step is to calculate the time between the date in cell B9 and C9 and express it in terms of months. The calculation I use is [(B9-C9)/(365.25/12)]
Thanks for helping me on this
Welcome to the Forum. You'll find you will get a lot more responses if you provide a spreadsheet with the sample data versus a picture. Try:
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 09-17-2015 at 10:24 AM.
I tried the code but when I enter nothing happens. I also tried to attached the Excel spreadsheet but cannot find a way to do so.
Obviously I am doing something wrong
Review this Forum Rules link under You Want To Get Your Questions Answered Quickly for instructions on how to attach a workbook.
http://www.excelforum.com/forum-rule...rum-rules.html
Thanks for the advise. I have attached the workbook.
Alt + F8 to bring up the macro list, then run the macro named Brits.I tried the code but when I enter nothing happens.
You can also highlight the macro name and choose options and set a shortcut key to run the macro.
In your sample workbook P1613 is in cell A425, when I run the code I get today's date in B425 and February 27, 2014 in C425 as the previous failure date.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
This works perfectly thank you.
Would it be possible to do the same, but not using the macro. When you press enter after entering the tag number it executes the code?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks