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 & "_WBQ'!$D:$D
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" w
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
