Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've got 3 sheets with date columns like below:
ColumnE ColumnJ -------- -------- 3.31.04 10.1.03 11.26.03 11.30.04 7.28.03 12.09.03 12.31.03 1.30.03 3.30.05 7.11.03 12.31.03 7.29.03 3.31.03 8.31.04 1.04.03 6.20.03 9.30.05 12.25.02 12.31.04 11.30.05 9.13.03 10.10.03 9.19.05 7.22.03 6.19.03 2.28.04 10.6.03 12.31.03 10.15.03 8.31.04 12.15.03 3.31.04 8.26.03 10.31.04 7.30.03 10.31.04 4.1.03 Now, I need to iterate through the columns and check to see if the date in the cell is <30 days from today. Then I want to copy the info in Columns A, E and J for that particluar row to a new sheet created. This needs to be done for each of 3 sheets in the workbook. How would I do that? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Loop Until LDate Column Date | Excel Discussion (Misc queries) | |||
Loop Column | Excel Discussion (Misc queries) | |||
loop thru column and highlight the rows | Excel Discussion (Misc queries) | |||
VBA loop cells | Excel Programming | |||
How to loop through cells in macro | Excel Programming |