I am having the hardest time searching google with the correct keywords for my issue. Or maybe it simple cannot be done, but here goes:
In worksheet X I keep records of all my sent out invoices. In column A it simply says TRUE or FALSE. TRUE means the invoice was paid. FALSE means it is unpaid. Column B shows the days past the due date.
In worksheet Y I am building a dashboard which will include a table showing the top 10 unpaid invoices (ranked by how long they are overdue). The Top 10 table includes the amount due, due date, and the FALSE value that I mentioned above (FALSE meaning unpaid). So far this is doable in Excel.
But now I am wondering. If a customer pays his bill. Can I somehow make a change to the Top 10 table directly? Could I there change the FALSE value (change it to TRUE) and by doing so also change the corresponding FALSE value in worksheet X?
I have a strong suspicion that this cannot be done in Excel. But I am not that familiar with all Excel's functionalities. So maybe there is a way to do this?
In worksheet X I keep records of all my sent out invoices. In column A it simply says TRUE or FALSE. TRUE means the invoice was paid. FALSE means it is unpaid. Column B shows the days past the due date.
In worksheet Y I am building a dashboard which will include a table showing the top 10 unpaid invoices (ranked by how long they are overdue). The Top 10 table includes the amount due, due date, and the FALSE value that I mentioned above (FALSE meaning unpaid). So far this is doable in Excel.
But now I am wondering. If a customer pays his bill. Can I somehow make a change to the Top 10 table directly? Could I there change the FALSE value (change it to TRUE) and by doing so also change the corresponding FALSE value in worksheet X?
I have a strong suspicion that this cannot be done in Excel. But I am not that familiar with all Excel's functionalities. So maybe there is a way to do this?
