• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Merging Column with Serial Number

L

LearnExcel&VBA

Member
Sir actually i want this result from above code.

Column "A" has already this number
205-371-
205-372-
205-373-
205-374-

and i want to add serial number like this
0001, 0002 , 0003 , 0004

then both will be merge and result will be like
205-371-0001
205-371-0002
205-371-0003
205-371-0004

Sheet1 has data and Numbers have numbers.

Any help would be highly appreciated.
 

Attachments

  • Sheet 1.csv
    2 KB · Views: 6
  • Numbers.xlsm
    126.3 KB · Views: 3
LearnExcel&VBA
Your csv-file ... do not have any columns
Your Excel-file has texts in B-column
Do You have clear image - where would something to do?
Do all those texts in B-column should add somewhere?
You refer to some 'code' ... where is that code?
 
I do not know how i mentioned about the code when i was looking for, it could happen by mistaken.

Sheet1 has these number in Column A
205-371-
205-372-
205-373-
205-374-

and i want to add numbers sheet Col B text with Sheet1 Col A sequence wise

It will be like concatenating the Columns
its result will be as in picture

70328
I just added it till 0006 manually

I have large set of data with multiple files so cannot do this via formula.
 
LearnExcel&VBA
Learn to give answers based questions.
You had only 'image' - where...
other questions, You missed to answer.

One sample...
press [ Do It ]
and
it will make a new .csv-file.
 

Attachments

  • BookCSV.xlsb
    19.7 KB · Views: 4
Thank you so much you understand my theme to apply the code even after i could not clarify it. but the code is not adding 0001, 0002, in the selected sheet in Col A along with
205-371-
205-372-
205-373-
205-374-

. I do not why.

Here is attached sheet.
 

Attachments

  • sample sheet (2) - Copy.csv
    912.5 KB · Views: 5
Last edited:
LearnExcel&VBA
Did You read any of my writings eg it will make a new .csv-file ?
... did You check ... is there the new .csv-file based You original .csv-file?

Any .csv-file do not have 'Col A'
... and no need to open with Excel for this thread!

Your sample .csv-file is a different,
but it would still work ... and it works - tested
 
LearnExcel&VBA
Could You answer sometimes question?
Below behind New_Sheet 1.cvs - after [ Do It ] and
in front - original (Sheet 1.csv)
What is missing?
Screenshot 2020-07-30 at 14.04.04.png
... as I also has written ... .csv-file no need to open with Excel.
 
Did You read any of my writings eg it will make a new .csv-file ?
Yes.

... did You check ... is there the new .csv-file based You original .csv-file?
Yes there is a new file

Thank you so much Sir. I apologize and will keep in mind next time.
 
vletm

I would like to one more request that please if once code adds till 9999 then it should again start from 0001 rather than 10000, and code should select the all files a folder have.
 
LearnExcel&VBA
9999 limit is possible,
but have You thought over one second that Your other 'one more request' ... have You?
And ... previous Your worry that it won't work ... do it work?
... I didn't change anything!
 
LearnExcel&VBA
Two question marks ... one reply.
There would be endless loop - as You should obviously know...
... all files ... means all files, no matter which files
and from each file would create a new .csv-file.
and each new file would need to select too.
Here is 9999-limit, with file which You skipped to answer - do it work ... anyway?
 

Attachments

  • BookCSV.xlsb
    18.8 KB · Views: 3
with file which You skipped to answer - do it work ... anyway?
Yes previous code is working accurate.

But this new code is selecting just once file.


70347
 
LearnExcel&VBA
Do You remember - what was Your original thread? ... how many files?
As You're learning
... You should learn as soon as possible,
... You should have clear image what to need?
If add something ... even which could be any minor detail as You could image ... that could mean to start from zero.

As well as,
Did You skip 'some lines' from my previous reply?
 
Do You remember - what was Your original thread? ... how many files?
Yes it was only one.
... You should learn as soon as possible,
... You should have clear image what to need?
I am trying but right now i am not perfect but one day will become.

Did You skip 'some lines' from my previous reply?
and each new file would need to select too.

I do agree but now there are 12 files having 50000 data.

I want to select once.
 
LearnExcel&VBA
You seems to skipping some lines.
Instead to write everything again as well as to get a clear idea - how You would those challenges.
You should do those massive 12 files one-by-one.
I also would like to want something ...
 
You seems to skipping some lines.
Which lines.

Instead to write everything again as well as to get a clear idea - how You would those challenges.
I will try at my end.

You should do those massive 12 files one-by-one.
Alright.

I also would like to want something ...
what?
 
You must log in or register to reply here.
Back
Top