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

On Mon, 7/17/17, Saleem Ansari <saleem.logic...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Urgent Help required To: excel-macros@googlegroups.com Date: Monday, July 17, 2017, 9:29 AM Question not clear On Mon, Jul 17, 2017 at 9

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

see this attachment. hope it makes you understand. On Mon, Jul 17, 2017 at 11:59 AM, Saleem Ansari wrote: > Question not clear > > On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar > wrote: > >> Hi Friends, >> >> I need urgent help, If any one

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

Question not clear On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar wrote: > Hi Friends, > > I need urgent help, If any one can help me. > > actually I have got one assignment, I need to solve it, but I'm completely > stuck into this. > > Please see the attachment and

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

First of all:I enjoy helping.Normally, I sort my list of emails (sometimes a hundred or more)and immediately delete the emails with subjects like:Please Help, Urgent and Help Required.Because ALL the people that post to these sites are doing so because they need assistance, and to THEM, it is

Re: $$Excel-Macros$$ urgent help required

Does that mean you would like to have color from 09th October till 23rd Oct. in this case. On Sun, Sep 28, 2014 at 12:20 PM, Rakesh kumar rakesh.apt...@gmail.com wrote: hi friends, i need urgent help of yours in attached sheets column DOC has date. in next column 'No. of Days Req' if

Re: $$Excel-Macros$$ Urgent Help Required (Counta)

The good thing is that your sheet name have a same name with what we are looking for also the name of month, so we can process it easily, try this on B2 =COUNTA(OFFSET(INDIRECT($A2!$A1 ),2,MATCH(B$1,INDIRECT($A2!$1:$1),0)-1,2^16)) On 07-09-2013 12:43, Ashish Kumar wrote: Dear Seniors, I

Re: $$Excel-Macros$$ Urgent Help Required (Counta)

Dear Senior, All data in single workbook in different sheets and i want to create a summary in output sheet. Data pattern will be same according to the sheet which i'hve attached for query reference. Thanks, Ashish On Saturday, September 7, 2013 11:22:03 AM UTC+5:30, Excel Group wrote: Hi

Re: $$Excel-Macros$$ Urgent Help Required (Counta)

Dear De Premor Ravinder Sir, Thanks for your help and valuable support. Thanks a lot. Thanks, Ashish Kumar On Saturday, September 7, 2013 11:32:20 AM UTC+5:30, De Premor wrote: The good thing is that your sheet name have a same name with what we are looking for also the name of month, so

Re: $$Excel-Macros$$ Urgent Help Required (Counta)

Hi Ashish, Please confirm that the all data in a single sheet or in different different sheets. On Sat, Sep 7, 2013 at 11:13 AM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Seniors, I want total count of Sold Items according to the state or months. I'hve tried this through Counta

Re: $$Excel-Macros$$ Urgent help required for Vlookup macro code

May I ask why your request is more urgent and more important than the other requests.?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Nagendra Modupalli Sent: Monday, June 04, 2012 11:30 PM To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Urgent help required for Vlookup macro code

just share your data. Gawli Anil On Tue, Jun 5, 2012 at 10:00 AM, Nagendra Modupalli naga14...@gmail.comwrote: Hi Experts, I have data with Employee number,based on employee number i need to get the date of join.i have many file with DOJ. What is the VBA vlookup code for looking one file

Re: $$Excel-Macros$$ Urgent help required for Vlookup macro code

Dear Nagendra, Please use it Sub USINGVLOOKUP() Dim X As Range Set X = Sheets(1).Range($A$1:$D$9) Range(E15).Value =Application.Worksheetfunction.VLookup(Sheets(1).Range(B15).Value, X, 4, False) End Sub -- Thanks regards, Noorain Ansari www.noorainansari.com

Re: $$Excel-Macros$$ Urgent help required in converting a number into text

Hi, Function English(ByVal N As Currency) As String Const Thousand = 1000@ Const Million = Thousand * Thousand Const Billion = Thousand * Million Const Trillion = Thousand * Billion If (N = 0@) Then English = zero: Exit Function Dim Buf As String: If (N 0@)

Re: $$Excel-Macros$$ Urgent Help Required...!

Hi, Do you want to chek whether the master file ph.# are callable or non-callable by verying it with NDNC sheet? On Sat, Mar 3, 2012 at 4:16 AM, Satvik satvik...@gmail.com wrote: Hi Every One, Friend I need a big help from you all, as I work in BPO company as a MIS executive but I am not

