Excel VBA for if less than, greater than value and paste in new sheet

[kevinloh]

Hello people,

Basically I want to create a macro that basically checks if there exist a value in the row and compare it to a limit value in one of the cell . If there exist value greater than the limit value (Grenzwerte) and paste the whole row while maintaining months and year integrity in a new sheet and then it goes to the next set of row checks again and then paste it in another row not overwriting the previous. until it reaches the end.

Thanks.

Below is the actual file

Test.xls
Kevin

[Richard Buttrey]

Hi,

The first difficulty is that your data is not consistent. You have a mixture of real numbers and text like <0.05 in columns E,G&H

If you can have them all entered as true numbers then you can use a helper column to test whether the number is > the maximum. Once you have this helper column you can use it in an AutoFilter and once filtered you can copy the filtered rows to another sheet.

[kevinloh]

Thank you for the feedback, for this time just ignore the operators and text and assume just the number. Now I want to create a macro probably in VBA that does the abovementioned. This is so that I can make a control box and apply accordingly if values are under or above the reference limit.

It is also worth mentioning that this table has to be scalable in the future and the vba code must check for all cells in the row for different months/year.