Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

pls add me 0096892885633 On Sun, Sep 11, 2016 at 9:02 AM, Prabhu Pinky wrote: > i have created this whatsapp group. Prabhu - 9500087194 > > > Thanks & Regards, > Prabhu R > > On 10 September 2016 at 11:10, Learner Excel wrote: > >> Who's making this group, please reply? else I can take initiave

Re: $$Excel-Macros$$ Macro is not working

are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroup

Re: $$Excel-Macros$$ Want to count unique values from duplicate , by VBA or formula please help shiv..

up. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more optio

Re: $$Excel-Macros$$ Click Button on URL using VBA

ppIE.document.getElementByid("gb_70").Click End With End Sub On Thu, Aug 25, 2016 at 7:28 AM, Emamuddin Shah wrote: > Thanks Gaurav, but I don't want to navigate I want it to click that button. > On Aug 25, 2016 6:40 PM, "Gaurav Devrani" wrote: > >>

Re: $$Excel-Macros$$ Click Button on URL using VBA

wrote: > Please suggest solutions... I just started vba crawling > On Aug 25, 2016 6:17 PM, "Gaurav Devrani" wrote: > >> Please disregard my email. >> >> On Thu, Aug 25, 2016 at 6:05 AM, Emamuddin Shah wrote: >> >>> >>> >>&g

Re: $$Excel-Macros$$ Click Button on URL using VBA

rs are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. >

Re: $$Excel-Macros$$ Click Button on URL using VBA

in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > ema

Re: $$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

What do you mean by 49 sheets. I don't think this code have such functionality not to work more than 49 sheets. I am sure you are confused with the code written inside. but still let me know your opinion about 49 sheets. On Tue, Aug 23, 2016 at 3:04 AM, Pravin Gunjal wrote: > Dea

Re: $$Excel-Macros$$ Copy Paste Problem

understand your query. If those are multiple excel files , you can also create a loop on those files using FSO (File system object) and copy that data. Let me know. Waiting for your response Shrini. Regards Gaurav Devrani On Wed, Aug 10, 2016 at 12:40 AM, Shrinivas Shevde wrote: > Dear

Re: $$Excel-Macros$$ Copy Paste Problem

you need to write code to do that process and just paste that data in column A in the attached file that i sent earlier. you can check that code in case you want to know about the range where code is running, Let me know if i am not able to answer your question. Regards Gaurav Devrani 8586932754 On

Re: $$Excel-Macros$$ Copy Paste Problem

Hi Shrini, Please check the attached file. Let me know if this does not solve your query. Regards Gaurav Devrani On Tue, Aug 9, 2016 at 1:37 AM, Shrinivas Shevde wrote: > Dear all > I have data in Column A in 1to 6 rows . I want to copy paste in Column F > but in column F 2 rows are

$$Excel-Macros$$ How to convert Pivot

Dear Expert, I want a macro to convert data from pivot form to normal form. -- J.Gaurav Call-7838594954 -- 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 FOR

Re: Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

Hi All, In my project I am having a requirement to upload file from IE browser browse button. We are invoking this browser through macro in excel VB. HTML code for webpage is :- please share VB code to select any file from my system. Gaurav On Sunday, May 12, 2013 at 2:33:26 PM UTC-7

Re: $$Excel-Macros$$ Macro Require

please support me. On Mon, Feb 29, 2016 at 6:19 PM, jayendra gaurav wrote: > Dear All, > > > I have 1150 separate files of part list Variant wise. and other hand I > have part list can you please suggest way that how can I search part usage > quantity of each part no a

Re: $$Excel-Macros$$ MSG: Code execution has been interrupted

AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-

Re: $$Excel-Macros$$ RE: Help required

ial and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS"

$$Excel-Macros$$ WANT TO open FILE frequently

Team, I want to open some file frequently. is any option available in excel 2013 to create a symbol in menu bar .when ever I open excel same symbol appear on menu bar and when I clicked on the symbol .my file get open. [image: Inline image 1] -- J.Gaurav Call-7838594954 -- Are you =EXP(E:RT)

Re: $$Excel-Macros$$ Re: HOW COMPARE LIST OF FILE WITH EXCEL SHEET

