software

To start out I have a spreadsheet with a column of people's names and
then a row accross with various tasks. Then the corresponding
name-to-task cell is marked with a quot;Cquot; for complete or quot;Rquot; for
required. What I would like to do is find a way to, the same sheet
further down, create a list with each persons name and the name of the
tasks marked quot;Rquot;. For example:

Name | Tasks
----------------
John | Task#1
------------------
| Task #2
------------------
Joe | Task #2
------------------
| Task #3
etc...

I'm currenty using simple conditinals but found this to be tedious with
over 500 names. And also I would like to find away to eliminate a lot of
the white space (when the conditinal is false display nothing). I was
think of a loop that would look at each of the cells in the row and
then if it was equal to quot;Rquot; it would display whatever and then go to
the next row. I don't know how complicated this is and I fairly newb
when it comes to macros. Any help and/or alternative ways are very much
appriciated. Feel free to ask questions if you need more clarification.--
asianmike
------------------------------------------------------------------------
asianmike's Profile: www.excelforum.com/member.php...oamp;userid=30973
View this thread: www.excelforum.com/showthread...hreadid=506406