Posts by Santoshi Para

    I'm trying to write a formula that will transfer data from one sheet to another within a specific date range that will be entered on the sheet the data will be copied.

    The formula would be similar to a SUMIFS, instead of summing the range of data it would just copy the range of data to the new sheet. If excel had a COPY formula it would look like this:

    =COPYIFS(Daily!B6:F4753, Daily!A6:A4753, ">=" & I3, Daily!A6:A4753, "<=" & K3)

    1st Sheet = Daily

    Column A = Dates

    Columns B to F = data to be transfered

    Cell I3 on Sheet2 = Start Date

    Cell K3 on Sheet2 = End Date

    The formula would be entered into cell B6 on Sheet2.

    Basically I want to have a master daily list, then be able to choose a specific date range on the 2nd sheet, and have the data only in that range transfer to the 2nd excel sheet.