thanks Mandeep. it is perfectly working. On Thu, Apr 16, 2015 at 6:15 PM, Mandeep Baluja wrote: > chk dis out. > > Regards, > Mandeep Baluja > > On Thursday, April 16, 2015 at 5:52:30 PM UTC+5:30, sonu wrote: >> >> Experts, >> >> I want to convert file name in Excel . >> >> for example I have 1

$$Excel-Macros$$ HOW COMPARE LIST OF FILE WITH EXCEL SHEET

Experts, I want to convert file name in Excel . for example I have 100 files in folder and I want to convert all file name in excel. please support. -- J.Gaurav Call-7838594954 -- 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

Re: $$Excel-Macros$$ Re: Populating rows using a range of data

Hi , Please check the attached file. Regards Gaurav Devrani On Wed, Apr 15, 2015 at 3:54 PM, Umar Abeer wrote: > Hi Mandeep, > > Many thanks. It serves the purpose but is there any way we can use > index/match or any range formula to achieve the same? > > BR > Aby > &

$$Excel-Macros$$ Urgent Help

the data except Pivot. To access pivot table data i need a macro to ask for password and then only I should be able to get access of pivot. If it does not make any sense.. Please let me know. i will explain again. Help me Guys.. -- *Thanks & Regards* *Gaurav Devrani* -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ Formula based on some criteria

Hi Rameshwari , Please check the file. Let me know if it does not work for you. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 5:47 PM, Rameshwari wrote: > Hello team, > > I stuck with one formula, please help me on this. Formula based on some > criteria. > > > >

Re: $$Excel-Macros$$ Query for autofit columns.

y, 12 March 2015 14:37:51 UTC+5:30, Gaurav Devrani wrote: >> >> Hi Mandeep, >> >> Please check the attached file. let me know if I am missing something. >> >> >> Regards >> Gaurav Devrani >> >> >> >> On Thu, Mar 12, 2015 at 1:43

Re: $$Excel-Macros$$ Please help me Urgent

,LOWER(MID(A1, >> ROW(INDIRECT("1:"&LEN(A1))),1)),UPPER(MID(A1,ROW(INDIRECT(" >> 1:"&LEN(A1))),1) >> >> Cheers!! >> >> On Thu, Feb 26, 2015 at 8:42 PM, Gaurav Devrani >> wrote: >> >>> Hi Guys, >>> >>

Re: $$Excel-Macros$$ Query for autofit columns.

Hi Mandeep, Please check the attached file. let me know if I am missing something. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja wrote: > Quuery for autofit > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TI

Re: $$Excel-Macros$$ Excel VBA to hide sheets of a workbook closes others too

I am sure that in your code "Index" is referring to the sheet name that you want to unhide. Regards Gaurav Devrani On Wed, Mar 4, 2015 at 7:34 AM, Yahya Muhammad wrote: > > Dears > > Any solution, please ! > > On Mon, Mar 2, 2015 at 11:24 AM, Yahya Muhammad > wr

Re: $$Excel-Macros$$ Please help me Urgent

Hi Paul, Thanks for the amazing macro you sent. it worked like a charm.. Thanks again. Regards Gaurav Devrani On Fri, Feb 27, 2015 at 1:04 AM, Paul Schreiner wrote: > Are you wanting a macro made to work like a function? > Like: > > =CaseSwap(A1) > > where CaseSwap is: &

Re: $$Excel-Macros$$ Please help me Urgent

Thanks Paul for your quick reply. Yes I was also trying to create a macro but Just wanted to confirm before, if that's possible in excel functions. No worries. I really appreciate your quick response once again. Thank you. Regards Gaurav Devrani On Thu, Feb 26, 2015 at 10:16 PM, Paul Schr

$$Excel-Macros$$ Please help me Urgent

Hi Guys, I have a query . In this sentence.. "This iS a tEst" . All Upper case alphabets should be lower case and All Lowercase alphabets should be in Upper case. Please help me . I want that to be done in excel formulas.(If thats possible). Thanks & Regards Gaurav Devrani --

Re: $$Excel-Macros$$ Excel Tip

Superb Vaibhav. Thanks for sharing this with us. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 11:25 PM, Chandan Bisht wrote: > Hi. > > Very nice... > > Thankx & Rgds, > > Chandra Singh Bisht > > > > On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi wrote:

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

Try this in B5 of sheet2 and drag right. =IF((COLUMN()-1)<=Sheet1!$B$3,Sheet1!$B$2,IF((COLUMN()-1)=Sheet1!$B$3+1,SUM(OFFSET($A$5,,1,,Sheet1!$B$3)),"")) On Mon, Feb 23, 2015 at 7:29 AM, Gaurav Devrani wrote: > Yes Sure.. I will get back to you with that formula. No worr

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

Yes Sure.. I will get back to you with that formula. No worries. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 7:25 AM, Enock Wangila wrote: > Hi Gaurav, > > Thank you for you help. Quick question, is there a way of using a formula > instead of a code to do what you have done.

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

Hi , I guess you also want to merge the header cells in sheet 2 for all entries.. Please refer to this new sheet. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani wrote: > HI Enock, > > Please check the attached file and let me know if I missed

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

HI Enock, Please check the attached file and let me know if I missed something. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila wrote: > Hi Guys, > > I want a formula that populates values in a worksheet, on a single row > based on two values entered on

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

okay... Thanks Vaibhav. On Sat, Feb 14, 2015 at 5:43 AM, Vaibhav Joshi wrote: > I mean free file.. > > On Fri, Feb 13, 2015 at 8:39 PM, Gaurav Devrani > wrote: > >> Hi Vaibhav, >> >> What is FF? Can you please tell me ? Dont have any idea about that please. &

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

Hi Vaibhav, What is FF? Can you please tell me ? Dont have any idea about that please. On Fri, Feb 13, 2015 at 8:04 AM, Vaibhav Joshi wrote: > Cheers, also you could have created FF & save it as .doc. > > > > On Fri, Feb 13, 2015 at 8:21 PM, Gaurav Devrani > wrote: >

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

Cool. :) On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant wrote: > Thaks for the complete answer, it works like a charm! > > On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devrani > wrote: > >> >> Hi, >> >> Please check the file , >> >> On Wed

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant wrote: > Variables identified as type = "double" should be treated differently in > order to adjust to a expected format... > > On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani > wrote: > &

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

