Hi, I have a project to accomplish, in which I must read and compare the values of some cells for example from f11 to f 100 with a certain number lets say 10 and then the cells that their values is greater than 10 I would like to compare the cells of another column, for example if I find at the cell F34 a number greater than 10, then I want to check the K34 cell and see if this value is also greater than 10, if so then copy the value fo the F34 cell and paste it to a new workbook to a specific cell for example A2 , then go back and keep checking, if the F51 is greater than 10, then check the K51 cell and if this value too is greater than 10 then copy the value of the F51 and paste it to the new workbook that has been created to the next row A3 and so , on.
The problem is that I want to do with one macro so I can save it and then use the new workbook as an input for the mathlab.
So, please if anyone can help with some code, or give me some instructions I would really, really appreciate it, as I do not have much experiance with programming in VB
Thank you very much.