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

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

: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

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

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

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

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

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

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

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

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

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

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

-- 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, Urgent, Need Help,

RE: $$Excel-Macros$$ am getting compile error

Its working fine just correct the position of "then of if" From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Pinky Sent: Wednesday, September 11, 2013 10:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ am getting compile error H

RE: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

Pls provide example file for more clarification. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rashid memon Sent: Wednesday, September 11, 2013 2:19 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required : How i import Data in Exce

RE: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

Use below formula or attached file.may be u r looking for this.. =IF(A2="","",MONTH(A2)&"000"&SUM((MONTH($A$2:A2)=MONTH(A2))*1)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rashid memon Sent: Wednesday, September 11, 2013 2:19 PM To: excel-macros@

RE: $$Excel-Macros$$ Stock prices data fetching through VBA

PLS PROVIDE LINK OF THAT WEBSITE. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Murali prasad Sent: Tuesday, September 17, 2013 12:29 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Stock prices data fetching through VBA im trying to

RE: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK

Try this code. Sub unprotecsheet() Dim wb As Workbook Dim sh As Worksheet Set wb = ThisWorkbook For Each sh In wb.Sheets sh.Unprotect "AAABAABABBAR" Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhakar S H Sent:

RE: $$Excel-Macros$$ Formula: Count

=SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,""),"" ),IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,""),"")),1)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Tuesday, September 17, 2013 6:00 PM To: ex

RE: $$Excel-Macros$$ Check Box In Excel

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rejeeb Abdulrahiman Sent: Tuesday, September 17, 2013 10:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Check Box In Excel Hi Friends, In Excel 2010, I would like to create a l

RE: $$Excel-Macros$$ Formula: Count

heck it. Ashish - I am trying to get count of unique records based on multi conditions where I know what is Condition1 but I will be not knowing what would be condition2. Thanks, Chandra On Wed, Sep 18, 2013 at 12:30 PM, Ravinder wrote: =SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2=$A$2

RE: $$Excel-Macros$$ Auto Filter too short

Image is not there, please send again with example excel file. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Waseem Saifi Sent: Friday, September 20, 2013 2:57 PM To: excel-macros Subject: $$Excel-Macros$$ Auto Filter too short In My Excel, Auto Fil

$$Excel-Macros$$ TESTMAIL

-- 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, Urgent, Need Help,

RE: $$Excel-Macros$$ Matching values

PFA:- =INDEX($H$1:$H$29, SMALL(IF(($P$4=$F$4:$F$29)*1>0,ROW($F$4:$F$29)),3)) FOR 3RD =INDEX($H$1:$H$29, SMALL(IF(($P$4=$F$4:$F$29)*1>0,ROW($F$4:$F$29)),3)) FOR 4TH From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muralidhar E Sent: Saturday, Septem

RE: $$Excel-Macros$$ Total Count of Unique ID's

