Hello Again!
I am linking B2 "Employee #" to B4 "Employee Name" with =IF(B2=11,"Ed",IF(B2=230,"Scott")) but only up to 7 times. I need to use up to 30+- #'s per worksheet.
Next I would like to have date in C4 written as: 3/22/02 auto fill 1 weeks days in D4 - D10 as Month/Day i.e. 3/22~3/23~324~3/25~3/26~3/27~3/28
I am using MSOffice97,Excel
Thanks,
Scott, aka"230"
I am linking B2 "Employee #" to B4 "Employee Name" with =IF(B2=11,"Ed",IF(B2=230,"Scott")) but only up to 7 times. I need to use up to 30+- #'s per worksheet.
Next I would like to have date in C4 written as: 3/22/02 auto fill 1 weeks days in D4 - D10 as Month/Day i.e. 3/22~3/23~324~3/25~3/26~3/27~3/28
I am using MSOffice97,Excel
Thanks,
Scott, aka"230"