Dear all,

I have a sheet with some formulas, i need the same formulas in the new
sheet.

Eg: -
A1 A2
A3 A4 A5 A6
Code Customer Name Oct 11 Sep 11 Aug 11 Total
CAA001 ABUDHABI HOSPITALITY CO. 11,456 8,422 28,063 =sum(A3:A5)

can i able to copy only formula (A6) with reference to the colomn A1
using Vlookup or any other formula to the new sheet

Ansar