macros!!
 

Hi,

Please can you help me to do the following

Have figure in E2 and F2

Want to do the following

Insert column between F&G
Multiply E2 by G2
Copy formula to bottom of table (this changes length)

Thanks

Sarah xx

macros!!
 

Dim rng as Range
Column("G").Insert
set rng = Range(cells(2,"F"),Cells(2,"F").End(xldown))
rng.offset(0,1).Formula = "=E2*H2"

I assume when you say multiply E2 by G2, it is really H2 after inserting a
column Before column G (that column becomes the new G).

--
Regards,
Tom Ogilvy


"Sarah_Lecturer" wrote:

Hi,

Please can you help me to do the following

Have figure in E2 and F2

Want to do the following

Insert column between F&G
Multiply E2 by G2
Copy formula to bottom of table (this changes length)

Thanks

Sarah xx

macros!!
 

You are correct Tom - of course!!!

Thanks very much - great help!

Sarah xx

"Tom Ogilvy" wrote:

Dim rng as Range
Column("G").Insert
set rng = Range(cells(2,"F"),Cells(2,"F").End(xldown))
rng.offset(0,1).Formula = "=E2*H2"

I assume when you say multiply E2 by G2, it is really H2 after inserting a
column Before column G (that column becomes the new G).

--
Regards,
Tom Ogilvy


"Sarah_Lecturer" wrote:

Hi,

Please can you help me to do the following

Have figure in E2 and F2

Want to do the following

Insert column between F&G
Multiply E2 by G2
Copy formula to bottom of table (this changes length)

Thanks

Sarah xx