Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running total in blank cells | Excel Worksheet Functions | |||
Insert Blank Row Below Sub-Total? | Excel Worksheet Functions | |||
make cell show blank when total is zero | Excel Discussion (Misc queries) | |||
Delete blank row only if 2 consecutive blank rows | Excel Programming | |||
Using the sum function with a blank total | Excel Programming |