Appending Data in Excel

NotGreatAtExcel

New Member
Joined
Apr 23, 2019
Messages
1
Hey,

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.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,096,363
Messages
5,449,986
Members
405,581
Latest member
caliope1990

This Week's Hot Topics

Top