ialexander03
New Member
- Joined
- Jun 9, 2017
- Messages
- 14
I have a table of invoices on sheet 1, to which I want to automatically populate the table on sheet 2. However, only the one what have not been paid.
So, if a Y appears in column E, that row is not copied over.
Sounds simple, probably is, however, its needs to be a "living" table, so when an invoice is paid, and the Y is put on sheet 1, it is removed from the table on sheet 2, and everything shifts up, leaving no gaps etc.
Hope that makes sence.
Sheet 1
<tbody>
</tbody>
Sheet 2, what I want anyway, is the same as above, but without CUS1, CUS4, CUS6 and CUS8 as they have the paid marker, but should I enter the paid marker (on the live table on sheet 1) into CUS7, for CUS7 to auto remove from the sheet 2 table, and everything move up.
and yes, I know this may sound a pointless task, as you just use auto filter on the invoice paid column on sheet 1, but the original is a much larger document, with more fields than in this example, and sheet 2, will form part of a printable report page, hence why i want it to be auto populating!
So, if a Y appears in column E, that row is not copied over.
Sounds simple, probably is, however, its needs to be a "living" table, so when an invoice is paid, and the Y is put on sheet 1, it is removed from the table on sheet 2, and everything shifts up, leaving no gaps etc.
Hope that makes sence.
Sheet 1
Client Ref Number | invoice number | Invoice Date | invoiced amount | invoice paid | |||
<tbody> </tbody> | 1 |
<tbody> </tbody> |
<tbody> </tbody> | y | |||
<tbody> </tbody> | 2 |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> | 3 |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> | 4 |
<tbody> </tbody> |
<tbody> </tbody> | y | |||
<tbody> </tbody> | 5 |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> | 6 |
<tbody> </tbody> |
<tbody> </tbody> | y | |||
<tbody> </tbody> | 7 |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> | 8 |
<tbody> </tbody> |
<tbody> </tbody> | y | |||
<tbody> </tbody> | 9 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Sheet 2, what I want anyway, is the same as above, but without CUS1, CUS4, CUS6 and CUS8 as they have the paid marker, but should I enter the paid marker (on the live table on sheet 1) into CUS7, for CUS7 to auto remove from the sheet 2 table, and everything move up.
and yes, I know this may sound a pointless task, as you just use auto filter on the invoice paid column on sheet 1, but the original is a much larger document, with more fields than in this example, and sheet 2, will form part of a printable report page, hence why i want it to be auto populating!