I need formula (no macros) to populate data from tab to another as cell changes

%3CLINGO-SUB%20id%3D%22lingo-sub-1658401%22%20slang%3D%22en-US%22%3EI%20need%20formula%20(no%20macros)%20to%20populate%20data%20from%20tab%20to%20another%20as%20cell%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1658401%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20with%20a%20formula%20that%20will%20pull%20data%20from%20my%20Client's%20tab%20(when%20the%20column%20cell%20is%20changed%20to%20%22needs%20drawings%22)%20into%20my%20Daily%20Tasks%20tab.%20There%20will%20be%20hundreds%20of%20entries%20and%20the%20cell%20will%20change%20for%20each%20client%20as%20the%20sales%20cycle%20progresses%3B-%20they%20will%20not%20change%20in%20any%20order%20of%20row.%20Attached%20is%20an%20example%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1658401%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1658652%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20formula%20(no%20macros)%20to%20populate%20data%20from%20tab%20to%20another%20as%20cell%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1658652%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F790598%22%20target%3D%22_blank%22%3E%40Chrislawsin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20a%20file%20with%20a%20formula%20that%20I%20believe%20will%20do%20what%20you're%20looking%20for%2C%20but%20have%20you%20considered%20just%20filtering%20the%20Client%20list%20for%20%22Needs%20Drawings%22%20(Data%20tab%2C%20Filter%20button)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

I need help with a formula that will pull data from my Client's tab (when the column cell is changed to "needs drawings") into my Daily Tasks tab. There will be hundreds of entries and the cell will change for each client as the sales cycle progresses;- they will not change in any order of row. Attached is an example

2 Replies

@Chrislawsin 

 

I've attached a file with a formula that I believe will do what you're looking for, but have you considered just filtering the Client list for "Needs Drawings" (Data tab, Filter button)?

 

 

 

 

 

@Chrislawsin 

These days

= FILTER( clientData, Tasks="Needs Drawings", "None")

returns the extracted data as a single array, sized by the data.