+ Reply to Thread
Results 1 to 3 of 3

In a summary sheet return a location wise values in number of each equipment quantity

  1. #1
    Forum Contributor
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    131

    In a summary sheet return a location wise values in number of each equipment quantity

    Hi,


    Required a formula help to in a summary sheet return a location wise values in number of each equipment quantity from as based on date wise various sheets.

    Sample results (highlighted area) are enclosed for the reference.


    Thanks,
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: In a summary sheet return a location wise values in number of each equipment quantity

    1. Make sure that the location spellings are IDENTICAL. they weren't.

    2. Paste this formula into the top left of each shaded block, and change the bits in red appropriately.

    =INDEX(INDIRECT("'"&TEXT($B$2,"dd.mm")&"'!B6:E10"),MATCH($A6,INDIRECT("'"&TEXT($B$2,"dd.mm")&"'!A6:A10"),0),MATCH($B$3,INDIRECT("'"&TEXT($B$2,"dd.mm")&"'!B3:E3"),0)+COLUMNS($B6:B6)-1)
    3. Copy across and down.

    4. Done for all four blocks in the sample.
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 04-17-2021 at 03:14 AM.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    131

    Re: In a summary sheet return a location wise values in number of each equipment quantity

    Many thanks glenn for the formula solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extract and return a values in a summary sheet from various sheets.
    By Mohammad Munawar in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-17-2020, 11:53 AM
  2. VBA to Create weekly & Monthly wise summary with change shown in another sheet.
    By KumarPK in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 02-05-2016, 04:17 AM
  3. Copy over to summary sheet if quantity exists in column
    By IT_Worx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2015, 12:22 PM
  4. [SOLVED] Filter single criteria across all worksheets and return values to a summary sheet
    By shreeja178 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2014, 10:05 AM
  5. vba code for automating branch wise day wise amount to summary file
    By pranithpm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2014, 04:18 AM
  6. Replies: 0
    Last Post: 07-22-2013, 11:46 AM
  7. Consolidating Equipment Sheet to Summary Sheet
    By dtmcnamara in forum Excel General
    Replies: 1
    Last Post: 12-07-2012, 11:02 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1