I need to format imported data so I can crunch the numbers

before:
Department Name: 01 Grocery FS Department Number: 1
Cashier Negative Report
All Voids $ 132.91 19 Item Corrects
Line Item Discount Report
10% Employee $ 1.17 4
2% Non Mbr Senior $ 3.97 47
20% Employee $ 299.07 502
20% Working Member $ 18.82 24
5% Senior Member Dis $ 134.86 696
Store Coupon $ 14.50 13
Item Discount Totals $ 472.39 1,286
Subtotal Discount Report
5% Bicycle Benefits $ 20.55 117
Subtotal Discount Totals $ 20.55 117
Sales Totals Report
Department Sales w/o Tax $ 40,939.79 Negative Total $ 674.48

Department Name: 02 Grocery Tax Department Number: 2
Cashier Negative Report
All Voids $ 0.15 1 Item Corrects
Line Item Discount Report
2% Non Mbr Senior $ 0.03 1
20% Employee $ 61.51 73
20% Working Member $ 5.78 9
5% Senior Member Dis $ 19.79 89
Item Discount Totals $ 87.11 172
Subtotal Discount Report
5% Bicycle Benefits $ 1.74 7
Subtotal Discount Totals $ 1.74 7
Sales Totals Report
Department Sales w/o Tax $ 5,798.93 Negative Total $ 321.47


After needs to take "negative Total" in column C and put it in column A in the empty row below "dept sales w/o tax", and the Negative Total amt goes to corresponding column B

After:

Department Name: 01 Grocery FS
Cashier Negative Report
All Voids $ 132.91
Line Item Discount Report
10% Employee $ 1.17
2% Non Mbr Senior $ 3.97
20% Employee $ 299.07
20% Working Member $ 18.82
5% Senior Member Dis $ 134.86
Store Coupon $ 14.50
Item Discount Totals $ 472.39
Subtotal Discount Report
5% Bicycle Benefits $ 20.55
Subtotal Discount Totals $ 20.55
Sales Totals Report
Department Sales w/o Tax $ 40,939.79
Negative Total $ 674.48
Department Name: 02 Grocery Tax
Cashier Negative Report
All Voids $ 0.15
Line Item Discount Report
2% Non Mbr Senior $ 0.03
20% Employee $ 61.51
20% Working Member $ 5.78
5% Senior Member Dis $ 19.79
Item Discount Totals $ 87.11
Subtotal Discount Report
5% Bicycle Benefits $ 1.74
Subtotal Discount Totals $ 1.74
Sales Totals Report
Department Sales w/o Tax $ 5,798.93
Negative Total $ 321.47

http://www.excelforum.com/excel-prog...24#post2909624

Hello julienaas, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.