Writing Macro to Pick Rows from Updating Spreadsheet

[TheJackal26]

Hey all, I've been struggling with this one for the past few days. I wrote a userform that people can use to input data in real time to a spreadsheet. However, I am trying to write a macro (or if there's an elegant function even better) that would allow me to extract all the entries from today's date in real time to a different sheet. I tried the query and filter function but couldn't seem to figure them out.

Does anyone have any suggestions or done anything similar that would jog the imagination? Thanks!

 

[DanteAmor]

Hi and welcome to MrExcel

Assuming the following, the data starts in cell A1, the dates are in column 1, the sheet with data is sheet1 and the target sheet is sheet2, then:

Sub CopyToday()
  With Sheets("Sheet1")
    .Range("A1").AutoFilter 1, xlFilterToday, xlFilterDynamic
    .AutoFilter.Range.EntireRow.Copy Sheets("Sheet2").Range("A1")
    .ShowAllData
  End With
End Sub