Greetings:
A B C

Concert 1 $ 00.00
Concert 2 $ 00.00
Concert 3 $ 75.00 3333
Concert 4 $ 00.00
Concert 5 $ 25.00 5555
Concert 6 $ 00.00

I am working between two worksheets in the same workbook.

In one worksheet called €œreceipts entry worksheet€� I have 3 columns, the
first column is concert date, the second column is the total amount of
individual tickets sold and the third column is the charge authorization
number. I have to record the individual tickets sold per concert date on a
daily basis.

I can copy cell contents from one worksheet to another: ='Receipts Entry
WorkSheet'!E19 with no problem. I dont know how to write a formula if the
cell is empty. I think this is an IF type formula but I could be mistaken

I want to transfer the amount of individual tickets sold for each concert
AND the authorization number to another worksheet called €œCash and charge
summery€�. If there is no authorization number there is nothing to transfer.

So using the above example I would only transfer the amounts and
authorization numbers for concerts 3 and 5. This could and will change
everyday. Some days all the concerts have individual ticket sales and some
days only one concert would have a ticket sale and then again some days no
individual ticket are sold.

Question: If there a way to transfer amounts and authorization numbers to
another worksheet only if there is a charge authorization number?


--
David