Excel vba: data processing

snowman.hk · November 6th, 2009, 03:38 AM

I'd like to use vba to process a large data set

, from cell A1 to L60000, my problem is: i hope to remove irrelevant record with some criteria:

weekday(column b)>5 : remove
vlookup to another file for the group
for group A & C, if not 9am<time value in column c< 5pm : remove
for group B, if not 9am<time value in column c< 6pm : remove

Quote:

Sub Comm_prepare_data()
Range("m1") = "Weekday"

Range("m2") = "=weekday(b2,2)"
Range("M2").AutoFill Destination:=Range("M2")

For Each Data In Worksheets("Sheet1").Range("m2:$0").Cells
If (Data.Value) > 5 Then ???
Next

What should i do??

Shasur · November 6th, 2009, 05:56 AM

Hi

The best option would be to use ADO in Excel and query for the criteria

Cheers
Shasur