I am working with a large spreadsheet that has many tabs across the bottom (a new tab for each day).
Column A has specific accounts (more than 100+ rows). Colum DJ is the column I need to review daily to see if the specific task in DJ has been completed. Once the task has been done that day I put an X in that row for DJ. Is there a formula that can be easily applied so that when I add the new tab each day for the new daily sheet that it will pull from the previous tab (yesterdays report) to pull any that already have an X with that specific account? I do not need the date it was completed but I just need to know if it was completed and I need the formula to always pull from the previous tab, not from one specific master tab.
Column A ---------- Column DJ lists task to be completed
Account A X (task complete)
Account B
Account C
THANK YOU!!!
Column A has specific accounts (more than 100+ rows). Colum DJ is the column I need to review daily to see if the specific task in DJ has been completed. Once the task has been done that day I put an X in that row for DJ. Is there a formula that can be easily applied so that when I add the new tab each day for the new daily sheet that it will pull from the previous tab (yesterdays report) to pull any that already have an X with that specific account? I do not need the date it was completed but I just need to know if it was completed and I need the formula to always pull from the previous tab, not from one specific master tab.
Column A ---------- Column DJ lists task to be completed
Account A X (task complete)
Account B
Account C
THANK YOU!!!
