Input box to count rows and highlight vba code

[Goalexcel]

Hello Experts, kindly help to use a vba code for the below.

Use inputbox to select from column A first 14 rows and color, next amount of rows follow the image above. Do the same on other sheets.
The result below

 

[Goalexcel]

Never knew you had data already in column A that you did not want colored.
I thought that was just a example

I thought we started off with column A being empty.
So explain again what your objective is?

This is my data Column A some number, and column C after make calculation to break those number in column A and group in color. Example, column A row 1 until 145.
We can add column D some number that need to repeat in column B , how many times go with column C.

After we run a macro, the result is below, macro input number 14 in the last rows of my original data.

We need to show the result like this

This macro need to run in sheet 1 until shee 8, the name of the sheet will change.

 

[My Aswer Is This]

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.
You never mentioned doing this is several different sheets.
And each sheet will have the same values in Column B ?

 

[Goalexcel]

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.
You never mentioned doing this is several different sheets.
And each sheet will have the same values in Column B ?

No each sheet will have different values in column B and column C.

 

[My Aswer Is This]

No each sheet will have different values in column B and column C.

Earlier we never mentioned column C

 

[Goalexcel]

Earlier we never mentioned column C

When I see your macro run and repeat numbers, I am thinking we can repeat numbers in column b, how many times depend on the number in the column C,
so I just moved to C and add column D to repeat this number in column B.

 

[My Aswer Is This]

When I see your macro run and repeat numbers, I am thinking we can repeat numbers in column b, how many times depend on the number in the column C,
so I just moved to C and add column D to repeat this number in column B.

Well that is good. Glad to see your reading the script and understand the logic.
It's always great to see users try and understand the logic of the code that way they may be able to write their own code to do what they want.