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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,095,613
Messages
5,445,473
Members
405,334
Latest member
Marcfar

This Week's Hot Topics

Top