=SUM(IF(FREQUENCY(MATCH(A2:A595,A2:A595,0),MATCH(A2:A595,A2:A595,0)),1)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Kumar Sent: Monday, September 23, 2013 11:49 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Total Count of U

RE: $$Excel-Macros$$ How to split Alphabetic & Numeric data in different cells....

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Monday, September 23, 2013 9:47 PM To: excel-macros Subject: Re: $$Excel-Macros$$ How to split Alphabetic & Numeric data in different cells =LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,

RE: $$Excel-Macros$$ Total Count of Unique ID's

=SUMPRODUCT(1/COUNTIF(A2:A595,A2:A595)) Actually this formula first count the all values (a2:a595)in full range (a2:a595) then divide 1 by count of all values and add those with help of sumprduct Just like simple eg:- if count of any value is 4 so countif formula will calculate {4;4;4;4} t

RE: $$Excel-Macros$$ Need experts help ***URGENT***

experts help ***URGENT*** Hi Experts / Ravinder / Anil, I need a small update on that file, which you guys had updated. I need to collect data from almost 500 + files, and the macro is doing it's job pretty well. :) But facing a new issue, suppose I am collecting this data

RE: $$Excel-Macros$$ Calculating Euclidean distance in 2 dimension & 3 dimension

I don’t know more about this. U can use like below; =SQRT((x2 – x1)^2 + (y2 – y1)^2 + (z2 – z1)^2) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Debasish Sahu Sent: Monday, September 23, 2013 6:36 PM To: excel-macros@googlegroups.com Subject: $$

RE: $$Excel-Macros$$ How to paste all the values in the text field of a web page

Not able to access website and not getting how its working. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Menaka Balakrishnamoorthy Sent: Tuesday, September 24, 2013 2:42 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to paste all th

RE: $$Excel-Macros$$ How to split Alphabetic & Numeric data in different cells....

Try this one..for getting number and character and u can use UDF given by Ravi for get character From: Ravinder [mailto:ravinderexcelgr...@gmail.com] Sent: Tuesday, September 24, 2013 10:02 AM To: 'excel-macros@googlegroups.com' Cc: Soum (quote.ex...@gmail.com) Subject: RE: $$Ex

RE: $$Excel-Macros$$ I need help on one Macro creation

Give us more information..for this. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sandes Bagwe Sent: Tuesday, September 24, 2013 8:56 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ I need help on one Macro creation Hello All, I h

RE: $$Excel-Macros$$ for due date

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of sridher sharma Sent: Wednesday, September 25, 2013 3:58 PM To: excel-macros Subject: $$Excel-Macros$$ for due date i m taken a loan from bank witch have due date 16 day after 1st date ( 29/04/2013 is

RE: $$Excel-Macros$$ paste special particular formula

But where u want to paste those formula means which range all sheets have the same format.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mukesh Kumar Sent: Thursday, September 26, 2013 3:10 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

RE: $$Excel-Macros$$ How to take the data from the webpage table and paste it in the excel

Website... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Menaka Balakrishnamoorthy Sent: Saturday, September 28, 2013 11:34 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to take the data from the webpage table and paste it in the ex

RE: $$Excel-Macros$$ Function for coloring particular text

For Each cell In Selection With cell.Characters(Start:=3, Length:=1).Font .Color = vbRed End With Next From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prafull Jadhav Sent: Sunday, September 29, 2013 10:00 PM To: excel-macros@googlegroups.com S

RE: $$Excel-Macros$$ Difference between time

=TODAY()+B2-A2 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Waseem Saifi Sent: Monday, September 30, 2013 3:29 PM To: excel-macros Subject: $$Excel-Macros$$ Difference between time Dear Experts, I want to know total working time basis on in time a

RE: $$Excel-Macros$$ Query on Dashboard(urgent)

PFA, I think u r looking for this. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashwani agnihotri Sent: Wednesday, October 02, 2013 7:20 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query on Dashboard(urgent) Hi All, I have attac

RE: $$Excel-Macros$$ Help required in formula.....

recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Oct 3, 2013 at 12:07 PM, Ravinder wrote: Try this udf or pfa Function SUMUP(rng As Range

RE: $$Excel-Macros$$ Min based on condtions

=MIN(IF($B$2:$B$10=C2,$A$2:$A$10)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Tuesday, October 01, 2013 7:58 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Min based on condtions Hello, am trying to get lo

RE: $$Excel-Macros$$ Complicated Formula (automatic add back)

Query is not clear.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Friday, October 04, 2013 7:05 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Complicated Formula (automatic add back) Dear Experts Pls solution my

RE: $$Excel-Macros$$ Email Trigger ?

U want this in which event like when u change value of sheet or do some calculation or open file or activate sheet or any specific time ? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bill Q Sent: Monday, October 07, 2013 2:05 AM To: excel-macros@google

RE: $$Excel-Macros$$ Email Trigger ?

dynamic spreadsheet that monitors different stock prices that is refreshed ever "x" amount of minutes. On 07-10-2013 16:23, Ravinder wrote: U want this in which event like when u change value of sheet or do some calculation or open file or activate sheet or any specific time ? F

RE: $$Excel-Macros$$ Email Trigger ?

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bill Q Sent: Monday, October 07, 2013 2:05 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Email Trigger ? Hi, I am using Excel 2007 and have Gmail as my primary email account.

RE: $$Excel-Macros$$ Fwd: DATE VALIDATE FOR THE FORMULA GIVEN IN THE CELL

=IF(TODAY()>$F$3,"",IF(ISERROR(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0) *H6)),"",(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0)*H6 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Grkrishna Naidu Sent: Monday, October 07, 2013 1:32 PM To: excel-ma

RE: $$Excel-Macros$$ Writing a string to a particular cell

Use Cells(4, iPasteCol).address) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jewel Sharma Sent: Tuesday, October 08, 2013 1:08 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Writing a string to a particular cell Hi, This should hav

RE: $$Excel-Macros$$ INDEX MATCH DOUBT

I think u did not mentioned "BITUMEN' in second sheet From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kannan Excel Sent: Tuesday, October 08, 2013 1:41 PM To: Google Subject: $$Excel-Macros$$ INDEX MATCH DOUBT HI, PLS FIND THE ATTACHED FILE AND DO

RE: $$Excel-Macros$$ INDEX MATCH DOUBT

, anybody help me On Tue, Oct 8, 2013 at 2:25 PM, Ravinder wrote: I think u did not mentioned "BITUMEN' in second sheet From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kannan Excel Sent: Tuesday, October 08, 2013 1:41 PM To: Google Subject: $$Ex

RE: $$Excel-Macros$$ INDEX MATCH DOUBT

R DATA. WHAT I HAVE TO DO:?? =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER DATA'!$D$2:$D$65000,0),MATCH($B18&$C$17,'MASTER DATA'!$A$1:$AQ$1&'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3) On Tue, Oct 8, 2013 at 2:53 PM, Ravind

RE: $$Excel-Macros$$ INDEX MATCH DOUBT

:-) THANK U BOSS, THANKS A LOT :-) ITS WORKING. :-) On Tue, Oct 8, 2013 at 3:21 PM, Ravinder wrote: There may be different total number of rows in ur file Try this =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER DATA'!$D$2:$D$65000,0),MATCH($B18&$C$1

