Help in vb excel macro

Closed
fmasse Posts 2 Registration date Tuesday January 26, 2010 Status Member Last seen January 28, 2010 - Jan 28, 2010 at 07:33 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 12, 2010 at 10:21 PM
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

fmasse Posts 2 Registration date Tuesday January 26, 2010 Status Member Last seen January 28, 2010
Jan 28, 2010 at 08:35 AM
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 )
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 12, 2010 at 10:21 PM
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
0