Hello All,
I have an excel file with 3 users (wound increase too). all sheets have the daily tasks of the users. I want to collate all in a file automatically to have a view on the completed, pending and ongoing tasks appended one below the other. Any help on the formula?
Sample file attached
I have an excel file with 3 users (wound increase too). all sheets have the daily tasks of the users. I want to collate all in a file automatically to have a view on the completed, pending and ongoing tasks appended one below the other. Any help on the formula?
Sample file attached