Re: $$Excel-Macros$$ Urgent Help Required...!

chk attachments solved On Fri, Mar 2, 2012 at 6:11 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi, Do you want to chek whether the master file ph.# are callable or non-callable by verying it with NDNC sheet? On Sat, Mar 3, 2012 at 4:16 AM, Satvik satvik...@gmail.com wrote: Hi Every

Re: $$Excel-Macros$$ Urgent Help Required...!

@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent Help Required...! Hi, Do you want to chek whether the master file ph.# are callable or non-callable by verying it with NDNC sheet? On Sat, Mar 3, 2012 at 4:16 AM, Satvik satvik...@gmail.com wrote: Hi Every One, Friend I need a big help from you

Re: $$Excel-Macros$$ Urgent Help Required...!

-- *From: *Shaik Waheed waheedb...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Fri, 2 Mar 2012 18:11:44 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...! Hi, Do you want to chek

Re: $$Excel-Macros$$ Urgent Help Required...!

, 2 Mar 2012 20:43:19 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent Help Required...! Hi, You can use vlookup to find the callable # from DNC sheet. Find the attached file for ur reference. On Sat, Mar 3, 2012 at 6:59 AM, Satvik

Re: $$Excel-Macros$$ Urgent Help Required...!

: *excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...! Hi, You can use vlookup to find the callable # from DNC sheet. Find the attached file for ur reference. On Sat, Mar 3, 2012 at 6:59 AM, Satvik satvik...@gmail.com wrote: ** Thanks for the replay Shaik

Re: $$Excel-Macros$$ Urgent Help Required...!

:14 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent Help Required...! u can try this one =INDEX('E:\Desktop\[NDNC file.xlsx]Sheet1'!$A$2:$B$11,MATCH(A2,'E:\Desktop\[NDNC file.xlsx]Sheet1'!$A$2:$A$11,0),2) On Sat, Mar 3, 2012 at 7:19

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

@googlegroups.com] On Behalf Of Satvik Sent: Friday, March 02, 2012 5:49 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent Help Required...! Shaik, As off now I'm doing the same logic. Where as my data volume is too high! Is there any other logic to map the same

Re: $$Excel-Macros$$ Urgent help required

FIRST. To some of us, ME, “urgent help required” is a NO NO. All requests are urgent. Now, you will need to explain the logic of what you want. If you want to find every comma on the sheet, what will you do with numbers, etc? You need to specify which columns to search and you need to tell us

Re: $$Excel-Macros$$ Urgent help required

Hi Don, My apologies for the subject and I promise this wont happen in future. As far as Me is concerned I am relatively new to this concept of groups so i have no Idea where should I go to change it to my name. Any help on this front would be highly appreciated. As far as the request is

RE: $$Excel-Macros$$ Urgent help required

Hi Do you want this procedure Only in AB Column..? Regards Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of nitin arora Sent: Jan/Wed/2012 12:51 To: excel-macros Subject: $$Excel-Macros$$ Urgent help required Hi, Please find attached

Re: $$Excel-Macros$$ Urgent help required

- From: nitin arora nitinaror...@gmail.com To: excel-macros@googlegroups.com Sent: Wed, January 4, 2012 8:52:56 AM Subject: Re: $$Excel-Macros$$ Urgent help required Hi Don, My apologies for the subject and I promise

Re: $$Excel-Macros$$ Urgent help required

It appears that Paul has solved it for you. Don Guillett SalesAid Software dguille...@gmail.com From: nitin arora Sent: Wednesday, January 04, 2012 7:52 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help required Hi Don, My apologies for the subject and I promise

Re: $$Excel-Macros$$ Urgent help required

Hi Paul, Can you do a favour for me ? ping me your mail ID at: excelfox at live.in Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

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

Here's a VBA formula that does the trick http://www.ozgrid.com/forum/showthread.php?t=144212 Regards, Sam Mathai Chacko (GL) On Fri, Oct 14, 2011 at 11:03 AM, Dilip Pandey dilipan...@gmail.com wrote: Hi Prathap, If this is one time exercise then, write 100 somewhere in and copy it.

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

Hi Prathap Assuming u r value in cell A1 '=A1/10^6 HTH Mahesh On Thu, Oct 13, 2011 at 8:22 PM, Prathap prathap@gmail.com wrote: Hi, Is there a way to convert all the cells with numbers in to million format with shortcut / formula. Example: 1232345487 i want as 1232. Attached is

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

