Using Excel 2003
The example is a workbook with 3 sheets
The first is the data base (Up_Down) that has 8 COLS A:H
The second sheet (Up_Dn_Red) I created to extract all the data from sheet one that was with the condition Red and inserted that in COLS A:H
The third sheet (Up_Dn_Blue) I created to extract all the data from sheet one that was with the condition Blue and inserted that in COLS A:H
Then on each of the 2nd and 3rd sheets I extract the data that has the condition that matches weekdays from the COLS A:H and I link that to the next set of 8 COLS starting with Monday at COL J then Tuesday at COL R etc. So if no data for Tuesday that should result in a blank/unpopulated set of cells for COL R::X but if it does then it should increment the row. IE take the latest Tuesday and populate
For now the database (Up_Down) is built by linking to another sheet that is manually input
The (Up_Down_Red and Up_Down_Blue) sheets are built manually
and I would like to find a solution that lookups up the database, and matches the data to then either copy paste or link in the relevant sheets
I suspect I should be looking for an INDEX MATCH solution with ISBLANK? to enable the increment expansion of a new day? and/or even INDIRECT ?
Bookmarks