copy a range of cells N times and paste in separate sheet and also change a specific colum

Hi,

I am new to Excel Macros, Please give me a solution for this problem.

I am having 2 blocks of cells in sheet2 (acc_cap and power_cap).acc_cap contains 3 sub blocks(B2 to F6, B7 to F10, B11 to F14) and power_cap contains 2 sub blocks(B15 to F20, B21 to F23). I like to have my final output in sheet3 which will be controlled from sheet1.

In sheet1 column A indicates block name, column B indicates offset value, column C indicates how many times to repeat the block.

1) In 2nd row of sheet1 I mentioned power_cap(in A2 cell), 40(in B2 cell), 4 (in C2 cell),
then the macro has to search for "power_cap" in column A of sheet2, if it finds then that power_cap block range( A15 to F23 in sheet2) has to be pasted in sheet3 for 4 times means it contains 8 sub blocks. In the column C of sheet3, the offset values of sub blocks of power_cap has to be 40, 44, 48, 4c, 50, 54, 58, 5c.

2) In 3rd row of sheet1 I mentioned acc_cap(in A3 cell), 84(in B3 cell), 1 (in c3 cell),
then the macro has to search for "acc_cap" in column A of sheet2, if it finds then that acc_cap block range( A2 to F14 in sheet2) has to be pasted in sheet3 for 1 time means it contains only 3 sub blocks. In the column C of sheet3, the offset values of sub blocks of acc_cap has to be 84, 88, 8c.



Please provide me a solution