Rolling Over Data , Deleting Unwanted Rows

[TheBuGz]

Book1
	A	B	C	D	E	F	G	H
1	Sr	Date	OrderNo	PartyName	Station	Trucks	Despatched	Remaining
2	1	1/1/2004	1235	A	S	2	1	1
3	2	1/5/2004	1236	B	T	1	0	1
4	3	1/15/2004	1237	C	U	3	3	0
5	4	1/15/2004	1238	D	V	1	0	1
6	.	.	.	.	.	.	.	.
7	.	.	.	.	.	.	.	.
8	.	.	.	.	.	.	.	.
9	199	1/2/2004	1500	E	X	4	1	3
10	200	1/2/2004	1501	F	Y	1	1	0
11	201	2/2/2004	1502	G	Z	2	1	1
Sheet1

This data is in sheet 1 which keeps on growing day by day


Say in a month there may be around 1000 records.


If the balane is zero that line should be deleted in sheet 2 and the serial and the other record is updated

following is the image of the shhet I want to be shown in sheet 2


This is my first post in the Forum. Plz help me

Book1
	A	B	C	D	E	F	G	H
1	Sr	Date	OrderNo	PartyName	Station	Trucks	Despatched	Remaining
2	1	1/1/2004	1235	A	S	2	1	1
3	2	1/5/2004	1236	B	T	1	0	1
4	3	1/15/2004	1238	D	V	1	0	1
5	.	.	.	.	.	.	.	.
6	.	.	.	.	.	.	.	.
7	.	.	.	.	.	.	.	.
8	199	1/2/2004	1500	E	X	4	1	3
9	200	2/2/2004	1502	G	Z	2	1	1
Sheet2

 

[TheBuGz]

MY problem not solved Plz help.
Can this be done with the help of the formula instead of the macro .
I want that original data to remain the same in the sheet 1
The unwanted rows deleted and Serial numbers adjusted copied in sheet 2
I think I am not able to make u people understand my problem.

Can i do it with MS Acess like all the data goes in Acess and an updated one is in Excel or anything i have to manually delete around the trucks despatched manually while adding 30 new arders daily and i have no Record if someone asks me some orders do get cancelled too which i like to add an extra column mentioning that they were cancelled. I feel like ashamed that i cannot expresee wat i want to say May be still anyone here could know wat i am trying to say


Anxiously awaiting any good news from my friends in this forum as a friend of mine told me u can get almost anything out of Excel if u Contact MrExcel

Regards

 

[tactps]

Without a macro, the best way is to use autofilter on Sheet 1, as follows:

Highlight the columns that you want to filter (A through H)
From the "Data" Menu, choose "Auto Filter"
This will put arrows in row 1.

Click on the arrow in column H, and choose "Custom".
Change the criteria to "not equal to" and type 0 in the box.
This will hide rows containing zero.
Copy and paste onto sheet 2, and renumber column A.

Is this what you want?

Regards