Hi Guys
I hope every one is good and staying safe, i need a few help around the to generation numbers and a auto date and time.
Option 1. i need formula
I created a drop down in column D5 with list on Vessel name and i need once the vessel is click, column C5 should Auto give date &Time Stamp and Column B5 Should generation a serial Number starting from 0001
My Second Option is a VBA Code that can do this as well and is it position if am using a VBA on my Excel and upload in one Drive can this still work out for me to share with my colleague.
Appreciate with any help for both Option.
I hope every one is good and staying safe, i need a few help around the to generation numbers and a auto date and time.
Option 1. i need formula
I created a drop down in column D5 with list on Vessel name and i need once the vessel is click, column C5 should Auto give date &Time Stamp and Column B5 Should generation a serial Number starting from 0001
My Second Option is a VBA Code that can do this as well and is it position if am using a VBA on my Excel and upload in one Drive can this still work out for me to share with my colleague.
Appreciate with any help for both Option.
Shipping Voyage and Vessel Cargo Information Log.xlsx | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
4 | Mus No's | Date &Time | Supply Vessels | Location/ Site Rig-move | ||
5 | ADNOC-221 | Asseifiya Island | ||||
6 | Al Ghallan Island | |||||
Voyage_Log |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
D5:D10949 | List | =Info!$B$3:$B$69 |
E5:E10949 | List | =Info!$D$3:$D$74 |