Forum Discussion
Date/Data referencing
I am building a spreadsheet for work. My first sheet is an overview and my second sheet is my user input data. The idea is for me to input data everyday into the sheet (each day has a different row) ...
With that limited information it is very difficult. Attaching a sample workbook or uploading it to a cloud share like sharepoint would be best or at least giving specific examples. for example you don't even include your current formula.
that all said, I first want to commend you on your set up as it sounds like it is well done (have single source data and separate presentation/overview page)
it sounds like you need to use XLOOKUP or FILTER functions