Daily Report with today's date

Welcome to the forum!

If I'm understanding the goal correctly, you can achieve your report by copying your headers onto a new sheet, then using the following formula in A2 of sheet2 - the formula should be array entered (confirmed with Ctrl + Shift + Enter instead of Enter):

=IFERROR(INDEX(Sheet1!$A$2:$C$20,SMALL(IF(Sheet1!$C$2:$C$20=$G$1,ROW(Sheet1!$C$2:$C$20)-ROW(Sheet1!$C$2)+1),ROW(1:1)),MATCH(A$1,Sheet1!$A$1:$C$1,0)),"")

Fill it right and down beyond what you'll need and it should auto-update as the date changes or as you add entries to sheet1.

The formula as I've written it only looks through row 20 on your main list on sheet1. If you expect more than 20 rows of data on sheet1, then change the "$20"s in the formula to something much bigger. The formula also looks to cell G1 on sheet2 for the date, which can be supplied with the TODAY() function. If you want, you can replace the "$G$1" in the formula with "TODAY()" and eliminate the need for cell $G$1, but I strongly recommend using the current setup, which will allow you to easily lookup past or future dates simply by changing G1, rather than having to change the formula.

Take a look at the attachment to see if it will work for you.

Hello CAntosh,

Thank you so much for your reply. When I type in the formula and enter it pops up the file explorer (pic attached). I know you mentioned that the formula should be array entered? Can you please advise as to how to proceed? Terror1.JPG

To array-enter a formula, instead of hitting enter once the formula has been typed/copied in, hold Control and Shift and then hit Enter. If you were successful, you should see brackets like {this} automatically appear around the formula. In the attachment in post #2, when you click on A2, you should see brackets around the formula - I didn't type those brackets, they are there to indicate that the formula was array entered.

I don't know why the file explorer is popping up, but my guess would be that your sheet names don't match the sheet names used in the formula. My formula assumes that your main data sheet is called Sheet1. If it isn't, change your main sheet's name to Sheet1 or change the "Sheet1" parts of my formula to match the actual sheet name.

Hopefully that helps?

That normally happens when a sheet name being referenced in a formula, does not exist in that file. If the sheet name does exist, check for spelling/typos and for leading/trailing spaces