I'm looking for the simplest possible code to conditionally add certain rows of data form one sheet to another sheet. I can't use macros because I'm making a Google doc.
In the workbook I have eight sheets that are lists of vendors and their costs. I'd like certain rows in each sheet to automatically copy to a master list in a ninth worksheet depending on if a certain cell in that row is blank or not.
I'm fairly new to excel, so... this question might not even make sense.
Help.