Hi,
Please provide me macro of the attached sheet.
Actaully i want a macro which are splits one cell data into deiffernt cells or rows.
Please do the as soon as posible.
Thanks & Rgds
Firoz
Hi,
Please provide me macro of the attached sheet.
Actaully i want a macro which are splits one cell data into deiffernt cells or rows.
Please do the as soon as posible.
Thanks & Rgds
Firoz
Hi Firoz,
Welcome to board!!
Try this macro.
Note: create a backup of your file first.
HTHPlease Login or Register to view this content.
Kris
Here's a set of formulas that will do the work. Just point the first set (rows 15) at your starting cell of data, then copy down, all your values will appear.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks So much. i am appriciate your help. But if you give me macro then it'll be better for me. but still its very good. thanks agian
Thanks so much. i am appriciating your help.
hi Krishnakumar,
First of all thanks for your greate help...
But macro us not workinf... when i am run the macro got the error.
then i debug the code then its give below attached code in yellow..
.TextToColumns Destination:=r.Cells(1, 1), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _
:="-", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 3), Array(4, 3), Array(5, _
1), Array(6, 1), Array(7, 1)), TrailingMinusNumbers:=True
Here's my original solution in a macro form. Your data has some really odd random characters in and amongst the spaces making Krishna's macro behave irregularly.
Mine uses the characters within the strings to parse and seems to behave more consistently.
Put your data in the DATA sheet in column A and run the macro, it will create the REPORT sheet for you.
Please Login or Register to view this content.
Thanks so much...
Man you are a Rocket science,
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
Hi,
Select B4:B8 and run the code.
HTHPlease Login or Register to view this content.
Last edited by Krishnakumar; 07-11-2009 at 07:16 AM.
Hi,
Having the same problem. But the find fucntion should not be hardcoded. It should be taken from a different sheet and paste the date.
text file is imported and placed in a excel sheet.
1.if the first 4 characters are matching with the work sheet name then it should copy the entire row and paste the columns wise data based on column split up. The split for each column will be given in separate sheet.
1XYZ Column1 1 10
1XYZ Column2 11 18
1XYZ Column3 29 18
1XYZ Column4 47 10
1XYZ Column5 57 12
2.If there are any unmatched rows then it should be pasted in Unmatched row.
David4red,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks