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.



    Thanks