$$Excel-Macros$$ HOTLIST of Bench candidates

Consultant Immediately If you have any suitable job position for them please mail me at ravin...@nuvento.com <mailto:ravin...@nuvento.com> or call me at +1 609 212 1884 Thanks & Regards Ravinder Yadav Nuvento System LLC US : +1 609 212 1884 <http://www.nuvento.com/>

$$Excel-Macros$$ Hotlist/Bench list

com> or call me at +1 609 212 1884 Thanks & Regards Ravinder Yadav Team Lead Nuvento System Pvt Ltd. <http://www.nuvento.com/> www.nuvento.com +1 609-212-1884 -- 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 offici

$$Excel-Macros$$ Hotlist/Benchlist

IndianaPolis, IN Data scientist Immediately If you have any suitable job position for them please mail me at ravin...@nuvento.com <mailto:ravin...@nuvento.com> or call me at +1 609 212 1884 Thanks & Regards Ravinder Yadav Team Lead Nuvento System Pvt Ltd. <http://ww

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

On Saturday, September 3, 2016 11:42 AM, GENIUS wrote: THANK YOU VERY MUCH MR GAURAV DEVRANI AND ALSO THANKS FOR MR XLS S for a new way of doing the same. -- 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$$ Sumif multiple column

PFA On Friday, August 26, 2016 10:52 AM, Deepak Rawat wrote: Hi, Need sumif function to sum multiple columns sample excel attached. Regards,Deepak -- 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$$ Rename all sheets of one excel file in single shot with different names

PFA On Tuesday, August 23, 2016 2:35 PM, Pravin Gunjal wrote: Dear Gaurav Thanks for solution. You have created a sheet viz. Tab-Names and then used two macros based on requirement. But my worry is that in every month number of sheets are getting changed and I

Re: $$Excel-Macros$$ VBA Macro for PPT Chart objects content edit (inside)

dim ppApp  As PowerPoint.Applicationdim ppReport   As PowerPoint.Presentationdim ppSlide  As PowerPoint.Slidedim oPPTOLEObject_Text   as object Set ppReport = ppApp.Presentations.Open("PPT Path")                    ppApp.Visible = msoTrue                    'Filling text boxes in ppt            

Re: $$Excel-Macros$$ Re: overflow error issue

Hi Integer has as limit 32767 more than it it will show overflow error so you have to use long variable.  ThanksRavinder Negi On Wednesday, February 24, 2016 1:11 PM, Kat wrote: Hi Mandeep, I don't know how to use VLookUp function for my situation. I was

Re: $$Excel-Macros$$ Excel function for TC_Name with Priority.

Hi, please use below formula =IF(IFERROR(SEARCH("_H_",A2),0)>0,"High",IF(IFERROR(SEARCH("_M",A2),0),"Medium","Low"))  or attached file On Saturday, December 12, 2015 5:08 AM, Sairam Prasath wrote: Hi All,I need the excel formula for the following. | TC_Name |

$$Excel-Macros$$ Help needed

Hi All, Please help me in the attached data, please share also the way to resolve it. Regards, Ravindra -- 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$$ Conditional formatting

PFA, if you are looking for this. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of N.Shivkumar Sent: Monday, June 16, 2014 11:13 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Conditional formatting Dear friends Can anybody throw

RE: $$Excel-Macros$$ Re:Date conversion

Try below =TEXT(DATE(RIGHT(B14,4),MID(B14,4,2),LEFT(B14,2)),DD-MMM-YY) -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohd Sanusi Mohd Noor Sent: Friday, June 13, 2014 2:56 PM To: excel-macros@googlegroups.com Subject:

RE: $$Excel-Macros$$ How to pause the Excel VBA macro at certain point and then start again

Did you try below code for waiting browser. Do while browser.busy or browser.readystateREADYSTATE_COMPLETE Doevent loop From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sukanta Datta Sent: Tuesday, June 10, 2014 7:39 PM To:

RE: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

$$ Outlook Mails log in Excel through MACRO Hi, Thanks Anil Ravinder but I need to make log in Excel with details of To, From, CC, Subject, Date, Time etc. and all data of Outlook mails is saved in Hard Drive with the name of Incoming Outgoing. please look at output sample : To CC From

RE: $$Excel-Macros$$ last sunday of the month?

