Stuck with possible loop vba

[Alpacino]

Hi again,
I have a macro say Test1.
Test 1 extracts data from one workbook to another.
That works fine. It uses 3 different data validation lists to get the right info.
One data validation list (range from A26:A50 data validation is in A2.) is full of different business which have their own worksheet in my new workbook.

I select a business from the data validation a2 then run macro.

What I like to do is run a macro that will do all business withthe same macro test1.

Thanks in advance
Alan

 

[Marcelo Branco]

Hi Alan,

Not sure if i understood correctly, but maybe something like (adjusting macro Test1 code if necessary)

Sub testLoop()
    Dim i As Long
 
    For i = 26 To 50
        Range("A2") = Range("A" & i)
        'Code of macro Test1 here
        'or Call Test1
    Next i
End Sub

M.