Get rows from another tab where cell in column is empty

G

ggaines

I have a spreadsheet where I track amounts owed to subcontractors and
when they were paid. I'm trying to create another tab where I pull
all rows that have not been paid. The only thing anyone has suggested
so far is autofilter but that isn't what I'm looking for. Is there a
function for this or would it have to be a macro? I don't really want
to do a macro. I might just build this in Access, but I thought I'd
try this angle first since it's already set up in Excel. I really
appreciate any help that could be provided.

gg
 
G

Gary''s Student

If you don't like AutoFilter, then a macro would be easy to construct.. In
which column is the paid status recorded??
 
Top