Formula to pull data from multiple sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1657926%22%20slang%3D%22en-US%22%3EFormula%20to%20pull%20data%20from%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1657926%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20primary%20sheet%20that%20pulls%20from%20individual%20sheets%20to%20track%20a%20jobs%20progress.%20I%20am%20looking%20for%20a%20way%20to%20take%20the%20individual%20sheets%2C%20look%20for%20a%20foreman's%20name%20within%20a%20window%20of%20dates%20(1%20week%20at%20a%20time)%20and%20compile%20that%20for%20weekly%2Ffinal%20totals.%20The%20variables%20will%20be%20the%20dates%20and%20the%20foreman%20in%20question.%20Some%20of%20our%20projects%20have%20upwards%20of%20150%20individual%20items%20that%20will%20be%20worked%20on%20as%20needed%2C%20so%20they%20wont%20have%20anything%20for%20weeks%2C%20then%20several%20weeks%20in%20a%20row%2C%20then%20nothing%20again.%20Let%20me%20know%20if%20you%20need%20more%20clarification%2C%20I%20know%20what%20I%20want%20in%20my%20head%2C%20just%20not%20sure%20if%20its%20coming%20out%20correctly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERyan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1657926%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-1658085%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20pull%20data%20from%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1658085%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F790518%22%20target%3D%22_blank%22%3E%40Ryan_Winkelman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethere%20is%20a%20web%20page%20below%20where%20you%20can%20find%20similar%20solution.%20It%20is%20in%20Turkish%20however%20you%20can%20translate%20it.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fexcelileharikalar.com%2Findex.php%2F2020%2F02%2F09%2Fcok-sayfada-duseyara%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fexcelileharikalar.com%2Findex.php%2F2020%2F02%2F09%2Fcok-sayfada-duseyara%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello All,

 

We have a primary sheet that pulls from individual sheets to track a jobs progress. I am looking for a way to take the individual sheets, look for a foreman's name within a window of dates (1 week at a time) and compile that for weekly/final totals. The variables will be the dates and the foreman in question. Some of our projects have upwards of 150 individual items that will be worked on as needed, so they wont have anything for weeks, then several weeks in a row, then nothing again. Let me know if you need more clarification, I know what I want in my head, just not sure if its coming out correctly.

 

Ryan

1 Reply
Highlighted

@Ryan_Winkelman 

 

there is a web page below where you can find similar solution. It is in Turkish however you can translate it.

http://excelileharikalar.com/index.php/2020/02/09/cok-sayfada-duseyara/