Delete Blank Row & Put Total
 

I export data from other accounting package. where data come like
Date, BillNo., BillAmount, Code, OS Amt
31-Mar-05 1434 13,206.00 a12 13,206.00
31-May-05 BOM001460506 324,340.64 v45 25,750.64
15-Jun-05 BOM002530506 79,079.52 f67 79,079.52
30-Nov-05 BOM010820506 22.04 22.04
- -
- -
- -
- -
- -
- -
- -
100003 - Corp. Bank - -
15-Jun-05 BOM002280506 1,388.52 b678 1,388.52
- -
- -
- -
- -
- -
- -
100107 - ICICI Bank - - -
15-Feb-05 MAA0017505 66,340.40 m78 12,516.00
31-Mar-06 MAA002940506 119,924.05 mk80 6,593.65
15-Apr-06 MAA000050607N 87,637.65 d45 2,424.65

Is there any way can i put total below BillAmount & osamt and than delete
all blank rows.

Any Help Thanks in advance.

Delete Blank Row & Put Total
 

Hi ****al

The quick and dirty way is to sort by colum A which will put all your
blank rows at the top. It's then easy to delete and add totals.

The complex way would be using a for each loop to look at each cell
before deleting rows.

Kind Regards
Dave

****al shah wrote:
I export data from other accounting package. where data come like
Date, BillNo., BillAmount, Code, OS Amt
31-Mar-05 1434 13,206.00 a12 13,206.00
31-May-05 BOM001460506 324,340.64 v45 25,750.64
15-Jun-05 BOM002530506 79,079.52 f67 79,079.52
30-Nov-05 BOM010820506 22.04 22.04
- -
- -
- -
- -
- -
- -
- -
100003 - Corp. Bank - -
15-Jun-05 BOM002280506 1,388.52 b678 1,388.52
- -
- -
- -
- -
- -
- -
100107 - ICICI Bank - - -
15-Feb-05 MAA0017505 66,340.40 m78 12,516.00
31-Mar-06 MAA002940506 119,924.05 mk80 6,593.65
15-Apr-06 MAA000050607N 87,637.65 d45 2,424.65

Is there any way can i put total below BillAmount & osamt and than delete
all blank rows.

Any Help Thanks in advance.