VBA Formula in cells by condition

Hi!!!

Can anyone help me creating a VBA code?


1) I import a list of numbers to column K (the size of that list is random)

2) For each Cell in Column K with a number i need a VBA code that in column L create a formula "K2*100/E2"


because of the random size of the list i need to have this kind of code.

My English is not so good Sorry :)

Thanks in advance

Miguel

Welcome to the forum. :)

Start by using the macro recorder. Turn it on, perform the actions and then view the code. It will give you an idea about the objects, properties and methods involved. Once you have some recorded code, post it on this thread and we will help you adjust it so that it can handle the changing number of rows. ;)

Hope that helps...