*Thanks Team...*
-- Forwarded message --
From: xlstime
Date: Fri, Oct 18, 2013 at 11:05 AM
Subject: Re: $$Excel-Macros$$ How to take values from other sheets with
single formula or VBA
To: excel-macros@googlegroups.com
little changes
=INDIRECT(E$2&"!BT"&ROWS(E$1:E5))
..
=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
Ok the following code KIND OF works
Dim wdapp As New Word.Application
Dim wddoc As Word.Document
Run CopyData
Set wdapp = CreateObject("word.application")
Set wddoc = wdapp.documents.Add
wdapp.Visible = True
With wddoc.PageSetup
.Orientation = wdOrientLandscape
.PageWidth = InchesToPoint
What if I only wanted to copy worksheets "power report" and "ats data" out
of a workbook with 12 other sheets in addition to those? looks like I need
to modify the For Each statement.
So perhaps like this For Each sh In Worksheets(ARRAY("Power Report", "ATS
Data")) ?
On Thursday, October 17,
Thanks, I was hoping to find a nice easy way like what was available in the
2003 version.
On Tuesday, October 15, 2013 10:36:15 AM UTC-4, dr wrote:
> Hi,
>
> Is there a way to create a custom button (a button image that I designed)
> then assign a macro to it and put it in the quick access t
Hi Bs,
Fist upon thank you so much for giving me support it will be very helpful
if you solve this. My Ms office version is - 2010.
pls let me know if you required any other information
Regards
On Thu, Oct 17, 2013 at 4:49 PM, Basole wrote:
> Dear Jocky, what is your version of MS Office?
>
Dear Sir,There are a set of debit values and a set ot credit values
in a column. I want a vba code by whcich the debit value plus a single /
multiple credit value is zero that needs to be marked . finally i will
come to know out of the avaibale debits which cannot be used the with
a
Dear Jocky, what is your version of MS Office?
Em quarta-feira, 16 de outubro de 2013 11h40min34s UTC-3, jocky Beta
escreveu:
>
> Hi Team,
>
> I need help on above attached sheets, In the excel sheet i should browse
> the PDF file (which is attached in this mail ) and then the output data
>
Try Out This Link...
http://excel.rtsoftwares.co.in/products/portfolio-template
On Thursday, October 8, 2009 2:01:12 PM UTC+5:30, chinmay kamat wrote:
>
> Hello friends,
>
> I'm interested in using excel to do calculation for gains/losses in
> shares.
>
> As per law, there are 3 kinds of tr
Hi Jocky, I'm checking out the reason of error. Anyway see your text file
attached to test another worksheet.
Basole.
Em quarta-feira, 16 de outubro de 2013 11h40min34s UTC-3, jocky Beta
escreveu:
>
> Hi Team,
>
> I need help on above attached sheets, In the excel sheet i should browse
>
Thanks for your prompt reply, But i was having some condition, that we are
not suppose to use :
Write Formula without using
1. Where ever there is ifs in last words eg. Countifs, sumifs etc……
2. Please don’t use Index, offset.
3. Please don’t use sumproduct.
4. Please don’t use CountA
But you ca
Hi,
I don't have password for this file is there any alternative way to
complete same.
On Thu, Oct 17, 2013 at 2:03 PM, Anil Gawli wrote:
> Dear Jocky,
>
> Kindly unlock the password and resend.
>
> Warm Regards,
> Gawli Anil
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
>
Experts,
Please Write Formula without using
1. Where ever there is ifs in last words eg. Countifs, sumifs etc……
2. Please don’t use Index, offset.
3. Please don’t use sumproduct.
4. Please don’t use CountA
But you can use Sum, Count, etc in attached file. pfa.
With warm regards,
Rajan Sha
Dear Jocky,
Kindly unlock the password and resend.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Oct 17, 2013 at 1:59 PM, Jocky Beta wrote:
> Hi Team,
>
> Can anybody fix this attached error for me. i am also attachi
17 matches
Mail list logo
