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:

Sub summarize_Stock()
' summarize_Stock Macro
Dim arNames As Variant
Dim lngCtr As Long

arNames = Array("AAPL", "AMZN")

For lngCtr = LBound(arNames) To UBound(arNames)
  Sheets("Stock_Price").Range("A2").Value() = arNames(lngCtr)
  Calculate
  Sheets("Summary").Cells(2 + lngCtr, "B").Resize(1, 2).Value = Sheets("Stock_Price").Range("L41:M41").Value
Next lngCtr
End Sub

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