So ... what is the question?
You enter a "P", and nothing is carried over to the Invoice sheet.
Isn't that what you want?

You don't want to re-invoice an already paid bill ... do you?

I'm missing what you're asking!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"stub1toe" wrote in
message ...

On my invoice page, i want it to check sheet1(info!) col H for a letter
"I" and if there is one i want it to fill in space 1 on
sheet2(invoice!) with info from col D

ie
A B C D
E F
12/3/2005, 8hours, Brighton, dropped off supplies,wages a, wages b,

G H
invoice no, "I"

it checks for an "I" in col H and fills in "Brighton" on sheet2

but:
12/3/2005, 8hours, Brighton, dropped off supplies,wages a, wages b,
invoice no. "P"

puts nothing on sheet2 because theres a "P" not an "I"

a copy of the spreadsheet is here at my web space:


http://homepage.ntlworld.com/family..../GunnBooks.xls


--
stub1toe
------------------------------------------------------------------------
stub1toe's Profile:
http://www.excelforum.com/member.php...o&userid=34425
View this thread: http://www.excelforum.com/showthread...hreadid=541930