|
|
#4
10-26-2018, 07:22 AM
|
|||
|
|||
I modified your workbook a bit - look for attached file.
To create a workbook for specific conditions (like specific month) is not very productive. Try design the workbook in a way, which allows to work with single workbook with smallest possible number of sheets for data entry, and with single report sheet for same kind of reports. When you do this, you design a workbook once, and may use it for long time without any changes to design. As example I designed a Report sheet based on your Data sheet (I made some changes there btw.) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| need Index, Match, Max to return SUMPRODUCT? | IRHSAM | Excel | 0 | 11-17-2017 09:48 AM |
| Excel Index and Match function with multiple criteria not searching the next record | mushtaqkadar | Excel | 3 | 06-17-2017 12:20 AM |
 Create a unique list of values that match a criteria, sorted in order of another criteria
|
BradRichardson | Excel | 2 | 01-03-2017 12:25 AM |
|
How to make MATCH/INDEX formula return multiple successive responses.
|
danigirl121 | Excel | 7 | 06-08-2016 01:57 PM |
|
Vlookup or Index/Match - Multiple Criteria
|
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
Windows 8 
Office 2016
Threaded Mode