Compiling Select Data from Multiple Worksheets into One Summary Page

**rockytop80** · 12-06-2011, 03:50 PM

Hi all,

I'm wading into an area of Excel I've never been before. I have attached a sample document to illustrate what I need to do:

Tab 1 (“Fishing”) is a list of employee shifts. Note that the value in B3 is “CP – Fishing”.
Tab 2 (“Archery”) is a list of employee shifts. Note that the values in B4 and B6 are “CP – Archery”.
Tab 3 (“Custom Programs”) is where I’m stuck. In my example you’ll see that the Custom Programs” tab compiles all the data from any row where the letters “CP” are listed. I did it manually in the example (copy and paste) but I’d like for that worksheet to populate automatically as I build a schedule in the other tabs.

I’ve scoured the boards and seen similar questions, but haven’t been able to translate the answers into something that will work for me. I am somewhat familiar with using formulas but have no experience with macros/codes if that's what is needed.

I’m running Excel 2010.

Any help is appreciated!

**tigeravatar** · 12-06-2011, 04:10 PM

rockytop80,

Welcome to the forum!
Why wouldn't you just put it all in one worksheet and use a text filter on column B for contains CP? See attached as an example.

**rockytop80** · 12-06-2011, 04:17 PM

Hmmmm, well that's not a bad idea. Let me work that over in my head to see if it would work for us. Once the schedule is built we'll have a couple thousand shifts divided among 5 major activities, so it's alot of info. But what you've done actually might provide some great functionality for us. Thanks! I'll come back and mark "solved" if it turns out this will work. :-)