• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Picking up values from various sheets in a workbook to a summary sheet

Hey,

I have to make a summary of the amounts located in various different sheet to a common summary sheet, all sheet has its own summary, but manually linking is cumbersome task for more than 100 branches.
Have tried to prepare the format on what data I need to make.
Please if anyone could suggest some formula or help me on the sample attached.

Thanks
 

Attachments

  • Sample file.xls
    32 KB · Views: 1
Hey Thanks Luke,
the problem is this is a software generated data set.
However is there any formula to pick up the data from summary part only,
 
It would be hard. Would you mind going in your sample and filling in manually which cells the summary should be looking at, so I know where to pull?
E.g.,
=SUM(Branch1!M7:M10)
 
I made the summary manually in this sample, to make it clear what data we need to pull in summary sheet.
I hope this works out, else have to go through hard way to make changes :p

Thanks Luke
 

Attachments

  • Sample file.xls
    32.5 KB · Views: 0
I think I found a solution. It's ugly and volatile (meaning it causes sheet to recalculate every time you make a chance), but it works. :)
 

Attachments

  • Sample file LM.xlsx
    19 KB · Views: 0
Back
Top