Copying formula from One sheet and pasting in all the sheets available in that workbook

[Chandresh]

Hi All,

Need a help in copying the formula from database sheet cellAA3 to all the sheets in excel workbook in cell AA1

1) I have VLOOKUP formula in cell AA3 in databasesheet.
2) Need a macro to copy the formula from Cell AA3from database sheet and paste in all the sheets available in that workbook.


Thanks in advance for your Help

 

[Chandresh]

HI team ,

can any one help need help on urgent basis

 

[Chandresh]

I need this code in all the sheet available in the workbook except summary & data sheet

Range("A1").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(R[2]C,Data!C:C[1],2,0)"