Hi.

How to write an Excel formula that will retrieve Today's (3/18/21) current information of goods sold based on Column A catergory of goods. On another sheet I only want to retrieve =Today() amounts sold items from master sheet.

thank you.

The "Master Sheet" is the photo here that I update daily.

Now I need a new worksheet tab that will only have Today's information in it after I update the daily "Master Sheet".

Imagining a single Column in the new sheet that will automatically pull in the Amounts from the 'Master Sheet' based on the Current Day. Thank you.

e Home insert Page Layout Formulas Data Review View X cut Calibn 2. W LCopy 14 AA = CAE Format Painter Me Clipboard pont Alignment 3/18/2021 A B C E Catergory of Goods 3/16/2021 3/17/2021 3/18/2021/3/19/2021 Rice $ 4,577.00 $ 66.00 $1,224.00 Bread $ 978.00 $ 546.00$ 789.00 Potatoes $ 386.00 $ 112.00 $ 451.00