B
Bill L.
I need help with 2 worksheets.
first sheet is a time schedule sheet. I need to count the total number of
shifts entered in a week
The sheet is set up so columns are days of weeks, each person has 2 rows,
top row is the start time bottom row is end time, time is entered is in 24Hr
format and shifts start at various times of days.
Second I have a row of numbers 1 to 20 that is averaged in row 21 in column
A. Row 1 has the most current figure, row 20 is oldest, Can I set it up so I
can enter the most current number in row 1 column A and all the existing
figures automatically bump down 1 row? example what was in row 1 would jump
to row 2 , row 2 go to row 3 and so on. row 19 would go in to row 20 and
what was in row 20 would be deleted?
first sheet is a time schedule sheet. I need to count the total number of
shifts entered in a week
The sheet is set up so columns are days of weeks, each person has 2 rows,
top row is the start time bottom row is end time, time is entered is in 24Hr
format and shifts start at various times of days.
Second I have a row of numbers 1 to 20 that is averaged in row 21 in column
A. Row 1 has the most current figure, row 20 is oldest, Can I set it up so I
can enter the most current number in row 1 column A and all the existing
figures automatically bump down 1 row? example what was in row 1 would jump
to row 2 , row 2 go to row 3 and so on. row 19 would go in to row 20 and
what was in row 20 would be deleted?