Hi fellow Excel Masters,
Can you please help me to code this problem to run the macro? (First assignment first question in the attached file).
I need to extract the given values from 1 - 50 (include decimal values) to different columns e.g. 0-5, 5-10, 10-15, 15-20, 20- 25, etc.
This is my effort so far which only address one range as if I use "If" statement for other ranges, it does not work
Dim x As Integer
x = 2
For Each Cell In Range("A1:A1046")
If Cell.Value > 0 And Cell.Value <= 5 Then
Cells(x, 4) = Cell.Value
x = x + 1
Next Cell
End Sub
Much appreciated, guys
Bookmarks