Hello, i'm a new member with just really basic knowledge about excel, and in the search of a few formulas to get these 2 worksheet working, hopefully you guys can help me out to finish them up, any advice will be appreciate it!!! thank you!
In the first one "DRUM OPERATOR SAFETY" there are only 2 active tabs: 1.- 980 SAFETY CHECK LIST, 2.-SAFETY TOPICS; In tab #1 i have daily date in tab A7 and safety topic in B7; in tab #2 i have my safety topics that go by date. I'd like to have tab 1 and 2 linked up, if there's any formula to update date in tab #1 cell: A7 automatically in a dialy basis in this format: MM/DD/YEAR, and once updates date, i'd like to link date to the safety topics in tab #2, date runs from B3 to B300, and proper Safety Topic for each day runs from C3 to C300, my ending goal would be once date automatically updates in Tab #1 cell A7, will find safety topic within Tab #2 matching the date. DRUM OPERATORS SAFETY (version 1).xls
In the second one "DRUM SCHEDULE", it's a workbook of 7 tabs that represent the 7 days of the week Monday to Sunday; on this one i created a custom list representing 31 days of the month (1,2,3,4,5,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z), i have been looking for a formula without success. What i would like to have is a formula in "Monday" tab cell D9 that once i put in my Custom list character in it, will take an increment effect on the remaining tabs in consecutive order mon, tue,wed,thu,fri,sat and sun; so if i type in "W" in D9 Monday's Tab, Tuesday D9 must be "X", wed D9 ="Y", thu D9 = "Z" and start custom list all over again fri D9 = "1" sat D9 = "2" , sun D9 = "3".DRUM SCHEDULE.xls
Any help will be greatly appreciate it!! thank you guy for this excellent website!!
Regards Yeritson.
Bookmarks