BRAINKILLER FORUM
http://www.brainkiller.it/forum/

Need help on Excel macro
http://www.brainkiller.it/forum/viewtopic.php?f=10&t=8760
Page 1 of 1

Author:  BRAINKILLER [ Tue Jul 08, 2014 10:42 am ]
Post subject:  Need help on Excel macro

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

Author:  gava [ Tue Jul 08, 2014 12:49 pm ]
Post subject: 

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

Author:  BRAINKILLER [ Tue Jul 08, 2014 1:39 pm ]
Post subject: 

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 :-D
i sell copiers and computers to offices in my area

Author:  gava [ Wed Jul 09, 2014 10:03 am ]
Post subject: 

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

Image

cheers,
g

Author:  gava [ Wed Jul 09, 2014 1:48 pm ]
Post subject: 

check the inbox :wink:

Author:  BRAINKILLER [ Wed Jul 09, 2014 2:05 pm ]
Post subject: 

wicked one just what I needed THANKS A LOT man

Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/