Pulling data from one sheet to another that meets certain criteria.

Hello,

I work at a youth center and we are offering several camps this summer to our kids. I'm trying to create a database that tracks all of the kids, their payments and who is signed up for what camps.

Currently I have it divided into two pages. The first tracks the kids, what camps they have signed up for and how much they have paid for each camp. The second pulls the data from the first page and tracks how much each kid has paid total, how much they owe total, and then the difference.

I'd like to be able to create a page for each camp that lists the kids in order who have signed up for the camp, but not the ones who haven't. So far I've been somewhat unsuccessful in using if statements to do it, but I've come close. Any help would be greatly appreciated.

I've attached the spreadsheet to give a better idea of what I'm talking about. I have some if statements I've tried to use on the third sheet, but they definitely have some issues.

Can you provide a sample worksheet?

Just saw the second posting - will take a look at it. Seems straightforward.

Sweet, thanks pmalen.

I've tried several codes, but they are all ridiculously long and always seem to have small issues. I feel like there has to be an easy way to do this.

Thanks FDibbins, that should work! Is there any way to make it display the numbers on the side in chronological order, or will it just pull them from the first page? It's not a huge issue it can't.

And thanks for cleaning up the code, that looks much better.

That added numbering to the side, thank you! It's doing something weird where it skips every other person if I have them all signed up though. I'm trying to understand VLookup and iferror a bit more so I can fix it myself (or at least understand in the future) but I'm not having much luck.

Alright, I think I'm understanding what you did exactly, the only thing that I'm not really sure of is the row function. I think that's where the issue might be, and I tried messing around with it but it didn't help at all.

That explained it indeed! That update is now pulling all names that it should, but it stopped numbering them in chronological order. I'm thinking I may just leave it, it's proving to be quite complicated

Sorry, I wasn't explaining what I was trying to do very clearly. It's numbering them in chronological order, but I'm trying to make them number "1,2,3,4,5,etc." down column A regardless of who is listed in column B. That's what I've been struggling to do :S

So I change the code for everything in column b on Extreme Week 1 to the code you posted and it will work?

Never mind. I just pulled everything that was in column A down to column AY, and then put numbers 1-36 in column A. It seems to be working exactly as I was hoping for. Thanks for all of the help FDibbins! I'll post back if anything else crops up.

Done and done. Thanks again!