mighty mouse
Board Regular
- Joined
- Mar 17, 2005
- Messages
- 140
Wondering how to do the following (formula-based); hope this makes some sense!
-I have a list of customers that I receive reports from in column A.
-When I receive a report from a customer I put an "x" in column D to show report was received that week.
-However, next to column A is another name in column B that the report must be forwarded to. Not all the names in column A have a name in column B that reports have to be forwarded to, but there are some.
-I'm looking to put the names of those whom reports must be forwarded to on sheet2, and under each of those names a list forms as I place an "x" onto sheet1.
Example:
Cell A3 of sheet1 says "Smith"
I receive a report from Smith, so I put an "x" in cell D3.
Cell B3 says Anderson, meaning that if I receive a report from Smith, it needs to be forwarded to Anderson.
In cell A3 of sheet2, it says Anderson-and below that name I need to form a list of all reports that will need to be forwarded to Anderson. Smith would appear under Anderson's name in sheet2.
Thanks for any assistance!
-I have a list of customers that I receive reports from in column A.
-When I receive a report from a customer I put an "x" in column D to show report was received that week.
-However, next to column A is another name in column B that the report must be forwarded to. Not all the names in column A have a name in column B that reports have to be forwarded to, but there are some.
-I'm looking to put the names of those whom reports must be forwarded to on sheet2, and under each of those names a list forms as I place an "x" onto sheet1.
Example:
Cell A3 of sheet1 says "Smith"
I receive a report from Smith, so I put an "x" in cell D3.
Cell B3 says Anderson, meaning that if I receive a report from Smith, it needs to be forwarded to Anderson.
In cell A3 of sheet2, it says Anderson-and below that name I need to form a list of all reports that will need to be forwarded to Anderson. Smith would appear under Anderson's name in sheet2.
Thanks for any assistance!