=TEXT(MAX((TEXT((ROW(INDIRECT(A1:EOMONTH(A1,0,DDD)=sun)*(ROW(IND IRECT(A1:EOMONTH(A1,0),DD/MM/) With c+S+E From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] Sent: Thursday, June 05, 2014 12:55 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

RE: $$Excel-Macros$$ Need a small help in VBA coding

You can use something like this, u just need again navigate browser with same link (test.com), I think It will open a new blank form (see yellow part) Sub test() Dim IEApp As New InternetExplorer ' Set IEApp = CreateObject(InternetExplorer.Application) IEApp.Visible = True

Re: $$Excel-Macros$$ E book related..

Please download VBA EBOOK from below link http://excelvbasupport.com/forum/showthread.php?tid=66pid=144#pid144 On Mon, May 12, 2014 at 12:46 PM, Renukachari Kasee jva.ch...@gmail.comwrote: Dear Group, any one please provide the ebook for excel macros i.e. 101 READY-TO-USE EXCEL MACROS

$$Excel-Macros$$ VBA Interview Questions

Hi, please download VBA Interview Questions from below link http://excelvbasupport.com/forum/showthread.php?tid=64 Thanks Regards -- 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 @

RE: $$Excel-Macros$$ Specific Worksheet sohuld focus

You can put your code on workbook_open event and activate sheet2 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajeev Sent: Tuesday, May 06, 2014 11:57 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Specific Worksheet sohuld focus

Re: $$Excel-Macros$$ Value need to update as per master (excel sheet Attached)

pls clear ur query On Wed, Apr 30, 2014 at 5:32 AM, rameshwari shyam rameshwarish...@gmail.com wrote: Dear Team, Please advice on below query. I have one target% and as per target% value need to change. For example if my target% is 12.50 then next Coolum need to fill as per my target%

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done

Re: $$Excel-Macros$$ please help for consolidate in excel

Please see below link for your query.. u just need to select folder where u have saved the files. please dont save example file in data files folder http://excelvbasupport.com/forum/showthread.php?tid=17 On Sat, Apr 26, 2014 at 11:18 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Yadav, you

$$Excel-Macros$$ Please Visit below link for All Shortcuts including Excel

Please visit this link for All Shortcuts Keys including Excel http://excelvbasupport.com/forum/showthread.php?tid=4 -- 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 @

RE: $$Excel-Macros$$ How to share Code/Macro ?

Pls visit below link for solution http://excelvbasupport.com/forum/showthread.php?tid=8 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Suyog Kulkarni Sent: Saturday, April 26, 2014 2:40 PM To: excel-macros@googlegroups.com Subject:

$$Excel-Macros$$ shortcut keys to increase efficiency of daily work in Excel

just visit below link;-- http://excelvbasupport.com/forum/newthread.php?fid=7processed=1 Thanks Regards Ravinder Negi -- 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 a code to update the non existing data

hi, please visit below link for your solution, please advise if anything else required. http://excelvbasupport.com/forum/showthread.php?tid=15 Note I have checked only code number. On Sat, Apr 26, 2014 at 7:20 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Team, I need to update the data in

RE: $$Excel-Macros$$ Need new Workbook create using Macros

Pfa,…first click on button and then select where u want to save file. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of kapil Gupta Sent: Monday, April 21, 2014 8:48 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need new Workbook create

RE: $$Excel-Macros$$ Need new Workbook create using Macros

[mailto:excel-macros@googlegroups.com] On Behalf Of Ganesh N Sent: Tuesday, April 22, 2014 12:02 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need new Workbook create using Macros Hi Ravinder sir, Can you please explain about the collections and below line of code how

RE: $$Excel-Macros$$ concatenation url

You have to give ; in double quote lik e ”;”, you gave without double quote (pass ;) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Monday, April 21, 2014 2:53 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

RE: $$Excel-Macros$$ Re: Need VBA Code to extract pdf file from URL.

Where is attachement? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish Sent: Sunday, April 20, 2014 5:33 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need VBA Code to extract pdf file from URL. you need to run a loop and

$$Excel-Macros$$ RE: [XL-VBA Clinic] VBA-For Next

PFA...first select range of heading as I have already selected in file. From: excelvbacli...@googlegroups.com [mailto:excelvbacli...@googlegroups.com] On Behalf Of Prafull Jadhav Sent: Wednesday, April 09, 2014 2:49 PM To: excel-macros@googlegroups.com; excelvbacli...@googlegroups.com Subject:

RE: $$Excel-Macros$$ Validation on button click

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Thursday, April 03, 2014 10:45 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Validation on button click Hello Experts, I need your kind, I have attache sheet

RE: $$Excel-Macros$$ Arrow solution

=IF(D2C2,q,IF(D2C2,p,tu)) try with font Webdings 3 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Thursday, April 03, 2014 11:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Arrow solution

RE: $$Excel-Macros$$ Validation on button click

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Thursday, April 03, 2014 12:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Validation on button click Dear Ravinder, Thanks but provided micro

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library

RE: $$Excel-Macros$$ Macro for data indexing

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deepak Rawat Sent: Wednesday, April 02, 2014 11:51 AM To: excel-macros Subject: $$Excel-Macros$$ Macro for data indexing Dear friends, I attached a sheet it has a data set A I need to

RE: $$Excel-Macros$$ Need macro for repetative formatting

Provid any data and your 10 steps which u want to do after download data from software From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Suyog Kulkarni Sent: Tuesday, April 01, 2014 7:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

RE: $$Excel-Macros$$ Help Required Urgent

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Neeraj Chauhan Sent: Wednesday, April 02, 2014 4:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required Urgent Dear experts, Kindly find the attached sheet. _

RE: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bipin Singh Sent: Thursday, April 03, 2014 1:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values Rashid Sir, Hope

Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG

RE: $$Excel-Macros$$ Save only a few sheets

Pls provide attachement From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Stefano Tagliaferri Sent: Friday, March 28, 2014 12:05 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Save only a few sheets Hello! Sorry for my English

RE: $$Excel-Macros$$ extracting zip codes from addresses

=LEFT(TRIM(RIGHT(SUBSTITUTE(B2, ,REPT( ,100)),200)),SEARCH( ,TRIM(RIGHT(SUBSTITUTE(B2, ,REPT( ,100)),200 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of joseph liech Sent: Friday, March 28, 2014 3:18 PM To: excel-macros@googlegroups.com Subject: Re:

RE: $$Excel-Macros$$ How to show numeric number larger than 20 digits in CSV file

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ram sharma Sent: Thursday, March 27, 2014 11:17 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to show numeric number larger than 20 digits in CSV file i have 20 digit number

RE: $$Excel-Macros$$ query2

Pfa,, Type:=8 refer to range From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Pinky Sent: Sunday, March 16, 2014 12:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ query2 hi experts, PFA, i have few names in sheet 1, my

RE: $$Excel-Macros$$ query need help

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Pinky Sent: Sunday, March 16, 2014 8:02 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ query need help Hi experts, please find the attached file. my query is. i want

RE: $$Excel-Macros$$ Copy paste from PDF File

U can use f2 then paste From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: Saturday, March 15, 2014 3:54 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Copy paste from PDF File Dear All I want to copy 3 lines

Re: $$Excel-Macros$$ Average Graph

pls provide some example in excel with chart On Saturday, March 15, 2014 8:12 AM, Abhishek Jain abhishek@gmail.com wrote: Does this make any sense? On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear All , Day before Yesterday I had gone for

RE: $$Excel-Macros$$ Validation cells

:47 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Validation cells Dear Ravinder, I have learnt lot from you. you have help me before. this time you have give awesome formulas for mobile and email column. just one query DOB Column don't accepts any date format, I have

$$Excel-Macros$$ Differenent text returns using Cell(format address) formula in excel.

Screen Clipping -- 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, like Please Help,

RE: FW: $$Excel-Macros$$ Conditional Formating

To: excel-macros@googlegroups.com Cc: Soum Subject: Re: FW: $$Excel-Macros$$ Conditional Formating Dear Sir, It is not working.. Please let me know how I can select the all cell in sheet where cell format is % Regards, Prafull Jadhav 9920553518 On 14 March 2014 15:12, Ravinder

RE: FW: $$Excel-Macros$$ Conditional Formating

code ;which will select the all cell in sheet where cell format is 0.00% Regards, Prafull Jadhav 9920553518 On 14 March 2014 15:31, Ravinder ravindervbacli...@gmail.com wrote: You just select the whole range of tables and put condition formatting as already applied on $A$1:$L$21, you can

RE: $$Excel-Macros$$ Validation cells

Pfa. try this may be you like...I have put data validation till 20th row you can increased as per your requirement. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Thursday, March 13, 2014 9:49 AM To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ additional row creation

PFA, just select first complete row From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of E J Sent: Friday, March 14, 2014 4:03 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ additional row creation Hi Everyone, I was wondering if I

RE: $$Excel-Macros$$ Macro to insert an empty row whenever there is a change in value from the cell above

Pfa, if help From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aaron Hoffman Sent: Wednesday, March 12, 2014 11:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro to insert an empty row whenever there is a change in value from the

RE: $$Excel-Macros$$ Macro to insert an empty row whenever there is a change in value from the cell above

) lrow = rng.Rows.Count frow = rng.Row For a = lrow To frow Step -1 If a frow Then If Range(a a) Range(a a).Offset(-1, 0) Then Range(a a).EntireRow.Insert End If End If Next End Sub On Wednesday, March 12, 2014 12:51:24 AM UTC-6, ravinder

RE: $$Excel-Macros$$ Inserting Scroll Bar

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Wednesday, March 12, 2014 5:03 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Inserting Scroll Bar In the attached file when I click on scroll bar for each 5 row

RE: $$Excel-Macros$$ Help me for interview : Excel Formulas and Macros

IN WHICH COMPANY... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KATHIRVELAN N Sent: Saturday, March 08, 2014 6:41 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help me for interview : Excel Formulas and Macros Dear Friends, I

RE: $$Excel-Macros$$ Hyperlink formula for horizontal Search

PFA... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Friday, February 28, 2014 3:18 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hyperlink formula for horizontal Search Dear All Experts I required Hyperlink

RE: $$Excel-Macros$$ Hyperlink formula for horizontal Search

Thanks dear.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prafull Jadhav Sent: Friday, February 28, 2014 3:44 PM To: excel-macros@googlegroups.com Cc: Soum Subject: Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search Great Ravinder Sir

RE: $$Excel-Macros$$ Need Help to create Macro.

Thanks From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Kumar Sent: Thursday, February 27, 2014 4:21 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Help to create Macro. Dear Ravinder Sir, Sheet is Working perfect

RE: $$Excel-Macros$$ Macro Required

Pfa , first select a column till values in sheet 1 and then select range a2 in sheet2 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prafull Jadhav Sent: Wednesday, February 26, 2014 3:08 PM To: excel-macros@googlegroups.com;

RE: $$Excel-Macros$$ VBA Code to access pictures from drive C

drive C EXCELLENT BOSS 100% OF WHAT I WAS ASKING FOR, THANK YOU VERY MUCH, just a slight issue, when i change a picture, it doesnt show unless you click on the picture, immediately you remove the mouse it goes off. can you help out thanks. On Mon, Feb 24, 2014 at 5:50 AM, Ravinder

RE: $$Excel-Macros$$ Rounding up or down

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rags R Sent: Tuesday, February 25, 2014 10:18 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Rounding up or down Hi, Need formula for rounding up number (i.e. 307,077 to 307,100

RE: $$Excel-Macros$$ Dependent Combo box

PFA. IF HELPS From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Saturday, February 22, 2014 4:51 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dependent Combo box Hi Expert, I need your help, I have one multipage

RE: $$Excel-Macros$$ Repeat the Number Series based on the Vlookup Number

PFA...without helping col. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Swapnil Palande Sent: Monday, February 17, 2014 11:24 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Repeat the Number Series based on the Vlookup Number

RE: $$Excel-Macros$$ CALCULATE DATE FROM THE GIVEN NUMBER - 25th day Date from today

=TODAY()+A2 DAYS RESULT 20 5-Mar-14 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KATHIRVELAN N Sent: Thursday, February 13, 2014 10:30 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ CALCULATE DATE FROM THE GIVEN NUMBER -

RE: $$Excel-Macros$$ Help on sumif function

=SUMIFS(B2:B22,A2:A22,=D6,A2:A22,=E6) OR PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: Thursday, February 13, 2014 9:28 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help on sumif function Dear

RE: $$Excel-Macros$$ calculate previous month dates using the given date

Pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sundarvelan N Sent: Tuesday, February 11, 2014 2:54 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ calculate previous month dates using the given date I need, 2 Jan to 1 Feb

RE: $$Excel-Macros$$ Auto 2 rows insert after every row ?

Pfa first enter how many rows u want to enter (1 or 2 whatever), then input start row num and last row number click on ok.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ali Abbas Sent: Tuesday, February 11, 2014 11:39 AM To:

RE: $$Excel-Macros$$ Request help on conditional formatting

=$F7=MAX($F$7:$F$11) try this formula in condition formatting option or pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ganesh N Sent: Sunday, February 09, 2014 9:16 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Request help on

RE: $$Excel-Macros$$ Request help on conditional formatting

Subject: Re: $$Excel-Macros$$ Request help on conditional formatting Thanks Ravinder!!! Ravinder may i know why we are using $F7 ? before =Max. Else can you explain how it works ? Thanks Regards Ganesh N On Mon, Feb 10, 2014 at 10:16 AM, Ravinder ravindervbacli...@gmail.com wrote

RE: $$Excel-Macros$$ Access other applications using macro's

You can use shell command in vba Sub openotherapp() Shell C:\Program Files\Internet Explorer\iexplore.exe, vbNormalFocus 'path of exe file of IE, u can use same for SAP (put exe filepath) End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of

RE: $$Excel-Macros$$ Access other applications using macro's

.. but its only opening, not able to click on File, Edit etc.., On Tue, Feb 4, 2014 at 11:02 AM, Ravinder ravindervbacli...@gmail.com wrote: You can use shell command in vba Sub openotherapp() Shell C:\Program Files\Internet Explorer\iexplore.exe, vbNormalFocus 'path of exe file of IE

RE: $$Excel-Macros$$ - Download attachments and merge spreadsheets

TEST From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of BUNTY Sent: Sunday, February 02, 2014 11:46 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ - Download attachments and merge spreadsheets Dear Gurus, I need serious help from you

RE: $$Excel-Macros$$ conditional formate help

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of excel lerner Sent: Wednesday, January 29, 2014 2:51 PM To: excel-macros Subject: $$Excel-Macros$$ conditional formate help Sir Please find the attachment and help me.its urgent. thanks in advance.

RE: $$Excel-Macros$$ Please Help

=TEXT(MAX((H2=$B$2:$B$1944)*$D$2:$D$1944),MM/DD/ H:MM) with CSE From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh kumar Sent: Thursday, January 30, 2014 11:37 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please Help Dear

RE: $$Excel-Macros$$ Convert Pdf to xls using VBA

All pdfs are in same format and give an example pdf From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Akul Rastogi Sent: Tuesday, January 28, 2014 4:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert Pdf to xls using VBA Hi All,

RE: $$Excel-Macros$$ Convert Pdf to xls using VBA

as given below: Run time error 5 Invalid Procedure Call or argument Thanks Akul Rastogi On Tue, Jan 28, 2014 at 4:21 PM, Ravinder ravindervbacli...@gmail.com wrote: All pdfs are in same format and give an example pdf From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com

RE: [XL-VBA Clinic] Re: $$Excel-Macros$$ copy data from attachment

Could you pls provide a sample mail with html attachement From: excelvbacli...@googlegroups.com [mailto:excelvbacli...@googlegroups.com] On Behalf Of Prabhu Pinky Sent: Sunday, January 26, 2014 9:14 PM To: excel-macros@googlegroups.com; excelvbacli...@googlegroups.com Subject: [XL-VBA Clinic]

RE: $$Excel-Macros$$ Extract data from mail attachment.

Could you pls provide an example mail with HTML attachment. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Saturday, January 25, 2014 12:39 PM To: excel-macros Subject: Re: $$Excel-Macros$$ Extract data from mail attachment. why

RE: $$Excel-Macros$$ Help Required

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh kumar Sent: Friday, January 24, 2014 4:26 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required Hi Friends, Please find the attachment. Help Please --

RE: $$Excel-Macros$$ Help required for PDF Stamp

Your query is not clear. Please explain more you need to edit any pdf or only create stamp like approved, rejected or else as pdf From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajeev Sent: Wednesday, January 22, 2014 12:03 PM To:

RE: $$Excel-Macros$$ Not able to set new URL

Pls provide some tick number of example excel file From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of mburkett Sent: Wednesday, January 22, 2014 8:07 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Not able to set new URL I have a

RE: $$Excel-Macros$$ Horizontal Scroll for Listbox in excel vba

Pls provide example with excel file. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kartik Dale Sent: Tuesday, January 21, 2014 4:30 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Horizontal Scroll for Listbox in excel vba Hi,

RE: $$Excel-Macros$$ maximum worksheets per workbook

It depends on system memory there is no limit of worksheets From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shankar Bheema Sent: Monday, January 20, 2014 4:40 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ maximum worksheets per workbook

RE: $$Excel-Macros$$ wanna halp in conditional icon set

Very nice Preeti ji. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of priti verma Sent: Monday, January 20, 2014 8:52 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ wanna halp in conditional icon set PFA On Fri, Jan 17, 2014 at

RE: $$Excel-Macros$$ PICK THE PRICES BASING ON START DATE

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Grkrishna Naidu Sent: Thursday, January 16, 2014 9:45 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ PICK THE PRICES BASING ON START DATE Dear Experts I need your help to solve

RE: $$Excel-Macros$$ Complex formula....

Pls clear your query with example (desired output.) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Thursday, January 16, 2014 6:52 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Complex formula Dear expert team,

RE: $$Excel-Macros$$ About Create Report

Pls provide some data with example fiel From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Thursday, January 09, 2014 11:17 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ About Create Report Hello Expert I need

RE: $$Excel-Macros$$ Macro Code??

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deepak Rawat Sent: Thursday, January 09, 2014 10:55 AM To: excel-macros Subject: $$Excel-Macros$$ Macro Code?? Dear All, I need macro to update multiple sheets from one sheet Ref data is

RE: $$Excel-Macros$$ Re: Amazon - Compare Prices

What is your search criteria ISBN, PRODUCT NUMBER or any URL please provide some ISBN or PRODUCT url which price you want to extract From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Basole Sent: Tuesday, January 07, 2014 4:27 AM To:

RE: $$Excel-Macros$$ Date after weekend

=IF(TEXT(date_rng,ddd)=SAT,C60-1,IF((TEXT(date_rng,ddd)=SUN), date_rng -2, date_rng)) Or pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Robinson Boreh Sent: Friday, January 03, 2014 3:25 PM To: excel-macros Subject: $$Excel-Macros$$ Date after

RE: $$Excel-Macros$$ Ie

HTML code in excel macro. I am trying to login into a tool and pull a report in PDF format. Regards Ck On Dec 21, 2013 12:46 AM, B.N.Chethan Kumar chetankumar1...@gmail.com wrote: Thanks. It worked. On Dec 19, 2013 11:44 AM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this if looking

RE: $$Excel-Macros$$ About Formula

Your look up value is K2 however your range is starting from A2, So formula should be =vlookup(a2,a2:k494,6,false) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Thursday, December 19, 2013 1:54 PM To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ folder check

What problem you are facing you select main folder in which ur subfolders are available. This will give only sheet and file name of empty sheets. From: ANAND S [mailto:anand...@gmail.com] Sent: Wednesday, December 18, 2013 3:20 PM To: Ravinder Cc: excel-macros@googlegroups.com; Soum Subject

RE: $$Excel-Macros$$ Ie

Provide website and data you want to extract. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B.N.Chethan Kumar Sent: Thursday, December 19, 2013 4:19 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Ie Hi I am trying to connect IE 9

RE: $$Excel-Macros$$ Ie

report. On Dec 19, 2013 10:35 AM, Ravinder ravinderexcelgr...@gmail.com wrote: Provide website and data you want to extract. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B.N.Chethan Kumar Sent: Thursday, December 19, 2013 4:19 AM To: excel-macros

RE: $$Excel-Macros$$ Need a macro to open copy data from a given path

PFA, first select paths. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kartik Dale Sent: Tuesday, December 17, 2013 1:54 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a macro to open copy data from a given path Hello Experts,

RE: $$Excel-Macros$$ folder check

Pls clear your query. With example if possible From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anand S Sent: Tuesday, December 17, 2013 4:10 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ folder check Hi I have multiple folders

  1   2   3   >