$$Excel-Macros$$ Fwd: Excel VBA Macro Help Group [excelvbalab] Save outlook draft through Excel

2016-03-21 Thread SUDHIR VERMA
-- Forwarded message -- From: SUDHIR VERMA Date: 19 March 2016 at 22:08 Subject: Excel VBA Macro Help Group [excelvbalab] Save outlook draft through Excel To: Excel VBA Lab Dear Experts, Please help for modification for macro (save outlook draft through excel). In this

Re: $$Excel-Macros$$ Create Multiple sheet

2016-01-30 Thread SUDHIR VERMA
👏👏👏 great Abhishek ji. On 25 January 2016 at 11:58, Shrinivas Shevde wrote: > Really a great job > Very very thanks > Regards > Shrinivas > > On Mon, Jan 25, 2016 at 11:49 AM, Abhishek Jain > wrote: > >> Please see attached. >> >> HTH >> >> On Mon, Jan 25, 2016 at 11:43 AM, Shrinivas Shevde < >

Re: $$Excel-Macros$$

2016-01-21 Thread SUDHIR VERMA
On 20 January 2016 at 23:51, SUDHIR VERMA wrote: > Dear All, > > I need a macro to perform for sending hundreds of mail saved already in > drafts. > > Please try if it will work on selected mails of draft. > > Thanking You > > Sudhir > > -- > Are you =EXP

$$Excel-Macros$$

2016-01-20 Thread SUDHIR VERMA
Dear All, I need a macro to perform for sending hundreds of mail saved already in drafts. Please try if it will work on selected mails of draft. Thanking You Sudhir -- 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

Re: $$Excel-Macros$$ plz help

2015-12-27 Thread SUDHIR VERMA
U) Date: > ",RIGHT(B10,11),K9),"MM/DD/")" > > > > *Pankaj Sharma * > > *MIS Analyst* > > *Greater Kailash-1, New Delhi* > > *Email * > *p > ankaj123...@gmail.com > **Skype** > pa

$$Excel-Macros$$ plz help

2015-12-26 Thread SUDHIR VERMA
Sir, I am attached excel report for required help date difference. Thanking You Regards Sudhir -- 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

$$Excel-Macros$$ FIND PERSON BEHIND EMAIL ADDRESS

2015-10-16 Thread SUDHIR VERMA
Dear All, Kindly help me to search person behind following email address. rmishra2...@rediffmail.com 1. Who is person behind email. 2. IP address 3. Location If any information will find please forward to me. And suggest me to track this email id. If you have any software please share. Thanki

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-08-28 Thread SUDHIR VERMA
Dear Friends, i am sudhir. i had connected with this group for very long time. I have learn much more past 7 years from this group. Currently i am working as sales Mis coordinator. Thanking You Regards Sudhir On 27 August 2015 at 19:11, karthik v wrote: > Hello All, > > I am Karthik. I have bee

Re: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING

2015-08-28 Thread SUDHIR VERMA
e cells with the values that you want to convert to > numbers. > > 5. Right click and choose *Paste Special*. > > 6. Under *Operation*, click *Multiply* and then click *OK*. > > > > Regards > > *Haroon* > > > > *From:* excel-macros@googlegroups.com

$$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING

2015-08-27 Thread SUDHIR VERMA
Dear Friends, Please help me as per attached sheet. I have data of 25k row. there are some code formatting as text. So you are request to please share formula for this. Here, example is attached. Thanking You Regards Sudhir -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b

Re: $$Excel-Macros$$ Fwd: REQUIRED SUGGESSTION

2014-12-07 Thread SUDHIR VERMA
this problem occured when try any excel command like, insert column & row, copy data. thanking You On 8 December 2014 at 11:57, SUDHIR VERMA wrote: > > -- Forwarded message -- > From: sudhir > Date: 8 December 2014 at 11:55 > Subject: REQUIRED SUGGES

$$Excel-Macros$$ Fwd: REQUIRED SUGGESSTION

2014-12-07 Thread SUDHIR VERMA
-- Forwarded message -- From: sudhir Date: 8 December 2014 at 11:55 Subject: REQUIRED SUGGESSTION To: newinex...@gmail.com Dear All, Kindly resolve this problem. *Thanks & Regards* *Sudhir* *Sales Co-ordinato**r* *[image: newlogo]* *[image: signature]* *P**TH

Re: $$Excel-Macros$$ Re: URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-10-01 Thread SUDHIR VERMA
thanking you so much On 1 October 2014 19:37, Rajan Verma wrote: > in J1 > > =LOOKUP(1,N(COUNTIF(D2:H2,D2:H2)>1))=1 > > Regards > Rajan. > > On Thursday, 25 September 2014 11:15:01 UTC-6, SUDHIR VERMA wrote: >> >> Dear Experts, >> >> Kindl

