Its okay now sir. can you do when run the program. the result is in 1 sheet only ? and the quantity 10 became 1 when program is run.

the program will take affect in range B to F only not in A or G