Hi all,
I have a workbook from which I'm trying to copy the entire row IF the date matches the date I'm working with. Below is a section of my code - certainly not the best way to do this, but I've been trying to iterate and teach myself what and how it works and improve it as I go along. However, this particular bit of code only copies the same row (there's multiple rows with the matching date) over and over again instead of moving through the column (column A is where the dates are).
With wb2
For Each Cell In ws2.Range("A1:A10000")
If Cell.Value = activeDate Then Cell.EntireRow.Copy Destination:=ws3.Range("A:A")
Next
End With
Any help here would be appreciated
Thanks all!
I have a workbook from which I'm trying to copy the entire row IF the date matches the date I'm working with. Below is a section of my code - certainly not the best way to do this, but I've been trying to iterate and teach myself what and how it works and improve it as I go along. However, this particular bit of code only copies the same row (there's multiple rows with the matching date) over and over again instead of moving through the column (column A is where the dates are).
With wb2
For Each Cell In ws2.Range("A1:A10000")
If Cell.Value = activeDate Then Cell.EntireRow.Copy Destination:=ws3.Range("A:A")
Next
End With
Any help here would be appreciated
Thanks all!