How to repeat a macro x number of times based on a value in a cell

My apologies if I do not have this formatted correctly, this is my first time posting.

I have a spreadsheet (attached) that runs a macro to copy a column of data from one page to the next. The criteria used to determine which column to copy is determined by the value in cell C147 (which be updated at a later time). The number of times to repeat the macro is determined by a countif command in cell C124, which counts the number of times the value in cell C147 is in row 122.

Here is the macro that I want to repeat:


Sub Move()
'
' Move Macro
'
' Keyboard Shortcut: Ctrl+Shift+M
'

Please Login or Register  to view this content.

Any help would be appreciated.

Thanks.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Hi gypsyhotelier and welcome to the forum

Try this type of code

Please Login or Register  to view this content.