Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I need a code to do the following:
<o> </o>
The cell value on worksheet (RFQ_Mani!$E$1) changes constantly by a formula calculated
<o> </o>
Based on range of sequential rows selected I need a code that would copy and insert these rows based on the value noted in cell RFQ_Mani!$E$1.
<o> </o>
So as an example:
If the cell value in RFQ_Mani!$E$1 = 3
<o> </o>
And the selected rows were row # 379,380, 381& 382, on running the code, I would want rows (383, 384, 385 and 386) and rows (387, 388, 389 and 390) populated with the content of rows (379,380, 381& 382) and its content displayed in the same sequence.
<o> </o>
Thus depending on the value in cell address RFQ_Mani!$E$1, I need a range of rows to be copied and inserted.
<o> </o>
Much appreciate your help.
<o> </o>
Thanks,
Chrisham
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I need a code to do the following:
<o> </o>
The cell value on worksheet (RFQ_Mani!$E$1) changes constantly by a formula calculated
<o> </o>
Based on range of sequential rows selected I need a code that would copy and insert these rows based on the value noted in cell RFQ_Mani!$E$1.
<o> </o>
So as an example:
If the cell value in RFQ_Mani!$E$1 = 3
<o> </o>
And the selected rows were row # 379,380, 381& 382, on running the code, I would want rows (383, 384, 385 and 386) and rows (387, 388, 389 and 390) populated with the content of rows (379,380, 381& 382) and its content displayed in the same sequence.
<o> </o>
Thus depending on the value in cell address RFQ_Mani!$E$1, I need a range of rows to be copied and inserted.
<o> </o>
Much appreciate your help.
<o> </o>
Thanks,
Chrisham