=INDIRECT(E$2&"!BT"&ROW()+1)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pravin Gunjal
Sent: Friday, October 18, 2013 11:00 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to take values from other sheets with single
formula or VBA
little changes
=INDIRECT(E$2&"!BT"&ROWS(E$1:E5))
.
Enjoy
Team XLS
On Fri, Oct 18, 2013 at 11:05 AM, xlstime wrote:
>
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Fri, Oct 18, 2013 at 11:02 AM, xlstime wrote:
>
>> use INDIRECT function
>>
>> =INDIRECT
.
Enjoy
Team XLS
On Fri, Oct 18, 2013 at 11:02 AM, xlstime wrote:
> use INDIRECT function
>
> =INDIRECT(E$2&"!BT5")
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Fri, Oct 18, 2013 at 10:59 AM, Pravin Gunjal wrote:
>
>> *Hi,*
>>
>> * *
>>
>> *I want to
use INDIRECT function
=INDIRECT(E$2&"!BT5")
.
Enjoy
Team XLS
On Fri, Oct 18, 2013 at 10:59 AM, Pravin Gunjal wrote:
> *Hi,*
>
> * *
>
> *I want to take the values from Apr to Mar sheets from “BT” column in
> this sheet.*
>
> *I have used this formula “=Apr!BT4”, but
