In column A-P I have a list of guests (w/info) who will be coming to tour our
property in a given week. The list changes every week, and often changes
from day to day. Next to the list I have a series of conditional formulas
that automatically sum how many guests we will have on any given day and
time. The list changes throughout the week. When we have to insert a new
guest, is there a way for the formulas to automatically drop down/copy to the
inserted row? I have the formulas hidden, and would prefer to be the only
person with access to them, but am often too busy to be copying formulas
daily. On the other hand, the most updated info needs to be given to our
sales and marketing teams. Please help...

Thanks!