sorry...(You can see now why i failed my o'level english....)
This is what i want..

when i put a tag or letter "I" in a column H, i want the corresponding
information in column C to be transfered into a different cell on a
different sheet.

I want to be able to select the info that gets sent to my invoice sheet
by putting a "I" in that row.

I enter day by day the work i have done, on a Friday i enter "I" next
to the information of Monday to Fridays work.

When it generates my invoice, it seems happy to sum all hours up from
anyline containing an "I".

but i need a command like = if on info! (H2 to H100="I" then Invoice!
A2 to A8 = info! C2 to C100)

I print out my invoice sheet and give to the company. It prints out
total hours worked from any row that has an "I" next to it, but i cant
get it to pull the info from a different colomn and print it on the
invoice if theres an "I"

I think im making this sound really complicated..

(If you have a spreadsheet and you only want to print out bits of it,
if theres an "I" next to it print out whats in row c if not leave
blank)

I think i'm a moron...
I sure the answer to this is simple...Its just the question thats
hard....


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