Extract information from worksheet

B

bbc1

I have a workbook with 12 sheets inside of it, each of these sheets is a
serie sof names and age groups how ca I extrat the information on a
particular group from each sheet to one sheet.
ie
Sheet a Billy u12 john u14 sarah u16, these are the same across all sheets,
but iI need to extract u14 from each sheet into one, over 200 entries in each
sheet, so need macro or a formular.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract information from Multiple sheets 1
Adding Filtering to a Rating Equation? 0
How to extract email addresses from 1 worksheet to another workbook 19
copying data from master ti individual sheets 3
combining lookup on multiple worksheets 0
Excel 2003 VBA problem - extracting and emailing worksheets 2
Data in sheet1 to be put into sheets 2, 3, 4, 5, etc 2
Information from multiple worksheets to repeat on a single one 1

Top