$$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 official Facebook page

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 Facebook page of this for

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 believe the codes can ru

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 wondering whether would you m

Re: $$Excel-Macros$$ removes the jpeg extension

On Saturday, February 6, 2016 7:51 PM, GENIUS wrote: FIRST Thank you very much for your reply, consideration and code actually I dont know a lot about macros, may be 10% out of 100%,  so please do it for me the code i sent to your with the file is not typed by me but taken from somewh

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 | Priority | | TC_H_001 | Hig

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

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 s

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

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

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.readystate<>READYSTATE_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: excel-macros@googlegrou

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

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 IE

$$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 @ https://www.faceb

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

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

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 De

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 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% just > like 15.00 >

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

e very much Sir > > Regards > Amar Takale > > On Mon, Apr 7, 2014 at 4:47 PM, amar takale 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 wrote:

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 wrote: > Hi Yadav, > > you can also use this. J

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 wrote: > Hi Team, > > I need to update the data in second sheet. befor

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

please ignore previous link use below link updated...sorry for any inconvenience http://www.excelvbasupport.com/forum/forumdisplay.php?fid=7 On Sat, Apr 26, 2014 at 8:44 AM, ravinder negi wrote: > just visit below link;-- > http://excelvbasupport.com/forum/newthread.php?fid=7&p

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

just visit below link;-- http://excelvbasupport.com/forum/newthread.php?fid=7&processed=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.face

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

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

Please visit this link for All Shortcuts Keys including Excel -- 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 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$$ 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 us

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

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 12:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Validation on button click Dear Ravinder, Thanks but provided micro is not

RE: $$Excel-Macros$$ Arrow solution

=IF(D2>C2,"q",IF(D2mailto: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 Dear Expert team I required arrow solution in excel for UP & Down & Constant.Pls see attached sheet.

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 w

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 attac

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

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 convert

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 wrote: > Press alt + F11 then go in tools then reference select "Microsoft > Word 14.0 Object Library" li

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

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

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 (Google

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 in

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 to

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

Re: $$Excel-Macros$$ Average Graph

pls provide some example in excel with chart On Saturday, March 15, 2014 8:12 AM, Abhishek Jain wrote: Does this make any sense? On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav wrote: Dear All , > > >Day before Yesterday I had gone for Interview for Data Analyst. They asked me >one qu

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 group

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

Provide your PDF (single ) and excel format as you wants. 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

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

I want a VBA 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 wrote: You just select the whole range of tables and put condition formatting as already applied on $A$1:$L$21, you can

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

: 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

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

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

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 cou

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 Subje

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$$ Macro to insert an empty row whenever there is a change in value from the cell above

w.Insert End If End If Next End Sub On Wednesday, March 12, 2014 12:51:24 AM UTC-6, ravinder negi wrote: Pfa, if help From: excel-...@googlegroups.com [mailto:excel-...@googlegroups.com ] On Behalf Of Aaron Hoffman Sent: Wednesday, March 12, 2014 11:54 AM To: exc

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 cel

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

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

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; excelvbacli...@googlegro

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 & 310,0

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 wrote

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 Hi

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

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 - 25t

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: excel-macros@googlegroups.c

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 wrote: =$F7=MAX($F$7:$F$11)

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 condi

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$$ Access other applications using macro's

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

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

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$$ Convert Pdf to xls using VBA

ml But got error 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 wrote: All pdfs are in same format and give an example pdf From: excel-macros@googlegroups.com [mailto:excel-macros@google

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: [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] R

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 you

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

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 procedu

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: excel-macros@googlegro

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, Nee

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

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 Micro

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: excel-macros@googlegrou

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

RE: $$Excel-Macros$$ Ie

i. Please let me how to use 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" wrote: Thanks. It worked. On Dec 19, 2013 11:44 AM, "Ravinder" wrote: Try this if looking for this

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 Su

RE: $$Excel-Macros$$ Ie

report. On Dec 19, 2013 10:35 AM, "Ravinder" 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@googlegroups.c

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 us

  1   2   3   >