Need to write a formula to get data from another worksheet based on the date

Question

HI ,&nbsp;I need help to write a formula to get my worksheet done.there are two sheets in my worksheet "Day Production" and "Summary" I need to get all the information to the summary sheet which I entered into the day production sheet based on the given date at the top.&nbsp;and this must be under table format to use slicers&nbsp;I've attached my worksheet. can anyone write a formula in the attachment itself?

patrick2788 · Answer

RavinduEB&nbsp;There's an issue with the way the workbook is arranged.&nbsp; &nbsp;To take advantage of dynamic arrays, the Summary sheet must not be pre-formatted as table (Tables are dynamic in nature and expand when data is entered in the immediate perimeter but the do not play well with spilling). Naturally, converting it to a range also takes a way slicers.&nbsp;My solution utilizes FILTER to fetch records based on the input date.&nbsp;=LET(
    header, DayProduction[#Headers],
    filtered, FILTER(DayProduction, DayProduction[Date] = Input, "None found"),
    VSTACK(header, filtered)
)&nbsp;&nbsp;

Forum Discussion

Need to write a formula to get data from another worksheet based on the date

Share

Resources