Using a formula, I need to copy a table to a table omitting rows that meet
certain criteria (like no sales). This needs to be an 'automated' task since
I have some many.

I have worksheets for each of 50 states that list each county/parish, sales,
tax, tax rates. In another section of each of those worksheets I need to
list only those counties/parishes with sales and the resulting table should
include sales, tax, & tax rate.

Can this be done?

Thanks for your help in advance.