Copy and Inserting Selected Rows

[chrisham]

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

 

[Mala]

Look at these threads and adapt them to your requirement....

To auto-run when a formula-based cell changes:
http://www.mrexcel.com/forum/showthread.php?t=351791 (read this to the end)

To insert-paste:
http://www.mrexcel.com/forum/showthread.php?t=352254

 

[chrisham]

Mala,
thanks for responding, I am sure you have it all covered in that links you provided me below, but after raking my head on it, I am still unable to get it working.
I am pretty much a novice in this VBA programming bit, but I amazed with the stuff that can be done with this tool.
Appreciate if you could be more explicit in providing me a solution here.
Chrisham