Great ... !!!
However, this new approach will require to start all over and rebuild a solution from scratch ... especially if your are dealing with several workbooks ...
By the way, how many criteria are to be taken into consideration ...
it seems to me you have left the simplistic and trivial " 2-criteria-territory" ...
I made better sample file in how the setup is in the original file.
I also put some extra info in the overview-sheet.
again thank you for your help, I really appreciate it.
Thanks a lot ...!!!
As soon as I have a moment, will look into the specifics of your situation ...
OK ... Back to the basics ...
1. The Source of all your Data is "Production Reports"
2. The Destination is an Analysis in sheet "Overview"
Can you re-build this sheet so that it fully answers your needs ?
If Yes, can you explain all the aspects of your Objective ?
describe all the obstacles, complications you are facing ...
Among the possible solutions to completely redesign your Overview:
1. Have you considered Inserting a Pivot Table ?
2. Have you considered using the Advanced Filter feature ?How to Set Up Excel Advanced Filter Criteria - Exampleswww.contextures.com
I will make a sample file in how the setup is now, with the formula's
I just have to delete / change the sensitive information.
For your questions
1) Yes, the Production Reports sheet is the source for ALL the info.
2) Yes, the Overview sheet is the main analysis sheet used for daily and weekly overview.
I will put as much as possible info in this sheet.
I have thought about Pivot tables, but not all users are familiar with excel, the setup that I have now is just the better one. Simple choose the first monday of the week and your overview will show all your info. Nice organised.
Same goes for the advanced filter.
If possible would like to keep the same setup, but if that is not possible, than it is what it is.
Adjustments to make it more user friendly can always be done later.
The information is more important.
I do have to make the sample file in the weekend.
Quite honestly, even for Users who are not familiar with Excel, the basics of a Pivot Table are extremely simple ...
Hope you are doing well?
Just a quick follow up, did you have a change to look into my problem?
I know you said you would have a look at it when you had some time left, so please don't think I am asking this so that you may speed up the process.
I really appreciate your help.