oups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Thanks & Regards Gaurav Devrani -- Are you =EXP(E:RT) or =NOT(

Re: $$Excel-Macros$$ multi mailer

. Thanks. Thanks Gaurav On Mon, Feb 2, 2015 at 10:04 PM, Anil Gawli wrote: > Dear Gaurav, > > Pls share the file > > regards, > Anil > > On Tue, Feb 3, 2015 at 10:25 AM, Gaurav Devrani > wrote: > > Can anyone help me on this? I have a specific data and want to send tha

$$Excel-Macros$$ multi mailer

more emails) Please. Hope I was clear enough to explain. -- Thanks Gaurav -- 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

Re: $$Excel-Macros$$ Copy & Paste only particular to another sheet

l the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Gaurav Devrani > *To:* excel-macros@googlegroups.com > *S

Re: $$Excel-Macros$$ Copy & Paste only particular to another sheet

enough to explain. Thanks Gaurav On Mon, Feb 2, 2015 at 5:43 AM, Ashish Bhalara wrote: > Thank you very muc Mr.Vaibhav & Mr.Gaurav > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. > Spread environmental üaw

Re: $$Excel-Macros$$ Copy & Paste only particular to another sheet

And Please check the filter again. I guess I dint put that filter on the entire sheet. Please select true values as well and then filter it again. Sorry for the wrong file. On Mon, Feb 2, 2015 at 5:24 AM, Gaurav Devrani wrote: > :) > > On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav Jos

Re: $$Excel-Macros$$ Copy & Paste only particular to another sheet

:) On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav Joshi wrote: > Great Tip by Gaurav.. > > On Mon, Feb 2, 2015 at 5:49 PM, Gaurav Devrani > wrote: > >> Please check the attached file, Let me know If I am missing on something. >> I guess you were trying to copy only those ro

Re: $$Excel-Macros$$ Copy & Paste only particular to another sheet

