$$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 <newinex...@gmail.com> Date: 19 March 2016 at 22:08 Subject: Excel VBA Macro Help Group [excelvbalab] Save outlook draft through Excel To: Excel VBA Lab <excelvba...@googlegroups.com> Dear Experts, Please help for modificati

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

Re: $$Excel-Macros$$

2016-01-21 Thread SUDHIR VERMA
On 20 January 2016 at 23:51, SUDHIR VERMA <newinex...@gmail.com> 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 >

$$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
7B%7D,'cvml','sharmapankaj...@yahoo.com');>ankaj123...@gmail.com > <javascript:_e(%7B%7D,'cvml','ankaj123...@gmail.com');>**Skype** > pankaj.sharma_pj* > > > > > -- Forwarded message -- > From: SUDHIR VERMA <newinex...@gmail.com > <javascr

$$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

$$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.

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 karthikv.1...@gmail.com wrote: Hello All, I

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

2015-08-28 Thread SUDHIR VERMA
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 [mailto: excel-macros@googlegroups.com] *On Behalf Of *SUDHIR VERMA *Sent:* Thursday, August 27

$$Excel-Macros$$ Fwd: REQUIRED SUGGESSTION

2014-12-07 Thread SUDHIR VERMA
-- Forwarded message -- From: sudhir sudhir.ku...@lazerindia.com 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]*

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 newinex...@gmail.com wrote: -- Forwarded message -- From: sudhir sudhir.ku...@lazerindia.com Date: 8 December 2014 at 11:55 Subject

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

2014-10-01 Thread SUDHIR VERMA
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 newinex...@gmail.com wrote: yes i was checked this but not work after alteration

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 rajanverma1...@gmail.com 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, Kindly resolve my problem. Explanation in attached

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 v...@vabs.in 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, SUDHIR VERMA newinex...@gmail.com

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

2014-09-30 Thread SUDHIR VERMA
working through me for you.* On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA newinex...@gmail.com wrote: 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

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 newinex...@gmail.com wrote: 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

$$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 excellearn2...@gmail.com wrote: Hi, Try this.. =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) *Warm Regards,* *Ravi Kumar.* *From:*

Re: $$Excel-Macros$$ need macro

2014-07-28 Thread SUDHIR VERMA
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 24, 2014 at 4:05 PM, SUDHIR VERMA newinex...@gmail.com wrote: Dear

$$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

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 newinex...@gmail.com 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 official Facebook page

$$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

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

2014-02-13 Thread SUDHIR VERMA
-- Forwarded message -- From: SUDHIR VERMA newinex...@gmail.com Date: 12 February 2014 21:34 Subject: $$Excel-Macros$$ COUNT OF RECOVERY DAYS To: excel-macros excel-macros@googlegroups.com Dear All, Please suggest me to prepare recovery days. Better explanation in attachment

$$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.facebook.com

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 koul.ash...@gmail.com 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 umesh...@gmail.com

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 py.har...@gmail.com wrote: Dear Excel Gurus, Please find the attached file Marks Sheet, and i want to obtain the marks

Re: $$Excel-Macros$$ Help Needed

2014-02-03 Thread SUDHIR VERMA
. 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 VERMA newinex...@gmail.com wrote: Dear Harish, Please find

Re: $$Excel-Macros$$ problem

2013-12-23 Thread SUDHIR VERMA
thankx Ashish On 15 December 2013 19:10, Ashish Kumar kumar.ashish...@gmail.com 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, SUDHIR VERMA wrote

$$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-27 Thread SUDHIR VERMA
pls try this On 27/10/2013, SUDHIR VERMA newinex...@gmail.com wrote: On 26/10/2013, Ravinder ravinderexcelgr...@gmail.com 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

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

2013-10-27 Thread SUDHIR VERMA
On 26/10/2013, Ravinder ravinderexcelgr...@gmail.com 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:

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 idforex...@gmail.com 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

$$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

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

2013-10-12 Thread SUDHIR VERMA
thnx On 12 October 2013 22:34, SUDHIR VERMA newinex...@gmail.com 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’s =TIME(2,DO:IT,N:OW) ! Join

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 nikhil201...@gmail.com 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,

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, v...@vabs.in wrote: ** Hi, Welcome Abhishek.. Cheerz... Sent on my BlackBerry® from Vodafone -- *From: * CA Abhishek Agarwal caabhishekagarw...@gmail.com

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 naukrikuld...@gmail.com 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

$$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

$$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

$$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

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 koul.ash...@gmail.com wrote: check the attachment see if it helps On Sun, Jun 3, 2012 at 1:53 PM, SUDHIR VERMA newinex...@gmail.com wrote: Dear All, Please resolved