Looping and offset

[DAH26952]

I have a created a formatting template but it only works on one item at a time. I need to automate the creation by going through a list.

I need to be able to copy the first item to a cell, let the macro run, then go back to the next item in the list and repeat the macro.

For example, I have a list of 5 items in column G1-:5, i need to take item in G1, copy it to A1, run the macro, then go to G2 and repeat.

Any help would be appreciated

 

[Scott Huish]

Why do you need a loop?

Sub Test
Range("G1:G5").Copy Range("A1")
End Sub

 

[DAH26952]

Let me clear up what I am doing. I have a list of about 200 dept id's i need to create new templates for. Instead of individually running each template by changing the id, I want to have a macro to loop through my list, select each id one at a time, run my current macro (including essbase), then go to the next id on the list. As a note, I cannot have the list within the essbase retrieve as it will implode the template.

Hopefully this clears up any questions. Thanks