Re: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-10-01 Thread SUDHIR VERMA
you need to select whole column like column J. > > macro will process data & you will get out put in column J. > > Cheer!! > > + > *I did not do this for you. God is here working through me for you.* > > On Wed, Oct 1, 2014 at 12:01 AM, SUDHIR VERMA > wrote: &g

Re: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-09-30 Thread SUDHIR VERMA
I did not do this for you. God is here working through me for you.* > > On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA > wrote: > >> Dear Experts, >> >> Kindly resolve my problem. >> >> Explanation in attached workbook. >> >> Thanking You >

Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-09-30 Thread SUDHIR VERMA
Dear All, Kindly help. On 27 September 2014 14:38, Vaibhav Joshi wrote: > Hi > > Check this.. click blue button to run macro! > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Thu, Sep 25, 2014 at 10:44 PM, SU

Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-09-26 Thread SUDHIR VERMA
; > Regards, > Ganesh N > > On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA > wrote: > >> Dear Experts, >> >> Kindly resolve my problem. >> >> Explanation in attached workbook. >> >> Thanking You >> >> Regards >> Sudhir &

$$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-09-25 Thread SUDHIR VERMA
Dear Experts, Kindly resolve my problem. Explanation in attached workbook. Thanking You Regards Sudhir -- 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

Re: $$Excel-Macros$$ SumProduct

2014-09-23 Thread SUDHIR VERMA
Dear Ravi, what is use of "--" before B2:B13 in above formula. Please explain. On 13 September 2013 16:28, Ravi Kumar wrote: > Hi, > > > > Try this.. > > > > =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) > > > > > > > > *Warm Regards,* > > *Ravi Kumar.* > > > > *From:* excel-mac

Re: $$Excel-Macros$$ need macro

2014-07-28 Thread SUDHIR VERMA
> You need to hide row 1 & also hide sheet1 & set property very hidden. > after that lock macro. > > When file is opened macro will triggered. I have put current date so after > enabling macro sheet will get closed automatically. > > Cheers!! > > > On Thu, Jul

$$Excel-Macros$$ need macro

2014-07-24 Thread SUDHIR VERMA
Dear Experts, I need macro, which can encrypt with password after defined no of days. Example- i make file today, after 20 days it will password protect automatically. So someone couldn't open in my absence. Thanking You Regard Sudhir -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ HOW TO RECORD RECOVERY DAY'S

2014-02-15 Thread SUDHIR VERMA
no one reply yet. please On 14 February 2014 19:46, SUDHIR VERMA wrote: > Dear All, > > Please help me. > > Thanking You > > -- > 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 offi

$$Excel-Macros$$ HOW TO RECORD RECOVERY DAY'S

2014-02-14 Thread SUDHIR VERMA
Dear All, Please help me. Thanking You -- 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 thread titles. Poor thread titles,

Fwd: $$Excel-Macros$$ COUNT OF RECOVERY DAYS

