Thanks Seema and Paul, for posting your reply to my problem. I am aware of the fuctionality to import data from text files.
Seema: the file you have attached is the exact point from where i have my problem, i need to modify the input data from here. If you see at Column A: you will find the following: Row 1: states the column headings Row3: i.e. "Open Ended Schemes(Balanced)" [This is one type of data in the file] Row5, 10,17: are the Scheme Names [or companies that have Row3 kind of schemes] Row7&8: are two sub schemes available under the company [Baroda Pioneer Mutual Fund] Now, the problem i am facing is as follows: I need, Company Name, Scheme Type, in front of every Sub Schemes, so that my data becomes adequate to apply Autofilter on. Please help, or advise on how to approach this problem Thanks Harry On Apr 5, 10:09 pm, paulwillekens <paul.johan.willek...@gmail.com> wrote: > Hi Hapreet, > > I agree with Seema: import with delimiter semicolon and the first > sheet RAW DATA becomes easier. > > If it is still "very cumbersome" for you to convert this Seema-Raw > Data to the Modified data sheet, tell me and I'll make it in the blink > of an eye... > > Kind regards, > > Paul Willekens -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.