creating a loop in a macro

Hi,

I need help creating a macro that loops the calculations. Currently I have a drop down list in a sheet and I have a macro that picks each individual name calculates the results and then copies and pastes the 2 cells that I need in to a table. This repeats itself dozens of times. I need help that the macro should automatically choose the next name in the table, paste it in the drop down menu, calculate, and paste results in the table, and of course repeat. I’m attaching part of the macro, if anybody can take a look it would be really appreciated.

Can you post the code to the forum as well (for those of us on our phones hah)?

Hi, moshro1,

maybe like this:

Please Login or Register  to view this content.

Although you would be better of if you had attached a sample workbook.

Ciao,
Holger

Hi, moshro1,

if there is a range where the names are located this may be referenced instead of using an array - like I said: no information in the word document available.

Ciao,
Holger