Event Master - Automatic Data filling.

[anujteetwal]

Dear All,

i have made a dashboard where i am trying to show upcoming events in a particular month. my data base is ready where i am adding daywise events.

i need autofilling of events in table (M8:N28) Yellow highlighted area, when i chose particular month. Also i want to highlight the date in calendar if there is any event on that date.

pls guide. Event Master.xlsx

[FDibbins]

1. I would just use a regular dropdown for the month selection, it makes it easier to reference (I used E2 and H2)
2. Complete the month listing in col R, ou have some months left out, as well as unnecessary gaps
3. add a helper column to Data base (I used A) to help ID those entries you want to use...
A3=AND(C3>=DATEVALUE(1&Dashboard!$E$2&Dashboard!$H$2),C3<=EOMONTH(DATEVALUE(1&Dashboard!$E$2&Dashboard!$H$2),0),D3<>"")
copied down

Then for the extract in the yellow table...
M8=IFERROR(INDEX('Data Base'!C:C,SMALL(IF('Data Base'!$A$3:$A$241=TRUE,ROW('Data Base'!$B$3:$B$241)),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
copy down, then copy across as needed.

[anujteetwal]

Attachment 656851

Thanks Ford , i did try this. its doesnt work, may be i did mistake. can you please add the same in my excel.

[FDibbins]

Here is your original file, with my additions.

[FDibbins]

I looked at your 2nd file.

1. you did not put the dates in regular dropdowns like I suggested, so the helper in Data Sheet wont work.
2. in the formula in that helper, it seems you added =A3 to my suggestion. That will also cause an error
3. In the Dashboard sheet, you added =M8 to my formula, ans also did not enter is as an ARRAY formula, as I said it needs to be