Copy Data only if the cell has a value
How do I do all that?
--
David
"BriSwy" wrote:
In addition to the last solution, you could embed that AutoFilter into a
macro. Additionally, the macro would also include a select all/copy/paste
into the second sheet, then after the paste was completed, turn off the
AutoFilter. Lastly, you could then create a button on the sheet you were
working in and hitting it as much as you want wouldn't hurt anything.
Hope this was useful.
"David" wrote:
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
|