RE: $$Excel-Macros$$ Display Vlookup dialog box with vba code

U can use this coding also in single line Sub Rectangle1_Click() Application.SendKeys ("%mfvlookup%g~") End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dr Sent: Thursday, October 10, 2013 5:29 PM To: excel-macros@googlegroups.com Subject: $$

RE: $$Excel-Macros$$ Display Vlookup dialog box with vba code

Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: Thursday, October 10, 2013 5:45 PM To: excel-macros@googlegroups.com Cc: Soum Subject: RE: $$Excel-Macros$$ Display Vlookup dialog box with vba code pfa

RE: $$Excel-Macros$$ Help required in a small formula.....

E2=1-((1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2) E4=1-((1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: Saturday, October 12, 2013 2:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-M

RE: $$Excel-Macros$$ Two spreadsheets , compare and produce a 'difference' spreadsheet

Give some example..with xlsx file. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of garfin.in...@gmail.com Sent: Monday, October 14, 2013 11:09 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Two spreadsheets , compare and produce a 'differe

RE: $$Excel-Macros$$ Help needed in creating a Dashbord

Give some data...in which you want to work even dummy data. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of alisha malhotra Sent: Tuesday, October 15, 2013 11:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed in creating a Dash

RE: $$Excel-Macros$$ week selection by criteria

PFA. IF u r looking for this. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Avinash Sent: Thursday, October 17, 2013 2:07 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ week selection by criteria hi all, i want criteria based wee

RE: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry

Pfa, if u like to use this... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, October 16, 2013 8:38 PM To: excel-macros Subject: Re: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry try this Priv

RE: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry

Pls use this if you like this. (sorry missed attachment in last mail) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, October 16, 2013 8:38 PM To: excel-macros Subject: Re: $$Excel-Macros$$ Data validation - Need help to preve

RE: $$Excel-Macros$$ How to take values from other sheets with single formula or VBA

=INDIRECT(E$2&"!BT"&ROW()+1) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pravin Gunjal Sent: Friday, October 18, 2013 11:00 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to take values from other sheets with single formula or VBA

RE: $$Excel-Macros$$ Re: Need macro for converting PDF in to given format

PFA , If data in same format in all PFD so u can use this also. You have to put acrobat reader exe path in coding. MyPath = "C:\Program Files\Adobe\Reader 11.0\Reader\AcroRd32.exe" From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jocky Beta Sent:

RE: $$Excel-Macros$$ Look up Names from Contacts Sheet & Display Name in an other sheet named call history.

PFA OR =IFERROR(VLOOKUP(A2,CHOOSE({1,2},Contacts!$B$2:$B$13,Contacts!$A$2:$A$13),2, 0),"UNKNOWN NUMBER") From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of M.Rafique MRU Sent: Sunday, October 27, 2013 9:57 PM To: excel-macros Subject: $$Excel-Macros$$ L

RE: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook

Try this one. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sagar Kasangottuwar Sent: Monday, October 28, 2013 1:06 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific wor

RE: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook

worksheets from various workbook to specific workbook Dear Ravindra, Run time error 9 is showing after running macro. Kindly send me the macro for copy sheets from various workbooks to single workbook. Thanks , Sagar On Mon, Oct 28, 2013 at 2:26 PM, Ravinder wrote: Try this one

RE: $$Excel-Macros$$ UDF convert to Macro

PFA OR BELOW CODE Sub putspace() Dim rng As Range Set rng = Application.InputBox("Please Select Range", Type:=8) For Each T In rng k = T For i = 1 To Len(T) j = Mid(T, i, 1) If j = UCase(j) Then k = WorksheetFunction.Substitute(k, j, " " & j) End If T.Offset(0, 1) = WorksheetFunction.Tri

RE: $$Excel-Macros$$ UDF convert to Macro

PFA OR BELOW CODE Sub putspace() Dim rng As Range Set rng = Application.InputBox("Please Select Range", Type:=8) For Each T In rng k = T For i = 1 To Len(T) j = Mid(T, i, 1) If j = UCase(j) Then k = WorksheetFunction.Substitute(k, j, " " & j) End If T.Offset(0, 1) = WorksheetFunction.

FW: $$Excel-Macros$$ UDF convert to Macro

PFA OR BELOW CODE Sub putspace() Dim rng As Range Set rng = Application.InputBox("Please Select Range", Type:=8) For Each T In rng k = T For i = 1 To Len(T) j = Mid(T, i, 1) If j = UCase(j) Then k = WorksheetFunction.Substitute(k, j, " " & j) End If T.Offset(0, 1) = WorksheetFuncti

RE: $$Excel-Macros$$ Validation Micro

Pls give some example file so From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Tuesday, October 29, 2013 10:43 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Validation Micro Hi exports I have sheet with some colum

$$Excel-Macros$$ RE: [XL-VBA Clinic] Happy Diwali.

HAPPY DIWALI TO ALL FRIENDS.. From: excelvbacli...@googlegroups.com [mailto:excelvbacli...@googlegroups.com] On Behalf Of Dharmendra Upadhyay Sent: Friday, November 01, 2013 11:06 AM To: excelvbacli...@googlegroups.com Subject: Re: [XL-VBA Clinic] Happy Diwali. Same to u & your family On N

  1   2   3   >