<div>
Can you upload a sample workbook showing what would be given and also what you want from the VB code?
</div>


<div>
<div class="content wysiwyg-content">
Excel <br />
Cell H2 –Product code<br />
Cell H50 –Value<br />
Cell H158 contains number times above needs to be repeated in new sheet in Colum H2 and M2 respectively.<br />
This need to be repeated &nbsp;<br />
&nbsp;Cell J2, L2,N2 –Product code<br />
Cell J50,L50,N50 –Value<br />
J158, L158, N158 contains number times they need to be repeated <br />
<br />
Can you help me with VB Coding Please?
</div>
</div>


Excel 
Cell H2 –Product code
Cell H50 –Value
Cell H158 contains number times above needs to be repeated in new sheet in Colum H2 and M2 respectively.
This need to be repeated  
 Cell J2, L2,N2 –Product code
Cell J50,L50,N50 –Value
J158, L158, N158 contains number times they need to be repeated 

Can you help me with VB Coding Please?

VB Code

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.