Home > Forum Home > Excel Project Management Template > Transfer data from one sheet to another automatically | Share |
Forum Topic | Post Reply Login |
Transfer Data From One Sheet To Another Automatically | Rate this: (3/5 from 1 vote) |
Hello, 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, | ||
Thanks, | ||
Posted by Santoshi on |
Replies - Displaying 1 to 1 of 1 | Order Replies By: Most Recent | Chronological | Highest Rated |
Rate this: (4.3/5 from 3 votes) You could record one first then edit. Visible cells are under Find & Select far right of Home tab menu. | |
Excel Business Forums Administrator | |
Posted by Excel Helper on |
Displaying page 1 of 1 |
Find relevant Excel templates and add-ins for Transfer data from one sheet to another automatically in the Excel Business Solutions Directory |