2014-02-13 Thread SUDHIR VERMA
-- Forwarded message -- From: SUDHIR VERMA Date: 12 February 2014 21:34 Subject: $$Excel-Macros$$ COUNT OF RECOVERY DAYS To: excel-macros Dear All, Please suggest me to prepare recovery days. Better explanation in attachment. thanking you Sudhir Verma -- Are you =EXP(E:RT

$$Excel-Macros$$ COUNT OF RECOVERY DAYS

2014-02-12 Thread SUDHIR VERMA
Dear All, Please suggest me to prepare recovery days. Better explanation in attachment. thanking you Sudhir Verma -- 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.faceboo

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

2014-02-06 Thread SUDHIR VERMA
can u please resent me complete code. On 6 February 2014 12:55, ashish koul wrote: > you need to add if condition here > > if Cells(i, s).value <> 0 then > Sheets("Output").Range("g" & k) = Cells(i, s).text > end if > > > > > On Mon, Feb 3, 2014 at 6:28 PM, Umesh Kumar wrote: > >> Hi Ashish, >

Re: $$Excel-Macros$$ Help Needed

2014-02-03 Thread SUDHIR VERMA
eally necessary. Thanks for your support to protect our environment > for the future generation* > > > *1 ream of paper = 6% of a tree and 5.4 kg CO2 in the atmosphere 3 sheets > of A4 paper pollutes 1 litre of water* > > > > > On Mon, Feb 3, 2014 at 1:53 PM, SUDHIR VER

Re: $$Excel-Macros$$ Help Needed

2014-02-03 Thread SUDHIR VERMA
Dear Harish, Please find attachment of addin. Please use & reply. Thanking you (it was received by me in 2009 through this group) On 30 January 2014 14:39, Harish P Y wrote: > Dear Excel Gurus, > > Please find the attached file Marks Sheet, > and i want to obtain the marks obtained in words a

Re: $$Excel-Macros$$ problem

2013-12-23 Thread SUDHIR VERMA
thankx Ashish On 15 December 2013 19:10, Ashish Kumar wrote: > Dear Sudhir, > > Go to file option then click on options tab then click on language button > then select your language english and save it. > > Thanks, > Ashish > > > On Saturday, 14 December 2013, SUD

$$Excel-Macros$$ problem

2013-12-14 Thread SUDHIR VERMA
Dear All, i am suffer problem in excel, when i type any key then generate Urdu word. please resolve this. -- 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

Re: $$Excel-Macros$$ Fwd: Formatting Required

2013-10-26 Thread SUDHIR VERMA
pls try this On 27/10/2013, SUDHIR VERMA wrote: > On 26/10/2013, Ravinder wrote: >> Simply try this formula =IF(D5="",C5,G6) and dragdown >> >> Or >> >> pfa >> >> >> >> From: excel-macros@googlegroups.com >> [mailto:ex

Re: $$Excel-Macros$$ Fwd: Formatting Required

2013-10-26 Thread SUDHIR VERMA
On 26/10/2013, Ravinder wrote: > Simply try this formula =IF(D5="",C5,G6) and dragdown > > Or > > pfa > > > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Javed Khan > Sent: Saturday, October 26, 2013 3:25 PM > To: excel-macros@googlegroups.com > Subjec

Re: $$Excel-Macros$$ To Share and View Excel Dashboards.

2013-10-26 Thread SUDHIR VERMA
It can be possible through Google Drive or Sky Drive. On 26 October 2013 17:22, Excel_Lover wrote: > Dear All, > > What is the best way to share and View the excel dashboard online. > > Basically, We have one excel dashboard which we send by e-mail on > updation. What I need is an alternate sol

Re: $$Excel-Macros$$ DEFINE NAME FUNCTION

2013-10-12 Thread SUDHIR VERMA
thnx On 12 October 2013 22:34, SUDHIR VERMA wrote: > Dear Experts, > > How to edit edit in Define Name Function after applicable. > > > Thanking You > > Regards > > Sudhir > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’

$$Excel-Macros$$ DEFINE NAME FUNCTION

2013-10-12 Thread SUDHIR VERMA
Dear Experts, How to edit edit in Define Name Function after applicable. Thanking You Regards Sudhir -- 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 R

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2012-10-14 Thread SUDHIR VERMA
Hi, I am sudhir, age 28, working in Vardhman Group, Delhi thanking u On 13 October 2012 18:26, wrote: > ** > Hi, > > Welcome Abhishek.. > > Cheerz... > > Sent on my BlackBerry® from Vodafone > -- > *From: * CA Abhishek Agarwal > *Sender: * excel-macros@googlegroups

Re: $$Excel-Macros$$ Combo [ Formula + Macro Bible] - [Prince 9953872217]

2012-10-14 Thread SUDHIR VERMA
thankx for sharing On 14 October 2012 10:23, Nikhil Shah wrote: > Hi > > Thanks for sending excellent file, > > (1). Prince Formula Bible (Updated Version) > (2). Updated Lets Learn Together ( Macro Bible ) > Can you send all files in excel 2003.. > > Nikhil > > > > On Sat, Oct 13, 2012 at 10:

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-17 Thread SUDHIR VERMA
Hi, Kuldeep, This is very interesting can u explain. thanks regards sudhir On 17/08/2012, Kuldeep Singh wrote: > Simple Create a pivot table. All files paste link & create a new pivot you > can combine all 2000+++ Sheets Database. > > Regards, > Kuldeep Singh > > On Fri, Aug 17, 2012 at 8:50

$$Excel-Macros$$ Help me

2012-08-04 Thread SUDHIR VERMA
Dear All, How can i use Tally ODBC for multiple queries. Suppose i want get data of Tally Day Book. thanking u Regards Sudhir -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula P

$$Excel-Macros$$ Growth Forumula For Pivot Table

2012-07-17 Thread SUDHIR VERMA
Dear All Expert, Can any one add field of growth(%) (which will calculate in Financial year total). Please view attachment for further clarification. thanking you regards sudhir -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ Index Formula Help

2012-07-01 Thread SUDHIR VERMA
Dear All, Please look at attachment and help me. thanking u Regards Sudhir -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not ge

Re: $$Excel-Macros$$ How to find paritcular word from sentence

2012-06-03 Thread SUDHIR VERMA
Dear Ashish, Thank you so much and Please can u explain this for understanding me. thanking you On 03/06/2012, ashish koul wrote: > check the attachment see if it helps > > On Sun, Jun 3, 2012 at 1:53 PM, SUDHIR VERMA wrote: > >> Dear All, >> >> Please res

$$Excel-Macros$$ How to find paritcular word from sentence

2012-06-03 Thread SUDHIR VERMA
Dear All, Please resolved below query. Being accounts credited as per bill no: 45586, dt: 7.8.11, GR No: 785, dt: 6.8.11, by NTU. Being accounts credited as per GR No: 100486 dt: 5.9.11, Bill no 889, dt: 4.9.11 by Fedex. Bill No: 97849, dt: 10.8.11 and gr no 56478789, dt:1.8.11 through Nalagarh