How to remove special duplicate?

[MacFil]

Hi all. I'm new to Excel. I mostly work with Access. I made a search but could not find what I was looking for. I have a report in Access that I transfer to Excel. What I would like to acheive is to revove duplicate line but only some special duplicate.

Railcars 11-04-2005-3 .xls
	A	B	C	D	E	F	G	H	I	J
1	Railcar#	Code		Heat#	Std#	Grade	Qty	Sch	Size	Location/Remarks
2	102	QI602	N	W85463-2	QI226	81/84V0000	40	23	8.50
3	102	QI602	N	W85463-2	QI226	81/84V0000	40	31	8.50
4	102	QI602	N	W85464	QI226	81/84V0000	2	2	8.50
5
6	104	QI600	N	W86137	QI216	76/7900000	38	13	9.00
7	104	QI600	N	W86137	QI216	76/7900000	38	25	9.00
8
9	135471	QI602	N	W86948	QI131	1038CH	35	13	8.50
10	135471	QI602	N	W86948	QI131	1038CH	35	22	8.50
11	135471	QI602	N	W86947	QI131	1038CH	8	32	9.00
12	135471	QI602	N	W86947	QI131	1038CH	8	26	9.00
Railcars to unload Query

In this example, you have the Heat # coming up a couple time. I must say where the column Sch is where the heat is shecule under different PO.
So you have the same Heat # coming back in the same railcar.
I would like to keep only one heat out of 2 or 3 or 4..

How can it be done?

Thanks for your help.
JP

 

[MacFil]

Just got back to my office this morning.
Change the line to
if cell = cell.offset(-1,0) then cell.entirerow.delete
That did it. Works vrey good.

Thats what I was looking for.

Thank you so much for your help.

JP