owing link
http://www.techrepublic.com/blog/msoffice/quickly-add-a-header-or-footer-to-every-sheet-in-an-excel-workbook/6601.
it might be of some help to you
Regards,
VIJAYKUMAR
On Fri, Jun 7, 2013 at 6:42 PM, Pravin Gunjal wrote:
> I have attached a sample file with logo of a company. I want this logo
>
Thanks Ashish Jee
Both the codes are working fine for one picture, but what if I wants to
insert to picture instead of one?
Thanks
Pravin Gunjal
-- Forwarded message --
From: ashish koul
Date: Fri, Jun 7, 2013 at 8:02 PM
Subject: Re: $$Excel-Macros$$ Insert picture in an
Hi,
I want to convert the date =Today() to this format : DD.MM.
Formula =Today() 6/14/2013 In next cell, it should display as :
14.06.2013
Sample file is attached. Thanks.
Regards
Pravin Gunnjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT
Fantastic...
Thanks Vaibhav & Noorain.
Regards
Pravin.
-- Forwarded message --
From: VBA VABZ
Date: Fri, Jun 14, 2013 at 12:15 PM
Subject: Re: $$Excel-Macros$$ Date conversion to other format
To: excel-macros@googlegroups.com
refer..
On Fri, Jun 14, 2013 at 12:10 PM, Pr
Dear Mr Vijay,
Thanks for it. I tried the same but it's not working. I am using 2007
version.
Example:
When I paste any link to word its displaying correctly as :
https://login.yahoo.com/config/mail?.intl=us
but when I hit on enter button it's getting changed as : {HYPERLINK “
https://login.ya
I have date in this format : *DD.MM.* (with dot) and require it as : *
DD-MMM-* (with hyphen).
For example : I have* 01.04.2013* and want it to be displayed as *
01-APR-2013*
Kindly give me the formula. Thanks
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
t click, format cell, custom & type DD--.
You can use text(cell,"DD-MMM-") also.
Thanks
On Sat, Jun 22, 2013 at 1:31 PM, Pravin Gunjal wrote:
> I have date in this format : *DD.MM.* (with dot) and require it as : *
> DD-MMM-* (with hyphen).
> For exa
Thanks Prabhu & Vaibhav,
I am trying to paste any link in a new file only and even though it's
happening; I don't know why.
There might be somewhere setting is changed.
Regards
Pravin Gunjal.
-- Forwarded message --
From: VBA VABZ
Date: Sat, Jun 22, 2013 at 5:06
Dear Ahmed,
Thanks it's working fine.. Nice to see you here after long time..
Regards
Pravin Gunjal.
-- Forwarded message --
From: Ahmed Honest
Date: Sat, Jun 22, 2013 at 5:51 PM
Subject: Re: $$Excel-Macros$$ Date format to be changed
To: excel-macros@googlegroups.com
Thanks Mr Vijay. Now I could see the links which I had copied from browser.
Regards,
Pravin Gunjal.
On Sun, Jun 23, 2013 at 2:12 PM, P.VIJAYKUMAR wrote:
> Respected Pravin,
>
> You remove the chech box for internet under Autoformat tab and also under
> Auoformat as you type tab.I
*May I know how to take a screenshot with the shape given below. Thanks.*
[image: Inline image 1]
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
But how it's getting changed automatically?
-- Forwarded message --
From:
Date: Mon, May 6, 2013 at 4:31 PM
Subject: Re: $$Excel-Macros$$ 8 become 0
To: excel-macros@googlegroups.com
**
Change the format of cell to text or add ' in front of number
Sent on my BlackBerry® from Vo
, in this
situation. Thanks in advance.
*With regards,**
**Pravin Gunjal*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
Hi Anoop
I do not want to restrict my folder from unnecessary access instead I want
it to be used by others.
Regards
Pravin Gunjal.
-- Forwarded message --
From: Anoop K Sharma
Date: Thu, Jul 4, 2013 at 5:36 AM
Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg
Hi Anoop,
Thank you for valuable information. Is there any option to create a
back-up / auto up-dation in some other location, and not in the same folder.
Regards
Pravin Gunjal.
-- Forwarded message --
From: Anoop K Sharma
Date: Thu, Jul 4, 2013 at 1:28 PM
Subject: Re: $$Excel
Can I get some more suggestions on this topic.. Thanks.
Regards
Pravin Gunjal.
-- Forwarded message --
From: Pravin Gunjal
Date: Thu, Jul 4, 2013 at 2:14 PM
Subject: Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
To: excel-macros@googlegroups.com
Hi Anoop,
Thank
Thanks everyone for your valuable reply. I will try with it to get the good
result.
Thanks again.
Regards
Pravin Gunjal.
De Premor d...@premor.net
via<http://support.google.com/mail/bin/answer.py?hl=en&ctx=mail&answer=1311182>
googlegroups.com
7:11 AM (11 hours ago)
to exc
k you,
Regards
Pravin Gunjal.
-- Forwarded message --
From: De Premor
Date: Thu, Jul 11, 2013 at 11:01 AM
Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
To: excel-macros@googlegroups.com
Why didn't you write your own code, i was send enough sample code
*Dear Premor,*
* *
*Please accept my sincere thanks for doing so much of work for me..*
*
*
*Regards*
*Pravin Gunjal.*
-- Forwarded message --
From: Pravin Gunjal
Date: Thu, Jul 11, 2013 at 11:29 AM
Subject: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
To: excel-macros
And what about if the value is same in both columns.
-- Forwarded message --
From: priti verma
Date: Mon, Jul 15, 2013 at 5:28 PM
Subject: Re: $$Excel-Macros$$ Challanging queri
To: excel-macros@googlegroups.com
HI rupali ,
good job
On Mon, Jul 15, 2013 at 4:43 AM, Rupali Josh
Hi DP
I too applied the same condition (pl see the green background in same
sheet), but the result shown is different.
Regards
Pravin Gunjal.
-- Forwarded message --
From: De Premor
Date: Mon, Jul 15, 2013 at 7:30 PM
Subject: Re: $$Excel-Macros$$ Challanging queri
To: excel
Kumar
On Tue, Jul 16, 2013 at 2:01 PM, Pravin Gunjal wrote:
> Hi, I need to extract the data from one sheet to multiple sheets based on
> column "A".
>
> That means the separate sheets must be created "Head Quarter" wise with
> it's total line. And Ro
post the file at group.
-- Forwarded message --
From: Kaushal Kumar
Date: Wed, Jul 17, 2013 at 5:54 PM
Subject: $$Excel-Macros$$ Un hide a workbook
To: Excel VBA Group
Dear All,
When I am opening an excel file it seems it is open but not visible. Seems
like entire workbook is
It's awesome.
-- Forwarded message --
From: Anonymous
Date: Wed, Jul 17, 2013 at 5:57 PM
Subject: $$Excel-Macros$$ Re: Help Required
To: excel-macros@googlegroups.com
Hi All,
I've found a more simpler way to get the time in hrs and minute..
And yes i've seen all ur tricks for
Dear Lerner
Not Understood.. Because it's getting updated in the file sent by me.
Regards
Pravin Gunjal.
-- Forwarded message --
From: excel lerner
Date: Sat, Jul 20, 2013 at 10:15 AM
Subject: Re: $$Excel-Macros$$ formula required to update values form one
sheet to an
min47s UTC-3, Pravin Gunjal
escreveu:
>
> Hello,
>
>
>
> I would like to translate this attached PDF texts (words) in to English to
> work out on it. I tried my best but couldn't get the exact result. Can
> someone help me out and inform, how to do it. Thanks in advan
Pl put it in cell E8 and drag below
=IFERROR(VLOOKUP(C8,$I$7:$J$12,2,0)*($G$3%),"")
Regards
Pravin Gunjal.
-- Forwarded message --
From: xlstime
Date: Thu, Aug 1, 2013 at 8:19 PM
Subject: Re: $$Excel-Macros$$ Auto Rate taking- !!! HELP PLZ !!!
To: ex
You can change as follows :-
=ROUND(VLOOKUP(F3:F1000,$I$3:$J$100,2,0)*(1+($J$1/100)),0)
Regards
Pravin Gunjal.
-- Forwarded message --
From: SAJID MEMON
Date: Tue, Aug 6, 2013 at 2:10 PM
Subject: $$Excel-Macros$$ Vlookup with Round - HELP REQUIRE ???
To: Sundarvelan Natarajan
Hello,
Can I get help from you to remove extra space / enter from column "C" in
the attached sheet. Pl do the needful.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this foru
Thanks DP for your immediate response.
Could you please inform the meaning of this formula for my understanding.
Regards
Pravin Gunjal.
-- Forwarded message --
From: De Premor
Date: Mon, Aug 26, 2013 at 4:08 PM
Subject: Re: $$Excel-Macros$$ Extra Space & Enter to be removed
/08/2013 17:49, Pravin Gunjal menulis:
Thanks DP for your immediate response.
Could you please inform the meaning of this formula for my understanding.
Regards
Pravin Gunjal.
-- Forwarded message --
From: De Premor
Date: Mon, Aug 26, 2013 at 4:08 PM
Subject: Re: $$Excel-Macros
Dear Team XLS
Is this a secure email? as i got some security warning.
Please confirm.
Regards
Pravin Gunjal.
-- Forwarded message --
From: xlstime
Date: Thu, Aug 29, 2013 at 5:58 PM
Subject: $$Excel-Macros$$ Very important document
To:
Good day,
Please view the document I
-- Forwarded message --
From: veeru
Date: Fri, Aug 30, 2013 at 8:15 PM
Subject: Microsoft Excel Re: vlook up button for single click
To: microsoft-office-2...@googlegroups.com
no one solved my problem?
On Monday, August 19, 2013 12:40:44 PM UTC+5:30, veeru wrote:
>
>
gt; =INDIRECT(E$2&"!BT5")
>>
>> .........
>>
>> Enjoy
>> Team XLS
>>
>>
>>
>> On Fri, Oct 18, 2013 at 10:59 AM, Pravin Gunjal wrote:
>>
>>> *Hi,*
>>>
>>> * *
>>>
>>>
*May crores of lamps lighten up your life,*
* With endless happiness, richness,*
*Health & wealth forever,
Wishing you and your family a very **Happy Diwali.***
* *
*[image: image005.jpg]*
* *
*With regards,**
**Pravin Gunjal**
***
*Veritaz Healthcare Ltd, Hyderabad*
*
*
*Con
This also can be used: =COUNTA(D2:D15)
Regards
Pravin Gunjal.
On Sat, Nov 2, 2013 at 7:46 PM, Robert Barnes wrote:
> You are a GENIUS!!!
>
>
> On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko wrote:
>
>> Are you looking for this?
>>
>> =COUNTIF($D$2:$D$15,
Hello,
Is there any new updates on this subject? As periodically it's changing.
Please suggest a good company and let me know what are all the accessories
and other facilities should I check before buy.
Look forward to hear from all experts.
Thank you,
Regards
Pravin G
201 - 237 of 237 matches
Mail list logo