hello
I have files names and extensions in column a I would class every extension file are alone each extension of file it should be in separate column
what i wish result start column e:g
thanks
hello
I have files names and extensions in column a I would class every extension file are alone each extension of file it should be in separate column
what i wish result start column e:g
thanks
Last edited by ABDELFATTA; 03-11-2021 at 11:18 AM.
This makes no sense...How does green fit under that extension...
Untitled.png
If you want all under individual then here is one way...
Please Login or Register to view this content.
Last edited by Sintek; 03-11-2021 at 11:16 AM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
sorry sintek you right I update my file and with I add notice may be another extension like .txt or others
Code in Post 2 should solve for all extensions...No new upload though...
actually I tested it all the files copy in one column in h not each of them separated based on header extension
I clear the headers and I tested it creates headers of extension but the copy occurs in one column is h , where I mistook?
Doing something wrong or file is not same as sample file...where I mistook?
See attached...
Last edited by Sintek; 03-11-2021 at 11:36 AM.
actually this matter happened in the beginning but I'm not sure to say you that but when I tested also in your file happened the same thing
when I tested from the first time the code works as what I want but if run macro repeatedly it happens this problem , it copies in one column
may you check it, please ?
That is obvious...but if run macro repeatedly it happens this problem , it copies in one column
Just add this snippet before...If you really do not want to delete yourself...
Why would you need to press button all the time...Please Login or Register to view this content.
first of all I would thank you for the great code , you're super professional
the second I put the line what you suggested before this lineam I right or wrong ? it works for me.HTML Code:
and what means this is in code "" "" """ ""
finally I would ask you thing personally if that is not upset you how did learn write code are you programmer or just hobby you learnt from the I internet ?
Last edited by ABDELFATTA; 03-11-2021 at 12:08 PM.
My apologies Abdelfatta...Is my bad...Only just realized that your data could increase and thereby need to be updated...
Sorry...Put that snippet after
Please Login or Register to view this content.
From this forum...hobby you learnt from the
Please try
Please Login or Register to view this content.
@sintek you shouldn't apology , you here to help the others maybe you're right or wrong i believe you do your best
about next I , actually I'm not sure if I understand you this line is existed in the code and before I reply you i added another extension like txt and the code works normally i no know what are you talking about
@Bo-Ry your file is very nice thanks for provide a different code and different way it's very useful
Yes...after Next iI put the line what you suggested before this line
thanks for rep +Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks