Lookup???

Good morning,

I need some help, please. I have general ledger entries (column headings
date, status (paid, current, past due), description, amount) on one worksheet
and an invoice template on another. What I am trying to do is write a
formula that will copy only those entries that have a status of "current"
over to the invoice. Unfortunately, I, and everyone else I have asked, am
stumped on how to move only those line items. Any suggestions would be
GREATLY appreciated!!

Thanks!

Hi
see:
http://www.rondebruin.nl/copy5.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"CaseysCache" schrieb im
Newsbeitrag ...
Good morning,

I need some help, please. I have general ledger entries (column
headings
date, status (paid, current, past due), description, amount) on one
worksheet
and an invoice template on another. What I am trying to do is write
a
formula that will copy only those entries that have a status of
"current"
over to the invoice. Unfortunately, I, and everyone else I have
asked, am
stumped on how to move only those line items. Any suggestions would
be
GREATLY appreciated!!

Thanks!