VBA to Repeat Task a Specific Number of Times

[happyhungarian]

Hi there! So I hope I can explain what i'm trying to do clearly. I have an input table where users input hours for a labor category (column) and a task (row). The user also has the ability to insert more categories (columns) and more tasks (rows). In order for the information to become useful I need to convert this grid pattern into a list. The way I am currently doing that is by manually calculating the number of possible combinations of categories and tasks (for example, if i have 3 labor categories and 4 tasks I have a total possible combination of 12 (3x4)). Essentially I manually paste my total list of categories into the table 4 separate times. Then I let the table do it's magic and it's calculations using an INDEX MATCH to pull the information from the user input section. What I would like to do, however, is have excel realize the number of times it needs to paste the list of categories into the table by counting the number of tasks itself (or referencing a cell that tells the VBA how many times it needs to do that).

 

[BlueAure]

Hello Happyhungarian,

Please clarify your question with a more detailed example if possible.

 

[happyhungarian]

Maybe I can simplify... Is there a code that could look at the value that's in a cell (let's say A1) and based on the value in that cell the VBA will run a certain macro that number of time. Example, if cell A1 says 5 it would run the following string of code 5 times

 

[BlueAure]

Maybe I can simplify... Is there a code that could look at the value that's in a cell (let's say A1) and based on the value in that cell the VBA will run a certain macro that number of time. Example, if cell A1 says 5 it would run the following string of code 5 times

I think that this should do what you want.

Option Explicit


Sub Sub1()
    Dim numberoftimestorun As Integer
    Dim i As Integer
    
    
    numberoftimestorun = ActiveSheet.Range("A1").Value
    
    For i = 1 To numberoftimestorun
        
        'INSERT CODE HERE
        
    Next i




End Sub

 

[Steve_]

Maybe I can simplify... Is there a code that could look at the value that's in a cell (let's say A1) and based on the value in that cell the VBA will run a certain macro that number of time. Example, if cell A1 says 5 it would run the following string of code 5 times

Sub dynLoop()
    For i = 1 To Sheets("Sheet1").Cells(1, 1)
        'Run Macro
    Next i
End Sub

 

[happyhungarian]

@ BlueAure Worked perfectly!

 

[BlueAure]

Glad I could help!