Pulling detailed data from one sheet to another

I don't think this may even be possible, but what I am trying to do is pull only certain information from one worksheet to another based on whether there are entries on certain dates for employees.

A sample is attached.

On the first worksheet I have a drop down menu for all employees on the second sheet. (the drop down menu pulls the names from the second sheet)

The second worksheet has all employees in Column A and to the right has all their variances by date. Most dates will be blank as they didn't have a variance.

What I would like is on the first worksheet, is to select their name from the drop down menu and have all the dates that they had variances and the variances show up.

If you take a look at the attached excel file it might explain what I am trying to do better.

Thanks for any help.

Wow that is pretty cool how you did that. I will work on this over the next couple days and see if I need additional help intergrating into my main form.

Thanks!

Thanks again I have the formula working.

I am trying to also have an absolute value "abs" of the total variances on the employee page below the net value but I am getting an error with the formula I am using:

=SUM(ABS(B9:B200))

I am getting #VALUE!

When I tried this one:

=ABS(SUM(B9:B200))

It just gave me the NET total as a positive number, not sure why.

Is there another way to get the ABS?

Thanks

=SUM(ABS(B9:B200))

It's ok, but you must commit with Ctrl+Shift+Enter.

I did do the Ctrl Shift Enter, but it still shows up #VALUE!

I wonder if it has something to do with the formula that is being used in the cells with the amounts in column B?

try this

=SUM(ABS(IF(ISNUMBER(B9:B200),B9:B200)))

Commit with Ctrl+Shift+Enter

Thanks that worked.

I am coming back to this worksheet that a few people here helped me design. I have been using it and it has been working great.

Something new I was wondering if it would work. Can a comment on a cell on one sheet be populated into a cell on another sheet as text?

That is the best I can explain it. If you take a look at the working sample I have you can see what I am trying to do.

On the attached example, cashier #6 had a variance on 03/02/2009 for $25.00 I place a comment on this cell. On the Employee Search page where the date and variance show up I would like the comment to be shown in column C next to the date/variance.

The file attached is saved in Excel 2007.

Thanks,
Nick