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) and it automatically references that data in the overview page. I have made it reference the data for day 1 but I would like to be able to change the date on the overview page and have it automatically reference the date for that corresponding date on the input sheet.
2 Replies
Here you will get an idea to collect information from other sheet to dashboard sheet using formulas.
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
