Hi,

I need a macro that will take the nonblank, nonzero rows out of a list and copy/paste them to another location, basically like the advanced filter option except that it automatically updates when data is changed and doesn't also copy row headers, etc. Essentially I need to take a 200-ish row table which updates often but in which no more than 20-25 rows are ever non-blank and edit it such that when I put new data into the table, all the useful (i.e. nonblank) data is immediately copied over to a smaller, 20-ish row table for easy, concise display.

Thanks so much
SJB