add 7 to formula valu and copy down

[redspanna]

Hi all

can anybody provide some code to complete the following task...

Cell B41 has a formula : =$B400
Cell C41 has a formula : =$C400
Cell D41 has a formula : =$D400
Cell E41 has a formula : =$E400

the code will find the last populated cell in column B of the 'graph' sheet
copy the formula in that cell down for the next 7 rows.
Do same for column C,D,E

Then the code will goto cell B41 in 'graph' sheet and add 7 to the formula
so for example as above B41 holds formula =$B400 this will now become =$B407
same for C41,D41,E41
then copy down B41,C41,D41,E41 to row 101

any help much appreciated and thanks in advance

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=535825

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted:
http://www.mrexcel.com/forum/showthread.php?t=127080