I want to add a new sheet (Sheet B) to my workbook that copies over all lines on an existing sheet (Sheet A) that are marked with an X.
So for example, I have the following data on Sheet A:
What I want to happen is for all of the lines that are marked "Is Eligible for Credit?" to populate themselves on Sheet B like this:
Adding or removing the 'X' on Sheet A should cause Sheet B to update.
Is there a function that can grab all of these lines, or does this need to be done with a VBA script/macro? Any advice on accomplishing this feat is appreciated.
So for example, I have the following data on Sheet A:
Item | Responsibility | Cost | Is Eligible for Credit? |
Paint walls | Independent contractor | $3750 | |
Fix toilets | Construction company | $500 | X |
Survey foundation | Independent contractor | $750 | |
Rewire interior | Do it myself | $55 | X |
What I want to happen is for all of the lines that are marked "Is Eligible for Credit?" to populate themselves on Sheet B like this:
Item | Responsibility | Cost |
Fix toilets | Construction company | $500 |
Rewire interior | Do it myself | $55 |
Adding or removing the 'X' on Sheet A should cause Sheet B to update.
Is there a function that can grab all of these lines, or does this need to be done with a VBA script/macro? Any advice on accomplishing this feat is appreciated.