Prof. Dr
I have a file consisting of sheet 1 and sheet 2
The data in Sheet 2 is taken from Sheet 1, except for the business statement in Sheet 2, in which I write the items and work on them in Sheet 1
In the table, find the last value of a specific name from a previous quantity and a current quantity, so you will automatically download it
Both past and present quantity
But if I need to do a filter in Sheet 1 on Gary 10
You need everything that happened in the filter to appear in Sheet 2
It shows me a previous and current amount based on the filter
When I remove the filter, it shows me the last values in all equations
Thank you very much for your presence
I have a file consisting of sheet 1 and sheet 2
The data in Sheet 2 is taken from Sheet 1, except for the business statement in Sheet 2, in which I write the items and work on them in Sheet 1
In the table, find the last value of a specific name from a previous quantity and a current quantity, so you will automatically download it
Both past and present quantity
But if I need to do a filter in Sheet 1 on Gary 10
You need everything that happened in the filter to appear in Sheet 2
It shows me a previous and current amount based on the filter
When I remove the filter, it shows me the last values in all equations
Thank you very much for your presence