Create Loop for an if function

[paljako]

Hi Everyone!

I have this excel sheet where I want to be able to extract data from an exact year. The data i wan't to extract is listed in column T and the year in column U. I want to copy the data value to column x

I have made this macro, and it works. But there must be some kind of loop that can tell the macro to do the same operation for each cell, so I don't have to write each operation manually.


this is the macro(I have made the operation manually for three cells):

Please Login or Register  to view this content.

If anyone knows how to get a "insert box" to specify the value in the if function(In this case it's 11) I would also be veeery happy!

[Kyle123]

maybe:

Please Login or Register  to view this content.

[paljako]

It works just fine! Thank you!!

[Kyle123]

Great

Please mark your thread as solved