Sap 1 to Sap 2 card transfer

[makinmomb]

100.000.01	GEMMA 40 X 40 = KARNAK BEIGE P GRANITO	FLOOR GEMMA	KARNAK BEIGE	GEMMA	007A	0	remove
100.000.02	GEMMA 40 X 40 = KARNAK GREY P GRANITO	TILE GEMMA	KARNAK GREY	GEMMA	007A	0	remove
100.000.03	GEMMA 40 X 40 = MYKONOS GREYP GRANITO	FLOOR TILE GEMMA	MYKONOS GREY	GEMMA	007A	0	remove
100.000.04	GEMMA 50 X 50 = ARIZONA BEIGE		ARIZONA BEIGE	GEMMA	005A	0	remove
100.000.05	GEMMA 50 X 50 = VERANDA BRICK		VERANDA BRICK	GEMMA	005A	0	remove
100.000.06	GEMMA 50 X 50 = VERANDA BRICK GEOMETRIC	GEMMA	VERANDA BRICK	GEMMA	005A	0	remove
100.000.07	GEMMA 25 X 35 = BOMBAY GREEN		BOMBAY GREEN	GEMMA	016A	0	remove
100.000.08	GEMMA 30 X 44 = ISCANDARONA BROWN DARK		ISCANDARONA BROW	GEMMA	011A	0	remove
100.000.09	GEMMA 20 X 20 = SOLANGE IVORY		SOLANGE	GEMMA	022A	1000.00
100.000.10	CLOSED CARD			GEMMA	PC	0	remove
100.000.11	CLOSED CARD			GEMMA	PC	0	remove
100.000.12	GEMMA 20X30 = FRUTTI BEIGE		FRUTTI BEIGE	GEMMA	020H	0	remove
100.000.13	GEMMA 20X30 = FRUTTI BRICK		FRUTTI BRICK	GEMMA	020H	0	remove
100.000.14	GEMMA LISTELO 10 X 20 = FRUTTI BEIGE		FRUTTI BEIGE	GEMMA	PC	0	remove
100.000.15	GEMMA DECOR 20X30 = FRUTTI BEIGE	GEMMA	FRUTTI BEIGE	GEMMA	PC	0	remove
100.000.16	GEMMA 30 X 30 = ARIZONA MARRON		ARIZONA MARRON	GEMMA	015A	2000.00

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

100.000.01	GEMMA 40 X 40 = KARNAK BEIGE P GRANITO	FLOOR GEMMA	KARNAK BEIGE	GEMMA	007A	0	remove
100.000.02	GEMMA 40 X 40 = KARNAK GREY P GRANITO	TILE GEMMA	KARNAK GREY	GEMMA	007A	0	remove
100.000.03	GEMMA 40 X 40 = MYKONOS GREYP GRANITO	FLOOR TILE GEMMA	MYKONOS GREY	GEMMA	007A	0	remove
100.000.04	GEMMA 50 X 50 = ARIZONA BEIGE		ARIZONA BEIGE	GEMMA	005A	0	remove
100.000.05	GEMMA 50 X 50 = VERANDA BRICK		VERANDA BRICK	GEMMA	005A	0	remove
100.000.06	GEMMA 50 X 50 = VERANDA BRICK GEOMETRIC	GEMMA	VERANDA BRICK	GEMMA	005A	0	remove
100.000.07	GEMMA 25 X 35 = BOMBAY GREEN		BOMBAY GREEN	GEMMA	016A	0	remove
100.000.08	GEMMA 30 X 44 = ISCANDARONA BROWN DARK		ISCANDARONA BROW	GEMMA	011A	0	remove
100.000.09	GEMMA 20 X 20 = SOLANGE IVORY		SOLANGE	GEMMA	022A	1000.00
100.000.10	CLOSED CARD			GEMMA	PC	0	remove
100.000.11	CLOSED CARD			GEMMA	PC	0	remove
100.000.12	GEMMA 20X30 = FRUTTI BEIGE		FRUTTI BEIGE	GEMMA	020H	0	remove
100.000.13	GEMMA 20X30 = FRUTTI BRICK		FRUTTI BRICK	GEMMA	020H	0	remove
100.000.14	GEMMA LISTELO 10 X 20 = FRUTTI BEIGE		FRUTTI BEIGE	GEMMA	PC	0	remove
100.000.15	GEMMA DECOR 20X30 = FRUTTI BEIGE	GEMMA	FRUTTI BEIGE	GEMMA	PC	0	remove
100.000.16	GEMMA 30 X 30 = ARIZONA MARRON		ARIZONA MARRON	GEMMA	015A	2000.00

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[makinmomb]

Want result

100.000.01	GEMMA 20 X 20 = SOLANGE IVORY		SOLANGE	GEMMA	022A	1000.00
100.000.02	GEMMA 30 X 30 = ARIZONA MARRON		ARIZONA MARRON	GEMMA	015A	2000.00

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[makinmomb]

I need a macro to delete all rows on where I have comment remove on column h

 

[makinmomb]

The card that was follows

100.000.01

GEMMA 40 X 40 = KARNAK BEIGE P GRANITO

<colgroup><col width="71"><col width="316"></colgroup><tbody>
</tbody>

becomes since all stock codes 100.000.01 and 100.000.08 are new old codes not required for new system

100.000.01

GEMMA 20 X 20 = SOLANGE IVORY

<colgroup><col width="71"><col width="316"></colgroup><tbody>
</tbody>

 

[Rick Rothstein]

Does Column H contain the words "remove" as constants or is there a formula in that column which displays the word "remove" under certain circumstances?

 

[makinmomb]

yes its column h

All cards with zero stock has remove

 

[makinmomb]

If the copy paste works correctly you will find the code

100.000.09 solange ivory has no remove that stock card
needs to remain but it needs to become 100.000.01

 

[Rick Rothstein]

yes its column h

All cards with zero stock has remove

You did not answer the question that I asked... I need to know if Column H contains formulas or not.

 

[makinmomb]

no formula manually written

 

[makinmomb]

if it was formula I will paste special as values