June 8th, 2012

motherfucking soufflé is ruined

Excel question

I have exactly one Excel macro that I use on a daily basis. It's in my writing tracking spreadsheet and it summarizes the current status of all my submissions. Each story is tracked on its own worksheet (tab) with one row per submission; the macro copies all rows with a non-empty status (column C) from every other sheet to the summary sheet, like this:

Excel

Is there any way to do this without a macro?

Bonus question: Can you tell me how to do this in Numbers (Apple's iWork spreadsheet)?