Hi! I'm a novice on excel trying to auto-populate some cells.
I have a row with dates (going weekly) and I want to be able to return specific cells under these dates if today's date fall under the week displayed.
Ex: I want to return the data in F9 to A11 and F11 to B11 since we are in the week of Oct 28 and there are items in the cells under it. Now if we move from the week of Oct 28 to Nov 4, I'd like the formula to retun what is in G9 to A11 and blank out B11, C11 and D11 since there is nothing there for that week.
Please see attached example file. Thanks everyone for helping me out with this![]()
Bookmarks