Copy a formula using Vlookup
On Dec 11, 7:05*am, ansar ak wrote:
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
VLOOKUP() returns a value. What you need is a combination of MATCH()
and OFFSET() to get the address of the cell. Then use a tiny bit of
VBA to perform the copy/paste.
Are you O.K. with the VBA approach??
|