Extract information from Multiple sheets
 

I have a workbook with 12 sheets inside of it, each of these sheets is a
series of names and age groups how can I extract 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 group from each sheet into one, over 200 entries
in each
sheet, so need macro or a formula.

Extract information from Multiple sheets
 

Hi,

If you only need to do this once, you could either set Data, Autofilter
on each sheet, and select the under 14 range to copy/paste,
or,
simply copy and paste all 12 sheets into one sheet, and sort over the
age column and bulk-delete all unwanted lines. With 3,000 lines this is
not too cumbersome a task.

If you need to perform this task often, then you have the option of
either recording a macro as you perform the above, or getting some VBA
code to join either the full set of worksheets or the selected range.
The drawback to VBA code is that if next time you have different Sheet
names or need a different group you will need to know how to amend it.

Does this help?

--


bbc1 Wrote:
I have a workbook with 12 sheets inside of it, each of these sheets is
a
series of names and age groups how can I extract 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 group from each sheet into one, over 200
entries
in each
sheet, so need macro or a formula.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533578