| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find data between dates
I have a macro that is designed to look for dates on one sheet in cells A1
and A2 then match that to dates on another sheet in colum D before putting all the information into a third sheet. I have this macro j = 1 For i = 1 To Sheets("Grades").UsedRange.Rows.Count If (Sheets("Grades").Cells(i, 3) = Sheets("Monthly reporting").Cells(1, 1) And Sheets("Grades").Cells(i, 1) <= Sheets("Monthly reporting").Cells(2, 1)) Then Sheets("Grades").Rows(i).Copy Sheets("Grade calc").Rows(j) j = j + 1 End If Next i and it is not working. Any suggestions |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumifs with data and dates - I can not figure out the dates | Excel Worksheet Functions | |||
| compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
| For Next does not find dates? | Excel Programming | |||
| How do I find the earliest dates in a range of dates? | Excel Worksheet Functions | |||
| Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel | |||
Threaded Mode
