Sap 1 to Sap 2 card transfer

makinmomb

Active Member
Joined
Dec 23, 2013
Messages
401
100.000.01GEMMA 40 X 40 = KARNAK BEIGE P GRANITOFLOOR GEMMAKARNAK BEIGEGEMMA007A0remove
100.000.02GEMMA 40 X 40 = KARNAK GREY P GRANITOTILE GEMMAKARNAK GREYGEMMA007A0remove
100.000.03GEMMA 40 X 40 = MYKONOS GREYP GRANITOFLOOR TILE GEMMAMYKONOS GREYGEMMA007A0remove
100.000.04GEMMA 50 X 50 = ARIZONA BEIGEARIZONA BEIGEGEMMA005A0remove
100.000.05GEMMA 50 X 50 = VERANDA BRICKVERANDA BRICKGEMMA005A0remove
100.000.06GEMMA 50 X 50 = VERANDA BRICK GEOMETRICGEMMAVERANDA BRICKGEMMA005A0remove
100.000.07GEMMA 25 X 35 = BOMBAY GREENBOMBAY GREENGEMMA016A0remove
100.000.08GEMMA 30 X 44 = ISCANDARONA BROWN DARKISCANDARONA BROWGEMMA011A0remove
100.000.09GEMMA 20 X 20 = SOLANGE IVORYSOLANGEGEMMA022A1000.00
100.000.10CLOSED CARDGEMMAPC0remove
100.000.11CLOSED CARDGEMMAPC0remove
100.000.12GEMMA 20X30 = FRUTTI BEIGEFRUTTI BEIGEGEMMA020H0remove
100.000.13GEMMA 20X30 = FRUTTI BRICK
FRUTTI BRICKGEMMA020H0remove
100.000.14GEMMA LISTELO 10 X 20 = FRUTTI BEIGEFRUTTI BEIGEGEMMAPC0remove
100.000.15GEMMA DECOR 20X30 = FRUTTI BEIGEGEMMAFRUTTI BEIGEGEMMAPC0remove
100.000.16GEMMA 30 X 30 = ARIZONA MARRONARIZONA MARRONGEMMA015A2000.00

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
100.000.01GEMMA 40 X 40 = KARNAK BEIGE P GRANITOFLOOR GEMMAKARNAK BEIGEGEMMA007A0remove
100.000.02GEMMA 40 X 40 = KARNAK GREY P GRANITOTILE GEMMAKARNAK GREYGEMMA007A0remove
100.000.03GEMMA 40 X 40 = MYKONOS GREYP GRANITOFLOOR TILE GEMMAMYKONOS GREYGEMMA007A0remove
100.000.04GEMMA 50 X 50 = ARIZONA BEIGEARIZONA BEIGEGEMMA005A0remove
100.000.05GEMMA 50 X 50 = VERANDA BRICKVERANDA BRICKGEMMA005A0remove
100.000.06GEMMA 50 X 50 = VERANDA BRICK GEOMETRICGEMMAVERANDA BRICKGEMMA005A0remove
100.000.07GEMMA 25 X 35 = BOMBAY GREENBOMBAY GREENGEMMA016A0remove
100.000.08GEMMA 30 X 44 = ISCANDARONA BROWN DARKISCANDARONA BROWGEMMA011A0remove
100.000.09GEMMA 20 X 20 = SOLANGE IVORYSOLANGEGEMMA022A1000.00
100.000.10CLOSED CARDGEMMAPC0remove
100.000.11CLOSED CARDGEMMAPC0remove
100.000.12GEMMA 20X30 = FRUTTI BEIGEFRUTTI BEIGEGEMMA020H0remove
100.000.13GEMMA 20X30 = FRUTTI BRICKFRUTTI BRICKGEMMA020H0remove
100.000.14GEMMA LISTELO 10 X 20 = FRUTTI BEIGEFRUTTI BEIGEGEMMAPC0remove
100.000.15GEMMA DECOR 20X30 = FRUTTI BEIGEGEMMAFRUTTI BEIGEGEMMAPC0remove
100.000.16GEMMA 30 X 30 = ARIZONA MARRONARIZONA MARRONGEMMA015A2000.00

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

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Want result

100.000.01GEMMA 20 X 20 = SOLANGE IVORYSOLANGEGEMMA022A1000.00
100.000.02GEMMA 30 X 30 = ARIZONA MARRONARIZONA MARRONGEMMA015A2000.00

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
 
Upvote 0
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>
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,198
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top