Get rows from another tab where cell in column is empty

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ggaines - 13 Mar 2007 06:31 GMT

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

Reply to this Message

Gary''s Student - 13 Mar 2007 11:06 GMT

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

Signature

Gary's Student
gsnu200710

> 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
[quoted text clipped - 6 lines]
>
> gg

Reply to this Message

Jacob - 14 Mar 2007 16:03 GMT

On Mar 13, 5:06 am, Gary''s Student
<GarysStud...@discussions.microsoft.com> wrote:

> If you don't like AutoFilter, then a macro would be easy to construct.. In
> which column is the paid status recorded??
[quoted text clipped - 12 lines]
>
> > gg

You might try the DGET Function.

Reply to this Message