Thank you so much Swapnil.
Its working fine
Thanks
Amit
On Tue, Dec 18, 2012 at 2:06 PM, Swapnil Palande
palande.swapni...@gmail.com wrote:
Hi Amit,
No need of macro for this. You can use INDIRECT function.
Check following formula.
=LOOKUP(2,1/((INDIRECT(' B3
Hi Experts
I need a macro which will fill-in mentioned formulas in cell C3 to K4 for
sheet backup and get the desired results.
activesheet.range(c2)= =LOOKUP(2,1/(('*^BSESN*_WBQ'!$D:$D=$B3)*('*^BSESN*
_WBQ'!$E:$E=C$2)),'*^BSESN*_WBQ'!$K:$K)
i need macro to get above red highlighted values from
Hi Swapnil
I am not very good in VBA, can you please send me macro code for this.
Regards
Amit
On Mon, Dec 17, 2012 at 5:54 PM, Swapnil Palande
palande.swapni...@gmail.com wrote:
Hi,
Try formula function of class Range
Regards
Swapnil
On Dec 17, 2012 5:16 PM, Amit Gandhi