?

Log in

No account? Create an account
 
 
David D. Levine
08 June 2012 @ 10:15 am
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)?