Loop to check cell formats and values

Hi

I need to create a loop to check if a cell is Italic and if so if the value is less than 5. If excel finds this in a specified range (in the attachment columns H -> end), I need it to copy the entire row, paste it on a new page, then continue from the next row.

I've added a sample of the data it needs to check.... but I'm lost as to how to start. any help would be appreciated!

This takes a bit of time because it is a brute force approach (about 15 seconds on my machine). I got 112 rows copied upon completion.

Just be sure ws1 and ws2 in the first couple lines of code match the names of your desired input and output sheets, respectively.

And to change the column that it starts to look at, change the j = 8 to whatever column number you want (Column H is the 8th column, per your original post).

Please Login or Register  to view this content.

I had to also change OpenRow to 3 so it starts below some column headers I have on the new sheet, but otherwise this seems to work great thanks!

You're welcome, and thanks for the reputation.