A
asianmike
To start out I have a spreadsheet with a column of people's names an
then a row accross with various tasks. Then the correspondin
name-to-task cell is marked with a "C" for complete or "R" fo
required. What I would like to do is find a way to, the same shee
further down, create a list with each persons name and the name of th
tasks marked "R". 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 wit
over 500 names. And also I would like to find away to eliminate a lot o
the white space (when the conditinal is false display nothing). I wa
think of a loop that would look at each of the cells in the row an
then if it was equal to "R" it would display whatever and then go t
the next row. I don't know how complicated this is and I fairly new
when it comes to macros. Any help and/or alternative ways are very muc
appriciated. Feel free to ask questions if you need more clarification
then a row accross with various tasks. Then the correspondin
name-to-task cell is marked with a "C" for complete or "R" fo
required. What I would like to do is find a way to, the same shee
further down, create a list with each persons name and the name of th
tasks marked "R". 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 wit
over 500 names. And also I would like to find away to eliminate a lot o
the white space (when the conditinal is false display nothing). I wa
think of a loop that would look at each of the cells in the row an
then if it was equal to "R" it would display whatever and then go t
the next row. I don't know how complicated this is and I fairly new
when it comes to macros. Any help and/or alternative ways are very muc
appriciated. Feel free to ask questions if you need more clarification