Hi Just divide this by 100 Try this formula =A1/10^6 Thanks and Regards, Somnath C Pardeshi Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message- From: Prathap prathap@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 13 Oct 2011 20:22:52 To:

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

Custom Format #,##0,, ;[Red](#,##0,,);- ; Don Guillett SalesAid Software dguille...@gmail.com From: Prathap Sent: Thursday, October 13, 2011 9:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent Help required Hi, Is there a way to convert all the cells with numbers in

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

.” - John Wesley - From: Prathap prathap@gmail.com To: excel-macros@googlegroups.com Sent: Thu, October 13, 2011 1:31:01 PM Subject: Re: $$Excel-Macros$$ Urgent Help required Thank you all for your assistance. However i

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

. -Original Message- From: Prathap prathap@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 13 Oct 2011 23:01:01 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent Help required Thank you all for your assistance

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

Hi Prathap, If this is one time exercise then, write 100 somewhere in and copy it. Now select the data and apply paste special - Values - Divide. If this is kinda template where figures will come and go, then you can use custom format. Regards, DILIPandey On 10/13/11, Prathap

Re: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

@googlegroups.com] *On Behalf Of *karunanithi ramaswamy *Sent:* Saturday, July 02, 2011 9:29 PM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ Urgent Help required!! ** ** Sir, Do u have any idea of auto filling magic squre for a particular sum

Re: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

ramaswamy *Sent:* Saturday, July 02, 2011 9:29 PM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ Urgent Help required!! ** ** Sir, Do u have any idea of auto filling magic squre for a particular sum total. Iam interested to know it. Thanks if u could

Re: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

*Subject:* RE: $$Excel-Macros$$ Urgent Help required!! ** ** Sir, Do u have any idea of auto filling magic squre for a particular sum total. Iam interested to know it. Thanks if u could help. -R.Karunanithi --- On *Sat, 7/2/11, Rajan_Verma rajanverma1...@gmail.com* wrote

RE: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

See if it help http://www.mrexcel.com/tip069.shtml From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of karunanithi ramaswamy Sent: Saturday, July 02, 2011 9:29 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Urgent Help required

RE: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

See if it helps From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anshul Gupta Sent: Saturday, July 02, 2011 7:39 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent Help required!! Hi All. As m working in a import house for

RE: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

Sir,   Do u have any idea of auto filling magic squre for a particular sum total.  Iam interested to know it. Thanks if u could help.    -R.Karunanithi --- On Sat, 7/2/11, Rajan_Verma rajanverma1...@gmail.com wrote: From: Rajan_Verma rajanverma1...@gmail.com Subject: RE: $$Excel-Macros$$ Urgent

Re: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

No dude its not owrking proerly which buttun you give to generate thats is also not working and the random numbers are not coming in decimels there coming in proper figure. Anyone else who can help me out buddy's please help me out cheers!!! On Sat, Jul 2, 2011 at 8:25 PM, Rajan_Verma

Re: $$Excel-Macros$$ Urgent help Required

pl stop this On Tue, Jan 4, 2011 at 2:07 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment see if it helps On Tue, Jan 4, 2011 at 11:58 AM, Born to Win cs4...@gmail.com wrote: Hi Friends, Please help me to Apply sum Average Formula at the end of Month however when i am

Re: $$Excel-Macros$$ Urgent help Required

Dear Ashish Ji, i hv a question, i am looking your attachment where u r using an array formula and the average col. many of cells is empty where the no. of calls having value (1 or 2) is it ok? or the calculating method of mine for average is correct. please clear me, or suggest me if my working

Re: $$Excel-Macros$$ Urgent help Required

Thanks u So much Experts. Thanks, Chandrabhan Singh On Tue, Jan 4, 2011 at 3:37 PM, Rohan Young rohan.j...@gmail.com wrote: Hi, Please find the attachment Thanks Regards ROHAN 9818247278, 8860567680 On Tue, Jan 4, 2011 at 2:10 PM, ashish koul koul.ash...@gmail.com wrote: ignore

Re: $$Excel-Macros$$ **URGENT**Help Required

Hi Ashish, Any updates?? On Mon, Dec 6, 2010 at 3:04 PM, girish kumar girishkumar832...@gmail.comwrote: Hi Ashish, i want one small info again in provided macro if i hide the Master sheet macro is not running, is there any way to hide the Master sheet and run the macro successfully?

