Activities completed by date - having to manually update dates from another worksheet

Hi all,

I'm not advanced in Excel by any means - apologies on the vague title.

In short, within this workbook, I have a sheet titled 'Worklist' - source of where the data for the attached tables is located. Every couple of weeks, I update the dates (A4, E4, I4 - etc) to ensure that they're aligned with what's in the Worklist sheet. With the formulas I've created for each respective team (example F7), I'd like Excel to look at the date in E4 and then in F7, populate data for the activities that have been completed in the Worklist for this specific day. Currently, I'm completing this manually for each team / each day which is a pain.

Appreciate your assistance with this

example.jpg

try in B5 formula
"Team 1" change to $A5
"date" to $A$4
and drag it down to B15
the rest suitably

is that what you want?

Originally Posted by sandy666

try in B5 formula
"Team 1" change to $A5
"date" to $A$4
and drag it down to B15
the rest suitably

is that what you want?

Thank you so much - you're a superstar!!

FDibbins - apologies, I'll know for next time, appreciate the heads up.

you are welcome
don't forget mark thread as solved. thank you