Help with conditional ongoing merging of multiple spreadsheets
I have 3 sheets. 2 are kept up to date with new activities by different group members. the third I want to capture new entries into the other 2 sheets when certain conditions are met. Is there a way to write a lookup to search for new entries and if found add to third sheet with accompanying information?
The data on the "reference" sheets has a unique identifier per activity and will say the purpose.
For criteria where purpose = test I want the activity copied to the 3rd sheet. As and when it is added to the reference sheets
Is that possible?
Help Article Resources
Check out the Formula Handbook template!