Please check the attached file, Let me know If I am missing on something. I guess you were trying to copy only those rows. which contains no error.. if not. let me know. Regards Gaurav On Mon, Feb 2, 2015 at 5:09 AM, Ashish Bhalara wrote: > Dear Vaibhavji, > > Thanks to reply, my

Re: $$Excel-Macros$$ Wish u all A Merry Christmas

stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ kindly UNLOCK MY EXCEL FILE

TEAM, I have forgotten my password.kindly unlock the same . its very urgent . -- J.Gaurav Call-7838594954 -- 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 FO

$$Excel-Macros$$ Fwd: FW:

Team, I have two excel file attached here which are password protected .but i have forget the password . kindly support me and any one help me to open this file . thanks regards Gaurav -- Forwarded message -- From: GAURAV Jayendra (CNH Industrial) Date: Mon, Aug 11, 2014 at

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

Hi guys, I get the #value error inspite of running it for the first time in the day. That is as soon as I enable the macro. When the macro is disabled, which is when i just downloaded the file, I can see the distance perfectly well. Can someone please help? Regards Gaurav On Saturday

Re: $$Excel-Macros$$ Fiscal Period calculation

find the formula closing date Fiscal Period1-Jan-12 Q1-2012 =+IF(MONTH(B6)<=3,"Q1",IF(MONTH(B6)<=6,"Q2",IF(MONTH(B6)<=9,"Q3",IF(MONTH(B6)<=12,"Q4",""&"-"&YEAR(B6) 2-May-12 Q2-20125-Sep-12 Q3-20126-Oct-12 Q4-2012 1-Jan-13 Q1-2013 -- Are you =EXP(E:RT) or =NOT(E

Re: $$Excel-Macros$$ Tutorial on SQL

Hello Friends, ** ** Does anyone have training material on VBA? Could you please share. ** ** In case if anyone knows about any good site for the same please share link.* *** ** ** Best Regards, GAURAV GARG ** On Tue, Jun 11, 2013 at 4:03 PM, కిరణ్ కొత్తకోట wrote: > h

Re: $$Excel-Macros$$ How to Use Conditional SUMIF

egroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- *GAURAV GARG* *Asstt. Manager* *Retai

Re: $$Excel-Macros$$ Support -

how can i do it On Wed, Mar 13, 2013 at 7:37 PM, Sam Mathai Chacko wrote: > Why don't you just create a shortcut pointing to your file? > > > On Wed, Mar 13, 2013 at 7:34 PM, jayendra gaurav < > jayendra.gau...@gmail.com> wrote: > >> Dear All, >> >

$$Excel-Macros$$ Support -

Dear All, I need to open one exel file frequently .I require one icon on my tool bar where if I clicked then my file need to open. this feature was available in exel 2003. kindly support me. -- J.Gaurav Call-7838594954 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I

Re: $$Excel-Macros$$ For one workbook to another workbook

Dear Experts i have one sheet in this sheet there is a hyperlink , i want that it should be blink. it may possible through by VBA coding.can anyone help me for solve this problem . *GAURAV GARG* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

$$Excel-Macros$$ Re: support

pls support me On Tue, Aug 7, 2012 at 5:36 PM, jayendra gaurav wrote: > Team, > > I am using excel 2007. > > I have one file .i need one icon for all excel work book where i click > and that file need to open. > > > > > -- > J.Gaurav > Call-78385

$$Excel-Macros$$ support

Team, I am using excel 2007. I have one file .i need one icon for all excel work book where i click and that file need to open. -- J.Gaurav Call-7838594954 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for

$$Excel-Macros$$ support - pivot table log.

Team, I wan to maintain a log for pivot table. example - when I click on refresh button that time old data save in log file. -- J.Gaurav Call-7838594954 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for viola

$$Excel-Macros$$ How to count

Team, How to count a cell based on color . file is attached for your's reference. -- J.Gaurav Call-7838594954 -- -- 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, C

$$Excel-Macros$$ unhide all sheet

Dear Team, I required your support to unhide 20 sheets in single go. kindly support me . -- J.Gaurav Call-7838594954 -- 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,

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 2 Messages in 2 Topics

Please remove me from this group Sent from my iPhone On May 8, 2012, at 6:23 PM, excel-macros@googlegroups.com wrote: > Today's Topic Summary > Group: http://groups.google.com/group/excel-macros/topics > > Table data fit the page size..(auto) [1 Update] > To create a serial number based on s

$$Excel-Macros$$ kindly suggest me how can I Unhide all the hide sheet in a single go.

Team, I have hide 50 sheet in a work book kindly suggest me how can I Unhide all the hidden sheet in a single go. -- J.Gaurav Cell - 9327348097 -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ difference time calculation

Dear team, Kindly help me in this regards -- J.Gaurav Operation Manager -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join o

$$Excel-Macros$$ down load data from BSE/NSE

Dear Group. I want to basically fetch historical data of stock markets - derivatives - from the website of NSEINDIA.COM , please help me -- J.Gaurav -- -- Some important links for excel u

Re: $$Excel-Macros$$ Conditional formating help

dlearn.co.uk/excel2007/excel2007s6p2.html > On Fri, Apr 15, 2011 at 9:54 AM, jayendra gaurav < > jayendra.gau...@gmail.com> wrote: > >> >> >> >> Dear all , >> >> >> >> please find herewith attached file .I want some help about condition

$$Excel-Macros$$ Conditional formating help

Dear all , please find herewith attached file .I want some help about conditional formating. Matter is urgent. -- J.Gaurav Cell - 9327348097 -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ Problem on picking series in chart

have attached spreadsheet for reference (raw data and not with checkboxes). Please help. Thanks Gaurav -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

Achieve excellence in excel !!! On Tue, Feb 22, 2011 at 9:59 PM, Ayush Jain wrote: > Dear members, > > I am too excited to share that discussexcel.com website development is in > good progress and we are ready to launch the website on 4th Anniversary of > our Google group. i.e. 16th -17th March.

$$Excel-Macros$$ pls add my email address for excelmacros mails

Dear Admin, Can you please add me for the excelmacros mails, my email address is gau...@omanairports.com. Thanks & regards, Gaurav Bansal Muscat, Oman -- -- Some important links for excel users: 1. Follow u

Re: $$Excel-Macros$$ Thank you Dave Bonallack !!

Any VBA developer in NCR, India looking for job change. Fwd your resume to gauravhpah...@gmail.com by 10th Aug, 2010. On Wed, Aug 4, 2010 at 10:49 AM, Dave Bonallack wrote: > Thanks Dilip. > Dave. > > -- > Date: Tue, 3 Aug 2010 20:43:16 +0530 > Subject: Re: $$Excel-Ma

Re: $$Excel-Macros$$ Show a Form in VSTO Excel

elect Text Data File") Globals.ThisWorkbook.Application.Workbooks.OpenText(Fname, , 1 ) End Sub Thanks & Regards, Gaurav Jain On Tue, Jul 20, 2010 at 9:18 PM, Leandro wrote: > Hi Gaurav, maybe you can help again. Leveraging your knowledge. > > In my project, described before, i

Re: $$Excel-Macros$$ Show a Form in VSTO Excel

uot;A1:D1").Value = x MsgBox(Globals.Sheet1.Range("A1").Value) End Sub It think it will help u. Cheers, Gaurav Jain On Fri, Jul 16, 2010 at 5:06 PM, Leandro wrote: > Thanks Gaurav for reply. The form loaded right, the first doubt was > solved. > > I have another one,

Re: $$Excel-Macros$$ Show a Form in VSTO Excel

Hi Leandro, Use this Code: *Dim frm as New Form_Name* *frm.ShowDialog* This code will work for u. Cheers, Gaurav Jain On Thu, Jul 15, 2010 at 9:15 PM, Leandro wrote: > I am new in VSTO and have a doubt. > > I´ve created a project using VS2008. This is a VSTO in fact. I have >

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

Hi Dilip, Can u explain how u did 25-30,30-35 in pivot table & chart? Thanks & Regards, Gaurav Jain On Tue, Jul 13, 2010 at 8:30 PM, Dilip Pandey wrote: > Hey Ahmed.. the "Honest" man.!! :) > > You are most welcome to share the knowledge and experience(s) and o

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

Hi Radhe, PFA the attached solution Regards, Gaurav Jain On Wed, Jun 30, 2010 at 2:54 PM, Radhe Sham wrote: > Hi Andy, > > Thanks for the quick reply. > > The requirement however is to get the output in another sheet wherein the > summary of the products is mentioned in th

Re: $$Excel-Macros$$ Urgent Help needed regarding using macro

Hi Dilip, Discription is nice one. Cheers, Gaurav Jain On Sat, Jun 26, 2010 at 11:15 PM, Dilip Pandey wrote: > Hi Swapnil, > > Below is a little explanation of the formula which I had used:- > Hope you will like it :) > > SUMPRODUCT(--($A$2:$A$483=A2),--(D2<$D$2:$D$483)

Re: $$Excel-Macros$$ Fwd: Data requeired in sumproduct please help me friends !!!!!!!!!!!!

Hi all, Please find attached workbook for solution of this problem. Thanks & Regards, Gaurav Jain On Mon, Apr 19, 2010 at 4:04 PM, GAURAV JAIN wrote: > Hi all, > > Please find attached workbook for solution of this problem. > > Thanks & Regards, > Gaurav Jain >

Re: $$Excel-Macros$$ Fwd: Data requeired in sumproduct please help me friends !!!!!!!!!!!!

Hi all, Please find attached workbook for solution of this problem. Thanks & Regards, Gaurav Jain On Mon, Apr 19, 2010 at 2:36 PM, Rajesh Nair wrote: > > > -- Forwarded message -- > From: Rajesh Nair > Date: Fri, Apr 16, 2010 at 4:16 AM > Subject: Data

Re: $$Excel-Macros$$ Permutations and combinations

Hi All, I think in my attachment u will get your solution. Thanks & Regards, Gaurav Jain On Fri, Apr 16, 2010 at 10:33 AM, Vikas Chouhan wrote: > hijust chk > > On Thu, Apr 15, 2010 at 12:51 AM, MD18358 wrote: > >> Hi All: >> >> I don't want the &qu

Re: $$Excel-Macros$$ Need help in function

Hi, Ashish Koul is right. His formula is working prefectly fine. Superb Ashish. Cheers Gaurav Jain On Tue, Apr 6, 2010 at 10:44 AM, seema mba wrote: > Hi, > > I have attached your sheet with formula for finding the difference in > minutes. > > I have used the formula

Re: $$Excel-Macros$$ VLOOKUP to check for multiple occurences of lookup value.

Thanks for your help Chris, The implementation is great. I would now look to convert this to a VBA function or subroutine. Thanks again for your help. Gaurav!! -- -- Some important links for excel users: 1

Re: $$Excel-Macros$$ VLOOKUP to check for multiple occurences of lookup value.

a bit and would post it here soon. Let me know if we have any other implementation. Thanks for your help. Gaurav! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

$$Excel-Macros$$ VLOOKUP to check for multiple occurences of lookup value.

ith VLOOKUP and MATCH but nothing seems to have helped with this. After getting this done I would want to implement the solution through VBA. Any help with this is greatly appreciated. Thanks for the help in a

Re: $$Excel-Macros$$ HOW CAN I WORK IN ONE WORKBOOK IN MULTIPLE LOCATION

Try Share workbook function in Tools menu but it is complicated as well as quit dangerous fuction becoz unlimited user can work on same sheet at same time u may facing problem of data loss regards Gaurav On Mon, Jan 11, 2010 at 3:29 PM, Anant Shelke wrote: > > Hi, > > I want s

$$Excel-Macros$$ use of macros

Can any body explain use of macros in an excel sheet. explain in details thanks in advance -- CA Gaurav Rustagi Assistant Manager-Finance The Bristol Hotel Adjacent to DLF Qutab Enclave, Phase I, Gurgaon-122002 Haryana Mobile 93 13 19 82 81 Tel0124 2356030, 435 Fax 0124

$$Excel-Macros$$ Find the second highest no.

Hi,, How to fnd the second highest no. in a grop of 10 No. using formulae. For eg. 12 3 45 1 18 90 15 76 99 9 the result should be 90. Can any1 hlp out with this? --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: How to convert number into hrs & min.

Use the Formula =INT(A4/60)&"Hr"&" "&(((A4/60)-INT(A4/60))*60)&"min" replace A4 by the cell refrence in your sheet. It can be modified further if you need, just drop me a mail Thanks n Regards Gaurav Banerjee 2009/8/9 Prasad Gadgil > *Dear Al

$$Excel-Macros$$ Re: Using range names in formulas

On Wed, Jun 24, 2009 at 4:48 PM, jander wrote: > > (I've been told that my previous post was confusing, so I'll try > again.) > > Suppose I have 2 columns, one contains odd numbers, the other even > numbers. They are named ranges "Odd" and "Even", respectively. > > A B

$$Excel-Macros$$ Re: test mail

pls help me. On Sat, May 2, 2009 at 9:46 AM, jayendra gaurav wrote: > > Dear all > Pls help me for below point.in attached file > > > 1. When chage the calender year the data reamins same on that day. 2. > Required daily task( TO DO) to be cary forward next day if

$$Excel-Macros$$ Re: Fwd: mACRO HELP

> Dear All, > > Can you please help me write a macro to simplify finding the packing list. > The required files are attached for your reference. The tedious job that we > do is as under: > > >- Fin`ding the container number PONU7259344 from the daily vehicle >entry file an excel file >-

$$Excel-Macros$$ Re: Fwd: mACRO HELP

Dear Ashis , U helps to all member ,pls help me also.Mateer is most urgent > > > >> Dear All, >> >> Can you please help me write a macro to simplify finding the packing list. >> The required files are attached for your reference. The tedious job that we >> do is as under: >> >> >>- Fin`ding

$$Excel-Macros$$ Re: Fwd: mACRO HELP

Still I am waiting ..Pls Help me in this regards.matter is most urgent. > Dear All, > > Can you please help me write a macro to simplify finding the packing list. > The required files are attached for your reference. The tedious job that we > do is as under: > > >- Fin`ding the co

$$Excel-Macros$$ Fwd: mACRO HELP

Dear All, Can you please help me write a macro to simplify finding the packing list. The required files are attached for your reference. The tedious job that we do is as under: - Fin`ding the container number PONU7259344 from the daily vehicle entry file an excel file - based on the con

$$Excel-Macros$$ Re: Hi I would require help on vlookup with search option

nice!!! On Fri, Apr 3, 2009 at 8:33 PM, Alpesh Juvarewala wrote: > Hi, > Pls find the attached solution. The trick is to use wild card > character. The limitation is that the text should not be repeated in > any other cell or else the result may not be as per expectation. > > > > 2009/4/3 hari

$$Excel-Macros$$ Re: need some help in number of occupied cells

hi i am beginner in Excel VBA Programming. if some one has material on the programming send me. Gaurav Rustagi B.Com, CA, CS On 3/27/09, xxx wrote: > > > thank you > > On Mar 27, 2:32 pm, Tom Jeffries wrote: > > This should do what you want: > > Public Su

$$Excel-Macros$$ Re: Help required Colour on Rows and Column

U can use conditional foramating. On Wed, Mar 25, 2009 at 4:17 PM, Sachin Shukla wrote: > Dear All, > > Please help me on said subjects . I attached sheet for same problem. > > Thanks in Advance > > > Sachin Shukla > Business Analyst > New Delhi > > > > -- J.Gaurav Asst. Manager Mahindra logi

$$Excel-Macros$$ Re: Calling all Wizard - Help needed in attached file

Where is sc file ??. On Wed, Feb 25, 2009 at 6:25 AM, Tom Jeffries wrote: > Take a look at the attached workbook and see if it does what you want. I > placed buttons on the "SC" worksheet for each function you describe. I > wasn't sure how you wanted to export the SC worksheet as text so I exp

$$Excel-Macros$$ Re: How to break the vba project password

hi guys great being on this group can u unsubscribe me for now regards gaurav On Thu, Mar 19, 2009 at 10:16 AM, Ashish Jain <26may.1...@gmail.com> wrote: > > --- > > Mr. Hari, > > Mr. Hacker

$$Excel-Macros$$ Re: problem deleting last cell in a specific row

U can also use filter option rgd Gaurav On Wed, Feb 25, 2009 at 11:23 AM, Lavprasad Kori wrote: > Hi Dear, > > Attached herewith the file of solution of your question. In that the > solution is in column E. You have to copy Column E & paste special it in > Column D. > &g

  1   2   >