Hello -

Problem: Trying to use default dataform to add names to a table on Sheet "Personnel". Would like to add a row to all other sheets as soon as new entry is made and carry all formulas and formatting down from adjacent rows.

Background: The workbook is a team calendar. Sheet 1 is Personnel table, listing names and vacation time. Each month of the year has it's own sheet, i.e. January, February, etc. Each month has the same list of names in column A and each subsequent column represents indiviual days of the month. Some days have formulas to represent indivuals' scheduled time off. All days have conditional formatting based on the type of leave taken. I would like the conditional formatting to be carried to new rows as well.

Any help is appreciated.