how to pick up 50 from 1500 MS excel list

i have 2 MS excel sheets. One is having 1500 companies and other 50 companies (important that these 50 companies are part of 1500) . Every day the share prices of 1500 companies will change. i want to submit 2 sheets (1500 and 50) to my management daily. No issues with 1500 excel sheet as i directly get that, but is there any option/formula to get other 50 companies from the first 1500 companies sheet directly???


Please help me

Thanks
Raja

Raja,

Please explain some more detail or perhaps upload two spreadsheets to demonstrate (With fictional data not real data!)