I have a spreadsheet with series of totals that shows
weekly activities. 5 totals per rep for the week (each
day's total) and the Sixth total (the grand total is the
sixth total per reps). I am planning to use the sixth
total per reps to report their respective
Activities. However, if a rep. works OT it will report
its weekly with a 7th or 8th total (total per day work
plus OT days).
There is nothing that makes this OT work total unique
from the regular work week total, except that the regular
work week has lunches and breaks (this is on
Column C). I do not know if it is Possible to have a
macro that will compare the total range (from day 1 total
to grand total per reps. each days total on column A) vs.
Column C for lunches and breaks per reps . If there is
no break and lunch in column C for a given total THEN i
want the macro to Move that range to bottom of the sheet.
Leaving those reps. weekly to 6 totals. I really will
appreciate any help or direction.
Thanks in advance