Help in vb excel macro

Closed
Posts
2
Registration date
Tuesday January 26, 2010
Status
Member
Last seen
January 28, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
i got a trouble in vb, i try to record my own macro or find a good one for my problem on internet. I'm a newby in vb, i understand a bit the base of vb but really i'm not a crack...

My problem, i'm making a list of padlock with serial numbers, open code, from an old paper list. I'm scanning all the sheet with ocr sanner. But a got 3000 line to do. The scanning give me this.

a1                  b1                       c1                      d1                     e1                   f1
(serial)            #1                       #2                     #3                    empty             empty
77654566         32                       22                     12

That great, but now i need to take 3000 line of those number and put it in a6 in format 32-22-12
it suppose to look like this.
a1                  b1                            c1                      d1                       e1                       f1
(serial)          empty                    empty                 empty                  empty                   #1-#2-#3
77654566                                                                                                             32-22-12


So you can imagine what is a pain in the ass to do 3000 line of copy paste....i try to record my own but as soon i'm trying to copy the second number into the same cell, The recording doesn't reconize it ??
So i need your help very badly.

Fmasse

1 reply

Posts
2
Registration date
Tuesday January 26, 2010
Status
Member
Last seen
January 28, 2010

dam page formating

a1 =serial number ( 77654566 )
b1 = #1 ( 32 ) c1 = #2 ( 22 )
d1 = #3 ( 12 )
e1 = empty
f1 = empty



then what i need


a1 =serial number ( 77654566 )
b1 = empty c1 = empty
d1 = empty
e1 = empty
f1 = #1-#2-#3- ( 32-22-12 )
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Dont know if you are still looking for this solution

but in F1 you can use this formula

=B1 & "-" & C1 & "-" & D1

Drag it down to last row

select column F

Select Copy and then choose pastespecial and choose values

Then select column B, c and D and choose Clear content