Home

Formula Help Required Please!! Possible Array?

%3CLINGO-SUB%20id%3D%22lingo-sub-654712%22%20slang%3D%22en-US%22%3EFormula%20Help%20Required%20Please!!%20Possible%20Array%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-654712%22%20slang%3D%22en-US%22%3E%3CP%3E%3CBR%20%2F%3EHi%20All%2C%3CBR%20%2F%3E%3CBR%20%2F%3ELooking%20form%20some%20help%20here%20with%20a%20formula%2C%20not%20sure%20where%20to%20begin%20to%20be%20totally%20honest.%3CBR%20%2F%3EI%20have%20a%20workbook%20that%20has%20multiple%20tabs%20which%20relate%20to%20different%20sites%20on%20a%20contract.%3CBR%20%2F%3ESite%20101%3CBR%20%2F%3ESite%20102%3CBR%20%2F%3ESite%20103%3CBR%20%2F%3EThe%20sites%20are%20all%20on%20one%20tab%2C%20the%20%E2%80%98Summary%E2%80%99%20tab%20is%20on%20a%20different%20tab.%3CBR%20%2F%3E%3CBR%20%2F%3EEach%20site%20has%20different%20services%20and%20different%20staff%20working%20there.%20The%20services%20are%20Security%2C%20Cleaning%20%26amp%3B%20Catering.%3CBR%20%2F%3EI%20have%20n%20%E2%80%98Summary%E2%80%99%20tab%2C%20which%20displays%20the%20information%20at%20each%20site.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20%E2%80%98Summary%E2%80%99%20tab%20provides%20an%20overview%20of%20each%20service%20%26amp%3B%20employee%20info%2C%20that%20is%20delivered%20across%20the%20whole%20contract%2C%20each%20site%20may%20have%20different%20services.%3CBR%20%2F%3ESo%20the%20summary%20tab%20looks%20like%20this%3A%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20754px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116418i712690F6F13EDB7E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22EX2.png%22%20title%3D%22EX2.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20type%20in%20the%20site%20code%20into%20the%20summary%20tab%2C%20I%20need%20it%20to%20pull%20through%20the%20information%20from%20that%20site%20and%20populate%20the%20summary%20tab.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20site%20list%20looks%20like%20this%3A%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20676px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116421iC72DDDB35E109D26%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22EX1.png%22%20title%3D%22EX1.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI.e%20If%20Site%20101%20has%20Security%20only%2C%20then%20the%20employee%20name%2C%20number%20pay%20rate%20and%20hours%20for%20those%20security%20staff%20at%20site%20101%20will%20populate%20the%20security%20section%20of%20the%20summary%20tab.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20site%20102%20has%20Security%20and%20Catering%2C%20then%20the%20employee%20name%2C%20number%20pay%20rate%20and%20hours%20for%20those%20security%20and%20catering%20staff%20at%20site%20102%20will%20populate%20the%20security%20section%20and%20the%20catering%20section%20of%20the%20summary%20tab.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20this%20possible%3F%3CBR%20%2F%3EThanks%2C%20JD.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-654712%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
JD2301
Occasional Visitor


Hi All,

Looking form some help here with a formula, not sure where to begin to be totally honest.
I have a workbook that has multiple tabs which relate to different sites on a contract.
Site 101
Site 102
Site 103
The sites are all on one tab, the ‘Summary’ tab is on a different tab.

Each site has different services and different staff working there. The services are Security, Cleaning & Catering.
I have n ‘Summary’ tab, which displays the information at each site.

The ‘Summary’ tab provides an overview of each service & employee info, that is delivered across the whole contract, each site may have different services.
So the summary tab looks like this:
EX2.png

 

When I type in the site code into the summary tab, I need it to pull through the information from that site and populate the summary tab.

The site list looks like this:
EX3.png

I.e If Site 101 has Security only, then the employee name, number pay rate and hours for those security staff at site 101 will populate the security section of the summary tab.

If site 102 has Security and Catering, then the employee name, number pay rate and hours for those security and catering staff at site 102 will populate the security section and the catering section of the summary tab.

Is this possible?
Thanks, JD.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies