Copy Formulas to next row

[vandanavai]

Hello

I have following to do
Whenver any value is entered in say Cell A8, I want formulas in Range D8:F8 to get copied automatically to next row.i.e. to Range D9:F9
Again if any value is enterd in Cell A9 formulas in Range D9:F9 to D10:F10 and so on


Can anybody tell me how to go about this ? What VB code is needed?

Plese help

[VBA Noob]

Right click the sheet tab > select view code > paste in the below

Please Login or Register  to view this content.

VBA Noob

[mudraker]

The following macro works on any change made to column A

'These instructions pre typed & are worded to cater for the novice programmer
'To install macro to correct location

'Copy this macro
'GoTo Excel
'Select sheet this is to appy to
'Right Click on Sheet Name Tab > select View Code
'Past macro into the Worksheet Module displayed

Please Login or Register  to view this content.

[MickG]

Hi,Try:-

Please Login or Register  to view this content.

Regards Mick

[royUK]

What version of Excel are you using because you can set this up in Tools>-Options>-Edit & there is an option to "Extend data range formats & formulas" I think this was introduced in versions after 2000

[vandanavai]

Hello

Thanks every body for help.

[VBA Noob]

If this is resolved then please mark it resolved

VBA Noob