Hi, better to use "Selection.TextToColumns" with text then use "Selection.Copy" and "Selection.PasteSpecial Transpose:=True"
Sincerely, ASD 2008/10/1 FF <[EMAIL PROTECTED]> > > Hi, > I am trying to parse data from notepad to excel using VBA macro. > A, B, C > Field4 = 8.2 > Field5 = 6.7 > Field6 = 59 > Field7 = 5.6 > > A, E, F > Field4 = 7.2 > Field5 = 6.9 > Field6 = 60 > Field7 = 5.8 > > I don't know how many datasets would be in a notepad. > But I want to parse this data as rows in excel sheets: > A B C 8.2 6.7 59 5.6 > A E F 7.2 6.9 60 5.8 > Can anyone help me with this? > Thanks > FF > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
