I need your help on some simple excel macro that would be

2 columns, one named "in" one named "out"

i need to write down in the first column a series of numbers that would be barcodes let's say

11254
22334
55777

when i write the same numbers in the second column, like 22334 the macro should delete these numbers from the first column, so the first one would look like

11254

55777

is this possible to make it with excel?

thanks to all

I asked my friend who knows Excel very well for help , he said it's possible but not to do it automatically but with the Button that would delete duplicates from the 1st column and write them down in the new sheet.

Can you send the structure of the columns?

cheers,
g

there's no structure, i just need a new excel document with them settings

the first 2 columns, a and b

what's in any cell from a cannot be in b

a client of mine works for prada, he cut the leather into shoes
he receive barcodes wich are a certain pair of shoes to cut
when he cut them he send them back to prada
but he never know what he have in his factory, or what he sent back to prada from these barcodes

he need somethig simple, so when prada ask him for a barcode, he can check the excel what colums contain that barcode

when he receive the barcode, he write it into the column A
when he send back to prada the barcode, he write in the column B

but the column A have to delete the barcode he wrote in B to avoid duplicates

i'm not a programmer or an engineer anymore, i'm a salesman now
i sell copiers and computers to offices in my area

it should be ready later today , here's preview pic



cheers,
g

check the inbox

wicked one just what I needed THANKS A LOT man