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 -~----------~----~----~----~------~----~------~--~---
