Weekly changing roster to track changes while maintaining data regarding completed assessments.
Alright, I will try to explain this as clearly as i can.
There is a constant movement of clients in and out of my job. I need to track whether or not an assessment has been done for each client, but the population is constantly fluctuating.
There is a weekly roster that comes out to compare last week's clients to this week's.
What I would like to do is take information from spreadsheet W (the weekly roster sent out), and update spreadsheet T (the one to track my assessments).
The attached picture is spreadsheet T. The yellow highlight on the "Old List" indicates that the assessment is done, the "New List" was directly pasted from spreadsheet W.
Column K is as far as I got with conditional formatting as the formulas is:
=IF(ISERROR(MATCH(I3:I113, C3:C113, 0))=TRUE, "New", "Old")
I want to the highlight to automatically transfer over to the "New List" and then going forward that would be copy/pasted to the "Old List" the following week.
[link] [comments]
Want to read more?
Check out the full article on the original site