R
Radio848
Hello guys & gals:
Chip Pearson designed a calendar that is absolutely great. I tried using his
ideas to create a spreadsheet to keep track of hours worked.
Well, I flopped.
Question is: is there a function or vba code that will make cells absolute.?
i.e.. cell b10 to always reflect Sunday, c10 Monday, etc.
Cell c10 has date, c11 has day of week,
I can get it to work , but only a year at a time.
I need the workbook to update itself nearly automatically. Another thing.
For this workbook, the year starts Nov 5.
Hope I made that clear.
Thanks!
Employee Name: Starting Date:
11/05/2003
Department: HTS Time Ending Date:
11/08/2003
row 10: 11/02 11/03 11/04 11/05 11/06 11/07 11/08 Weekly
row 11: Sun Mon Tue Wed Thu Fri Sat
Totals
Thanks!
Chip Pearson designed a calendar that is absolutely great. I tried using his
ideas to create a spreadsheet to keep track of hours worked.
Well, I flopped.
Question is: is there a function or vba code that will make cells absolute.?
i.e.. cell b10 to always reflect Sunday, c10 Monday, etc.
Cell c10 has date, c11 has day of week,
I can get it to work , but only a year at a time.
I need the workbook to update itself nearly automatically. Another thing.
For this workbook, the year starts Nov 5.
Hope I made that clear.
Thanks!
Employee Name: Starting Date:
11/05/2003
Department: HTS Time Ending Date:
11/08/2003
row 10: 11/02 11/03 11/04 11/05 11/06 11/07 11/08 Weekly
row 11: Sun Mon Tue Wed Thu Fri Sat
Totals
Thanks!