Hi My knowledge of Excel is limited, but i wanted to hide a row in excel 2010 when either a date is imputed in up to 3 cells (C2,E2,G2)or the cell next to the Date Column is "N/A". We have a spreadsheet at work where we track the status of job tickets and when it is complete in addition we can have up to 2 or 3 sub Contractors invoices attached to the same Job or in some cases no Sub contractors invoices, I would like to hide the rows when a Job is complete and when all the sub contractors invoiced are received if there are any.
In the example below rows 2 and 4 would be hidden as all information has be collected and processed
is there a macro that can be set up to hide rows and make them visible when needed based on values in the example below?
Thanks in advance
<tbody>
</tbody>
In the example below rows 2 and 4 would be hidden as all information has be collected and processed
is there a macro that can be set up to hide rows and make them visible when needed based on values in the example below?
Thanks in advance
A | B | C | D | E | F | G | |
1 | address | ticket status | Date Processed | Flooring Invoice | Date Processed | Gas Invoice | Date processed |
2 | 1 New Street | Complete | 10/4/2012 | N/A | Yes | 11/4/2012 | |
3 | 3 New house | Not Complete | yes | 9/4/2012 | Yes | 11/4/2012 | |
4 | 5 old street | Complete | 20/4/2012 | Yes | 22/5/2012 | N/A |
<tbody>
</tbody>