Hi all i need a vba which records date when criteria is meet or returns the word "pending" when the criteria is not meet
the criteria is when cells in column j to columns m are full return date confirmed otherwise return "pending"
i tried a formula in the cell but unfortunately every time you open the workbook it returns todays date as per the formula i guess =today()
any help would be greatly appreciated
Kind Regards
Steddas
Hi,
i tried editing your file but the worksheet was protected and it had its own macro triggered by movements in the worksheet. You may want to try this code:
this code will require that there are no blank rows under column "Confirmed", and that the worksheet maintains its name. If you need to change the worksheet name, you'll need to change the range in the code.
Please Login or Register to view this content.
Please let me know if you get into issues
don't worry, there's a lot of people that are far more confused than you
but if you liked what i suggested. Click for me the "Add Reputation" - that way, we'd be both happy.
Hi there thanks for your help the code is EGLK to unlock
i had some help from other users on the coding last week just forgot about the date it was confirmed always updating because its in a formula
See below:
The workbook with the macro inserted is attached.
The name of the macro is return_date
Please Login or Register to view this content.
Last edited by danny2000; 05-24-2018 at 12:20 PM.
If this has helped you please set this question to 'SOLVED'.
steddas, how is this thread any different from
https://www.excelforum.com/excel-pro...ml#post4904806
or from your other thread?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
sorry i was using 2 computers and didnt see the reply from danny 2000
also i wasnt aware of the 3 question forum rule sorry guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks