Home

Pulling specific data from multiple worksheets into one

%3CLINGO-SUB%20id%3D%22lingo-sub-1188156%22%20slang%3D%22en-US%22%3EPulling%20specific%20data%20from%20multiple%20worksheets%20into%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1188156%22%20slang%3D%22en-US%22%3E%3CP%3EOn%20a%20weekly%20basis%20we%20have%207%20reports%20coming%20in%20from%20different%20locations%20and%20we%20compile%20these%20into%20one%20report%20to%20send%20out.%20What%20is%20the%20easiest%20way%20to%20get%20these%20sheets%20to%20automatically%20fill%20the%20master%20sheet%20weekly%3F%20Each%20location%20has%20their%20own%20sheet%20and%20we%20use%20a%20master%20sheet.%20Currently%20we%20just%20manually%20copy%20and%20paste%20the%20information%2C%20but%20there%20has%20to%20be%20an%20easier%20way.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1188156%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1188180%22%20slang%3D%22en-US%22%3ERe%3A%20Pulling%20specific%20data%20from%20multiple%20worksheets%20into%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1188180%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20checkout%20the%20link%20below%20for%20solution%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3DNCzf0_oFO6g%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3DNCzf0_oFO6g%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

On a weekly basis we have 7 reports coming in from different locations and we compile these into one report to send out. What is the easiest way to get these sheets to automatically fill the master sheet weekly? Each location has their own sheet and we use a master sheet. Currently we just manually copy and paste the information, but there has to be an easier way. 

 

 

1 Reply
Highlighted
Hello,

You can checkout the link below for solution

https://m.youtube.com/watch?v=NCzf0_oFO6g
Related Conversations