Repeat Macro Several Times

[dcwinter]

Hello,

I need a macro to do the following:

Take a customer name from a list of customers and add it to a cell (B2) in a worksheet ("Data Sheet - Product List").

Once this has been done, a sheet form the workbook is then copied into a new workbook ("Dashboard Monthly Reports").

I then need to do the same for the next customer to the bottom of the list, adding each copy of the worksheet to the "Dashboard Monthly reports" workbook.

The main part I'm struggling with is working out how to get it run down the list...

Any help greatly appreciated.

Danny

 

[njimack]

Assuming your list of customers starts in A2 of sheet 1...

Sub Test()
Dim End_Row As Long, n as Long

End_Row = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row

For n = 2 to End_Row

Sheets("Data Sheet - Product List").Range("B2") = Sheets("Sheet1").Cells(n,1)
'rest of your code goes here...

Next n

End Sub