Re: $$Excel-Macros$$ **URGENT**Help Required

Hi Ashish, i want one small info again in provided macro if i hide the Master sheet macro is not running, is there any way to hide the Master sheet and run the macro successfully? thanks in advance Regards Girish. On Tue, Nov 30, 2010 at 7:05 PM, ashish koul koul.ash...@gmail.com wrote:

Re: $$Excel-Macros$$ **URGENT**Help Required

Dear Ashish / Experts Its wonderfull, its solved what i need. But i need VBA code for this because i need to send this file to my higher officials if formulas are there it wont be look good. and for drop box (Column XFD) u put only those destinations which are in Master sheet, if i need to add

Re: $$Excel-Macros$$ **URGENT**Help Required

check the attachment see if it helps . On Sat, Nov 27, 2010 at 6:46 PM, girish kumar girishkumar832...@gmail.comwrote: Dear Experts, I need your help to sort this problem i have attached one file, i have mentioned my problem in file itself. thanks in advance regards Girish

Re: $$Excel-Macros$$ Urgent help Required

Dear Andy, This is working Good i believe in Tag There are many categories are available separated by comma(,),(/).is it Possible to match All word so that i can match maximum apart from Checking only one word. Thanks for your Support, Chandrabhan Singh On Mon, Nov 1, 2010 at 1:47 PM,

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

Hi Deepak, Pls find attached shet with the soultion as per your requirement. Let me know if its find you helpful. Best, Bhupendra Chaudhari On 9/7/2010 10:21 AM, Deepak Pal Singh wrote: Hi Guy's, I've a worksheet containing three columns Serial No, Month and New/CarryForward. I want to get

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

Hi Pankaj What is the password of Excel sheet Regards Madhu From: Intelligent But Crazy secrets...@gmail.com To: excel-macros@googlegroups.com Cc: Intelligent But Crazy secrets...@gmail.com Sent: Tue, 3 August, 2010 9:43:41 PM Subject:

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

Try this, But check it may have adverse effects, Private Sub CommandButton2_Click() UserForm1.Show 0 End Sub Also check for help on SHOW method ( modal/nonmodal forms). Share with me if you have any problems Bye, Kishan Reddy, K kishanreddy.kethire...@gmail.com On Aug 5, 6:38 am,

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

Agreed with your point, but i want that if i required so i can only see any other Excel file while opening a Form. I dont want to do any thing on that file just want to see for refrence. Kindly suggest Regards Pankaj k Pandey On 8/5/10, Intelligent But Crazy secrets...@gmail.com wrote: Hi Dav,

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

Thanks a lot Krisnan It is working. I really appricieat your knowladge, I m glade to get help from you. Regards Pankaj k PAndey On 8/5/10, Kishan Reddy, K kishanreddy.kethire...@gmail.com wrote: Try this, But check it may have adverse effects, Private Sub CommandButton2_Click()

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

Hi Dav, First of all congrats, I request you to pls help me in this problem, my whok project n promotion is now only depands on this. I m waitinig for your reply. Regards Pankaj k Pandey On 8/4/10, Intelligent But Crazy secrets...@gmail.com wrote: My Apologiese

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

Hey Pankaj, The File is password protected, provide password to unlock and get the required. Group is waiting On Tue, Aug 3, 2010 at 7:13 PM, Intelligent But Crazy secrets...@gmail.comwrote: Hi group, My self pankaj, currentally I m working on a

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

My Apologiese Pls find the Password details. For Workbook: bads...@143 For VBA Editor : bads...@143 For Worksheets : SecretShot For Mastersheet : SecretShot Pls help me in this. Thanks Pankaj k Pandey On 8/3/10, Intelligent But

Re: $$Excel-Macros$$ Urgent Help Required in a macro

Thanks a bundle Dave. This has expedited my work even more. :-) (P.S) Can anyone refer me to a good course from where I can learn to write macros... On Wed, Apr 21, 2010 at 4:31 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Zac, Can I suggest a simpler approach? Using the

RE: $$Excel-Macros$$ Urgent Help Required in a macro

You're welcome. Regards - Dave. Date: Wed, 21 Apr 2010 11:45:50 +0300 Subject: Re: $$Excel-Macros$$ Urgent Help Required in a macro From: chaudhry.zahid@gmail.com To: excel-macros@googlegroups.com Thanks a bundle Dave. This has expedited my work even more. :-) (P.S) Can anyone refer