So I am working on a project and the powers that be would like to be able to type one row of data into an excel sheet, we'll call it Main, and have any new lines appended to other sheets based on whether the field is empty, department specific. Originally I was grouping all the sheets together and had a macro hiding rows if the columns in question were empty, but all it ever really did was cause Excel to stop responding. The fields for the main sheet are Client, Project #, Dept A Tests, Dept B Tests, Dept C Tests, Dept D tests. Sometimes there will be tests in multiple departments, which is why they want a conditional rule to determine if the rows are copied.