Fill blank rows

[lwgross]

I need a code to add $0.00 to columns G & H

Problem
A B C D E F G H
1 42494 1004 10100 Cash on Hand Cash Prepaid for Randy $260.00
2 42498 1006 10100 Cash on Hand Cash 5/4/16-5/8/16 Fare Reciepts $370.00
3 42501 1011 10100 Cash on Hand Cash 5/9/16-5/10/16 Fare Reciepts $378.00
4 42504 1014 10100 Cash on Hand Cash 5/11/15 Fare Receipts $440.00
5 42505 1017 10100 Cash on Hand Cash 5/12/16 Fare Receipts $279.00
6 42508 1022 10100 Cash on Hand Cash Driver License Exam 5/13/15 $26.25
7 42508 1024 10100 Cash on Hand Cash Auto Part Lt Bulb 2002 $6.43
8 42509 1026 10100 Cash on Hand Cash Taxi Cab Safety Inspection $291.49
9 42511 1027 10100 Cash on Hand Cash Chad's Salary May $500.00
10 42512 1031 10100 Cash on Hand Cash Payment Visa $366.09
11 42513 1033 10100 Cash on Hand Cash 5/23/16 Fare Receipts $675.00
12 42515 1035 10100 Cash on Hand Cash Loan Payment Interest $400.00
13 42518 1037 10100 Cash on Hand Cash 5/24/16 Fare Receipts $126.00
14 42520 1038 10100 Cash on Hand Cash 5/30/16 Fare Receipts $330.00
15 42521 1040 10100 Cash on Hand Cash 5/31/16 Fare Receipts $602.00
$3,460.00 $1,590.26 $1,869.74
Result
A B C D E F G H
1 42494 1004 10100 Cash on Hand Cash Prepaid for Randy $260.00 $0.00
2 42498 1006 10100 Cash on Hand Cash 5/4/16-5/8/16 Fare Reciepts $370.00 $0.00
3 42501 1011 10100 Cash on Hand Cash 5/9/16-5/10/16 Fare Reciepts $378.00 $0.00
4 42504 1014 10100 Cash on Hand Cash 5/11/15 Fare Receipts $440.00 $0.00
5 42505 1017 10100 Cash on Hand Cash 5/12/16 Fare Receipts $279.00 $0.00
6 42508 1022 10100 Cash on Hand Cash Driver License Exam 5/13/15 $0.00 $26.25
7 42508 1024 10100 Cash on Hand Cash Auto Part Lt Bulb 2002 $0.00 $6.43
8 42509 1026 10100 Cash on Hand Cash Taxi Cab Safety Inspection $0.00 $291.49
9 42511 1027 10100 Cash on Hand Cash Chad's Salary May $0.00 $500.00
10 42512 1031 10100 Cash on Hand Cash Payment Visa $0.00 $366.09
11 42513 1033 10100 Cash on Hand Cash 5/23/16 Fare Receipts $675.00 $0.00
12 42515 1035 10100 Cash on Hand Cash Loan Payment Interest $0.00 $400.00
13 42518 1037 10100 Cash on Hand Cash 5/24/16 Fare Receipts $126.00 $0.00
14 42520 1038 10100 Cash on Hand Cash 5/30/16 Fare Receipts $330.00 $0.00
15 42521 1040 10100 Cash on Hand Cash 5/31/16 Fare Receipts $602.00 $0.00
$3,460.00 $1,590.26 $1,869.74

[kalbasiatka]

Show in the file your problem.

[lwgross]

I need a code to add $0.00 in the blank cells in columns G & H

Problem format
B C D E F G H
1 42494 1004 10100 Cash Prepaid for Randy $260.00
2 42498 1006 10100 Cash 5/4/16-5/8/16 Fare Reciepts $370.00
3 42501 1011 10100 Cash 5/9/16-5/10/16 Fare Reciepts $378.00
4 42504 1014 10100 Cash 5/11/15 Fare Receipts $440.00
5 42505 1017 10100 Cash 5/12/16 Fare Receipts $279.00
6 42508 1022 10100 Cash Driver License Exam 5/13/15 $26.25
7 42508 1024 10100 Cash Auto Part Lt Bulb 2002 $6.43
8 42509 1026 10100 Cash Taxi Cab Safety Inspection $291.49
9 42511 1027 10100 Cash Chad's Salary May $500.00
10 42512 1031 10100 Cash Payment Visa $366.09
11 42513 1033 10100 Cash 5/23/16 Fare Receipts $675.00
12 42515 1035 10100 Cash Loan Payment Interest $400.00
13 42518 1037 10100 Cash 5/24/16 Fare Receipts $126.00
14 42520 1038 10100 Cash 5/30/16 Fare Receipts $330.00
15 42521 1040 10100 Cash 5/31/16 Fare Receipts $602.00
$3,460.00 $1,590.26
This is the result I need
B C D E F G H
1 42494 1004 10100 Cash Prepaid for Randy $260.00 $0.00
2 42498 1006 10100 Cash 5/4/16-5/8/16 Fare Reciepts $370.00 $0.00
3 42501 1011 10100 Cash 5/9/16-5/10/16 Fare Reciepts $378.00 $0.00
4 42504 1014 10100 Cash 5/11/15 Fare Receipts $440.00 $0.00
5 42505 1017 10100 Cash 5/12/16 Fare Receipts $279.00 $0.00
6 42508 1022 10100 Cash Driver License Exam 5/13/15 $0.00 $26.25
7 42508 1024 10100 Cash Auto Part Lt Bulb 2002 $0.00 $6.43
8 42509 1026 10100 Cash Taxi Cab Safety Inspection $0.00 $291.49
9 42511 1027 10100 Cash Chad's Salary May $0.00 $500.00
10 42512 1031 10100 Cash Payment Visa $0.00 $366.09
11 42513 1033 10100 Cash 5/23/16 Fare Receipts $675.00 $0.00
12 42515 1035 10100 Cash Loan Payment Interest $0.00 $400.00
13 42518 1037 10100 Cash 5/24/16 Fare Receipts $126.00 $0.00
14 42520 1038 10100 Cash 5/30/16 Fare Receipts $330.00 $0.00
15 42521 1040 10100 Cash 5/31/16 Fare Receipts $602.00 $0.00
$3,460.00 $1,590.26
I hope this what you are asking for

Thanks

LG

[TheN]

They are asking you to attach a file, like this.

Edit your first post, go to advanced, then towards the bottom there is manage attachments. Add in your sample file.

I tried to clean up your data, but gav up when it wasn't easy to see what you wanted. So please upload a sample file.

[lwgross]

I need a code to add $0.00 in the blank cells in columns G & H

I hope I did it right

I don't see the attachment on the thread

Thanks

TheN

[xladept]

Hi lw,

Try this:

Please Login or Register  to view this content.

[xladept]

Hi lw,

You're welcome - thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.