If Name is checked on Sheet 1, mark appropriate column in Sheet 2??

[Ed from AZ]

We have a list of names on Sheet 1. If one of these people needs
review, there is a column to place an X next to their name; typing the
X makes their name show in another column. Like so:

Name X? Yes
Bob
Sue X Sue
Hal
Edd X Edd
Flo

On Sheet 2 is an imported list of activity reports. One of the items
on the imported list is the file path; from this we can extract the
name into a helper column.

I can use MATCH in Sheet 1 to look up the "Yes" names ("Sue" and
"Edd") within the Name column on Sheet 2 and mark them so we can tell
at a glance if that name has activity available for review. Looks
like:

Name X? Yes CanDo
Bob
Sue X Sue Y
Hal
Edd X Edd Y
Flo

Is there a non-macro solution to mark/highlight the names in Sheet 2
or mark a helper column that match all the "Y" names in the Sheet 1
"CanDo" column? So on Sheet 2, all of Sue's and Edd's activity
reports are somehow indicated so we can easily pick them out of 35k
rows of information? Could be formula, validation, whatever - just
prefer no macros. Where can I start looking?

Ed

 

[WallyWallWhackr]

We have a list of names on Sheet 1. If one of these people needs
review, there is a column to place an X next to their name; typing the
X makes their name show in another column. Like so:

Name X? Yes
Bob
Sue X Sue
Hal
Edd X Edd
Flo

On Sheet 2 is an imported list of activity reports. One of the items
on the imported list is the file path; from this we can extract the
name into a helper column.

I can use MATCH in Sheet 1 to look up the "Yes" names ("Sue" and
"Edd") within the Name column on Sheet 2 and mark them so we can tell
at a glance if that name has activity available for review. Looks
like:

Name X? Yes CanDo
Bob
Sue X Sue Y
Hal
Edd X Edd Y
Flo

Is there a non-macro solution to mark/highlight the names in Sheet 2
or mark a helper column that match all the "Y" names in the Sheet 1
"CanDo" column? So on Sheet 2, all of Sue's and Edd's activity
reports are somehow indicated so we can easily pick them out of 35k
rows of information? Could be formula, validation, whatever - just
prefer no macros. Where can I start looking?

Ed

Data validation.

I use that to color a cell IF a condition exists, and I use it to blank
the cell entirely, borders and all, if it does not exist.

Take a look at my example of just this ability on the Microsoft
Template site.

http://office.microsoft.com/en-us/templates/recent.aspx

It is the resistor coder on page two.

http://office.microsoft.com/en-us/templates/recent.aspx#pg:2|ai:TC101939744|

All of my submissions are here...

http://office.microsoft.com/en-us/providers/PN030000658.aspx

Anyway, I use lookups and data validation and conditional formatting
all the time and avoid macros as much as I can as well, wherever
possible, of course.

Check out the football stats sheet too.

 

[Ed from AZ]

Thanks for the input. Before I could go further on this, though, they
threw me a new wrinkle: the data would be imported. The import links
are messing with things a bit, so I'll have to work through that
first.

Ed