First-time poster and somewhat experienced Excel user.
Using Excel 2010, I have created a drop-down list using Data Validation and a reference to a named range that has a number of city names. I would like to be able to select the first name on the list, calculate the spreadsheet, copy and paste some results to a new output table, then increment to the next name on the list and repeat.
The macro below loops through and copies the result to the cells I want - but the incrementing of the drop-down list is where I am having lots of problems. The incrementing of the drop-down list would occur inside the For..Next loop.
Would definitely welcome any suggestions. Thanks in advance.
CopyDownMacro Macro
Set Regions = Range("regions")
Range("start_cell").Select
For x = 1 To Regions
Range("formula_copy").Select
Selection.Copy
Range("start_Cell").Select
ActiveCell.Offset(x - 1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False
Next x
End Sub
Using Excel 2010, I have created a drop-down list using Data Validation and a reference to a named range that has a number of city names. I would like to be able to select the first name on the list, calculate the spreadsheet, copy and paste some results to a new output table, then increment to the next name on the list and repeat.
The macro below loops through and copies the result to the cells I want - but the incrementing of the drop-down list is where I am having lots of problems. The incrementing of the drop-down list would occur inside the For..Next loop.
Would definitely welcome any suggestions. Thanks in advance.
CopyDownMacro Macro
Set Regions = Range("regions")
Range("start_cell").Select
For x = 1 To Regions
Range("formula_copy").Select
Selection.Copy
Range("start_Cell").Select
ActiveCell.Offset(x - 1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False
Next x
End Sub
Last edited:
