I needs one macro or any other method to extract the details from my Spreadsheet. I have entered stock market details on sheet1. There are around 10 companies, i need it to separate for each sheet for each company (ex. i needs 10 separate sheets for 10 companies on the same file). After separate it i need it to merge into a master file of those sheets. If any one help to create a macros or anymethod for this separation. Kindly PM to get the sample file. My budget is very low.