Hi Team,
I looking for below macro requirement and hope can help me with it.
I have two sheets, Sheet1 is containing number and sheet2 containing the data. In sheet 2 if you have three line items then macro should insert the rows and copy the same row data as per the number updated in sheet 1. This should repeat for all the number of line items.
Example.
In Sheet 1 - A1 cell value =12
In Sheet 2 - data below
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>
Requirement - Macro should insert and copy the same A1 value in Sheet2 12 times and should repeat the same for rest of two line items. Please note that there should be additional empty row between each line item after inserting the rows.
Plz let me know if you need further clarificaiton on the above.
Thanks for your time.
I looking for below macro requirement and hope can help me with it.
I have two sheets, Sheet1 is containing number and sheet2 containing the data. In sheet 2 if you have three line items then macro should insert the rows and copy the same row data as per the number updated in sheet 1. This should repeat for all the number of line items.
Example.
In Sheet 1 - A1 cell value =12
In Sheet 2 - data below
A</SPAN> | B</SPAN> | C</SPAN> |
DEFC</SPAN> | 1221</SPAN> | Jacks</SPAN> |
ERDE</SPAN> | 1232</SPAN> | Lub</SPAN> |
RIEK</SPAN> | 1214</SPAN> | Cable</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>
Requirement - Macro should insert and copy the same A1 value in Sheet2 12 times and should repeat the same for rest of two line items. Please note that there should be additional empty row between each line item after inserting the rows.
Plz let me know if you need further clarificaiton on the above.
Thanks for your time.