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

$$Excel-Macros$$ Urgent Help required

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 help. -- Thanks £ Regards Rakesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ Urgent help Need with Workbook.open function in Excel Macro

Can you share the file?There's really no other way I can even GUESS what might be wrong. Is the macro looking in the correct cell for a path?Is there a value in the cell?Is the path spelled correctly? using the correct syntax?does the path exist? Since it works for ME, there's really no way to

Re: $$Excel-Macros$$ Urgent help Need with Workbook.open function in Excel Macro

Dear Paul, thanks for the reply. I am also working on the option number 3, which you have suggested. where is you see, I am assigning a value of path to a veriable "P" and the using "ChDir = P" where value of P is taking from a excel cell. Kindly suggest what may be going wrong in it. On

Re: $$Excel-Macros$$ Urgent help Need with Workbook.open function in Excel Macro

In Macro1, you specify the full pathname:Workbooks.Open Filename:= _     "D:\Phillipins\Automation\Raw Data\CUSTOMIZED REPORT.xlsx" in the others, you are not defining the path.In the first you ARE using:ChDir "D:\Phillipins\Automation\Raw Data"but don't need it in Macro1 since you're not

$$Excel-Macros$$ Urgent help Need with Workbook.open function in Excel Macro

Dear Expert, I am stuck in one very simple macro, and not able to find what's the problem is. Please help me with it as my entire work got stuck because of it. I have three macros for same task, where first 1 is working perfectly and opening the workbook "CUSTOMIZED REPORT.xlsx", But rest 2 are

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

- From: Soumyendu Paul soumyendu...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, August 26, 2015 1:24 AM Subject: $$Excel-Macros$$ Urgent Help Required Hi, Want to search header Name in attached file through vba but unable to do with find method. Please help Regards,Soumyendu

$$Excel-Macros$$ Urgent Help Required

Hi, Want to search header Name in attached file through vba but unable to do with find method. Please help Regards, Soumyendu -- 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 @

$$Excel-Macros$$ Urgent Help Required!(VBA Outlook)

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

$$Excel-Macros$$ Urgent Help

Hi guys. I have a sheet where I have couple of pivot tables.. So I want a macro, where I can get access of entire sheet except pivot table data.. Pivot table data should be locked and if i create another pivot table in the same sheet. it should also be locked next time. So i can only use rest of

$$Excel-Macros$$ Urgent Help Required

Hi All, i am working IE automation with one of the citrix page. when i nevigate through page and click on close claim buttion i got one message.. do you want to close the claim. However i written one API which find the message and find the OK button and click on OK. but issue to click on OK

Re: $$Excel-Macros$$ Urgent help

Hi Rakesh Did you checked this? + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 10:32 PM, Vaibhav Joshi v...@vabs.in wrote: Mr. Aptech... Check this.. Goto Input sheet, Pres Alt + F8 to run macro.. Cheers!! + *I did not do this

$$Excel-Macros$$ Urgent help

HI frinds, i want split cells value in diffrent row using macros, please see the attechment. Please do it urgent basis if any one can. -- Thanks £ Regards Rakesh Kumar +91-9650303464 # -- 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$$ Urgent help

there is 2 raw of data but your output doesn't contain 68 what about repeated number 65 to 67? + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 5:03 PM, Rakesh kumar rakesh.apt...@gmail.com wrote: HI frinds, i want split cells value in

Re: $$Excel-Macros$$ Urgent help

it was just sample output. On Tue, Dec 16, 2014 at 5:19 PM, Vaibhav Joshi v...@vabs.in wrote: there is 2 raw of data but your output doesn't contain 68 what about repeated number 65 to 67? + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at

Re: $$Excel-Macros$$ Urgent help

ok, do you want both or unique one? + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 5:43 PM, Rakesh kumar rakesh.apt...@gmail.com wrote: it was just sample output. On Tue, Dec 16, 2014 at 5:19 PM, Vaibhav Joshi v...@vabs.in wrote: there is

Re: $$Excel-Macros$$ Urgent help

I want all, whatever the is available on sheets. On Tue, Dec 16, 2014 at 5:47 PM, Vaibhav Joshi v...@vabs.in wrote: ok, do you want both or unique one? + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 5:43 PM, Rakesh kumar

Re: $$Excel-Macros$$ Urgent help

Mr. Aptech... Check this.. Goto Input sheet, Pres Alt + F8 to run macro.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 5:54 PM, Rakesh kumar rakesh.apt...@gmail.com wrote: I want all, whatever the is available on sheets. On

Re: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

. thanx On 30 September 2014 23:37, Vaibhav Joshi v...@vabs.in wrote: Sudhir Did you checked this -- Forwarded message -- From: Vaibhav Joshi v...@vabs.in Date: Sep 27, 2014 2:38 PM Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT) To: excel

Re: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

if there is need to increase column no action work. thanx On 30 September 2014 23:37, Vaibhav Joshi v...@vabs.in wrote: Sudhir Did you checked this -- Forwarded message -- From: Vaibhav Joshi v...@vabs.in Date: Sep 27, 2014 2:38 PM Subject: Re: $$Excel-Macros$$ URGENT HELP

Re: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT) To: excel-macros@googlegroups.com excel-macros@googlegroups.com Cc: Hi Check this.. click blue button to run macro! Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Sep 25, 2014 at 10

Re: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

this -- Forwarded message -- From: Vaibhav Joshi v...@vabs.in Date: Sep 27, 2014 2:38 PM Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT) To: excel-macros@googlegroups.com excel-macros@googlegroups.com Cc: Hi Check this.. click blue button to run macro

Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

Dear All, Kindly help. On 27 September 2014 14:38, Vaibhav Joshi v...@vabs.in wrote: Hi Check this.. click blue button to run macro! Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA newinex...@gmail.com

Fwd: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

Sudhir Did you checked this -- Forwarded message -- From: Vaibhav Joshi v...@vabs.in Date: Sep 27, 2014 2:38 PM Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT) To: excel-macros@googlegroups.com excel-macros@googlegroups.com Cc: Hi Check this.. click

Re: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

...@vabs.in Date: Sep 27, 2014 2:38 PM Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT) To: excel-macros@googlegroups.com excel-macros@googlegroups.com Cc: Hi Check this.. click blue button to run macro! Cheers!! + *I did not do this for you. God is here

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( CONDITION SEARCH OF UNIQUE TEXT)

Hi Check this.. click blue button to run macro! Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA newinex...@gmail.com wrote: Dear Experts, Kindly resolve my problem. Explanation in attached workbook.

Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

Dear Ganesh, Thanx for provide formula. It's also great but there is more than 100 column where were conditions found. So it is not possible to entered formula. thanking you On 26 September 2014 09:44, Ganesh N ganeshg...@gmail.com wrote: Hi sudhir, PFA. Just given if condition.

$$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

Dear Experts, Kindly resolve my problem. Explanation in attached workbook. Thanking You Regards Sudhir -- 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$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

Hi sudhir, PFA. Just given if condition. Regards, Ganesh N On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA newinex...@gmail.com wrote: Dear Experts, Kindly resolve my problem. Explanation in attached workbook. Thanking You Regards Sudhir -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ URGENT : Help on excel for matching data

can you highlight error cells!! On Mon, Jul 28, 2014 at 10:43 AM, bhanu prakash bhanu...@gmail.com wrote: Hi Vaibhav, Had checked your solution, few lvl's are picking up correct other few are lvl picking wrong #'s ..had checked your response.. Regards, Bhanu On Sat, Jul 26, 2014 at

Re: $$Excel-Macros$$ URGENT : Help on excel for matching data

Team, Any experts for help on below mentioned request..please help Regards, Bhanu On Fri, Jul 25, 2014 at 11:41 AM, bhanu prakash bhanu...@gmail.com wrote: Hello Team, Hope everyone doing good. Had attached the excel sheet for reference in that Excel you will find 2 tabs - one is

Re: $$Excel-Macros$$ URGENT : Help on excel for matching data

Subject: $$Excel-Macros$$ URGENT : Help on excel for matching data Hello Team, Hope everyone doing good. Had attached the excel sheet for reference in that Excel you will find 2 tabs - one is SOURCE and other one is DATA MATCH in DATA MATCH sheet column D - I need the Lvl data from SOURCE data

Re: $$Excel-Macros$$ URGENT : Help on excel for matching data

*To:* excel-macros@googlegroups.com; bhanu.prakas...@oracle.com *Sent:* Friday, July 25, 2014 2:11 AM *Subject:* $$Excel-Macros$$ URGENT : Help on excel for matching data Hello Team, Hope everyone doing good. Had attached the excel sheet for reference in that Excel you will find 2 tabs - one

Re: $$Excel-Macros$$ URGENT : Help on excel for matching data

did this helped? On Fri, Jul 25, 2014 at 6:44 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Pl refer attachment, due to your data formula became complex, you can check example next to it for an explanation. Cheers!! On Fri, Jul 25, 2014 at 3:45 PM, bhanu prakash bhanu...@gmail.com wrote:

$$Excel-Macros$$ URGENT Help! How to display Period the data has been selected through the timeline.

Hi Excel Gurus, I need your help as I am really stuck over here. I have data starting from Nov 2012 till March 2014. I have created various charts for my dashboard and have also inserted a timeline slicer to my pivots. The orientation of this dashboard is portrait and the timeline is given on

$$Excel-Macros$$ [Urgent Help] Insert New Paragraph

Hi everyone, I need some real urgent help with my VBA Macro for Microsoft Word. Here's my current code: Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs If Not (Len(oPara.Range.Text) 1 And Not oPara.Range.ListFormat. ListType = bulletList) Then

Re: $$Excel-Macros$$ [Urgent Help] Insert New Paragraph

Hi Davidson, PFA..!!! If, its not meet your requirement then elaborate more. Regards Ashish On 18 June 2014 19:25, Davidson Chew davidson.chia...@gmail.com wrote: Hi everyone, I need some real urgent help with my VBA Macro for Microsoft Word. Here's my current code: Dim

Re: $$Excel-Macros$$ [Urgent Help] Insert New Paragraph

Hey You can increase line spacing.. Sub para() Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs If Not (Len(oPara.Range.Text) 1 And Not oPara.Range.ListFormat.ListType = bulletList) Then With oPara .SpaceAfter = 0

$$Excel-Macros$$ URGENT - Help regarding SaveasPDF Macro for Excel

My code is - Sub SavePDF() ' pdf Macro Application.ScreenUpdating = False Sheets(Invoice).Select Range(A1:A52).Select ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _ G:\SAMAYENT\Invoice\ Range(A9).ValueOrder No# Range(F9).ValueInvoice No #

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

attachment missing ! On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar rakesh.apt...@gmail.comwrote: Dear Friend, i want to use total no of present or absent list using pivot table. Please find the attachment. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Urgent Help.

Dear Friend, i want to use total no of present or absent list using pivot table. Please find the attachment. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

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

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

Dear Seniors, I want total count of Sold Items according to the state or months. I'hve tried this through Counta formula but this is huge volume of data, so please suggest me the easy way. Thanks, Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

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

...@hotmail.comwrote: madam pl find here with sales register kindly help me to sort out and also inform how i could make such file like also same in the case of purchase register thanks d v nayak -- Date: Tue, 23 Jul 2013 17:06:24 +0530 Subject: Re: $$Excel-Macros$$ urgent

$$Excel-Macros$$ urgent help

hi i have one sheet which consists of data on daily basis for whole year e.g. datecustomer name tin no net 12.5% vat 12.5% net 5% vat 5% oms tranpsort total i need this with tinwise total for whole year and whole year net total and whole year vat total any one can help me

Re: $$Excel-Macros$$ urgent help

Hi nayak..pls share the file.. On Jul 23, 2013 12:02 PM, devanand nayak devnayak_...@hotmail.com wrote: hi i have one sheet which consists of data on daily basis for whole year e.g. datecustomer name tin no net 12.5% vat 12.5% net 5% vat 5% oms tranpsort total i need

Re: $$Excel-Macros$$ Urgent help plss..

Respected Prabhu, Verify that the other cells linked to it are not hidden.Remove any formulas or links(hyper links or other links) that the cell contains with other sheets.Also verify that whether multiple cell which are hidden around the cell are not selected when you select the cell.If the

Re: $$Excel-Macros$$ Urgent help plss..

http://social.technet.microsoft.com/Forums/en-US/officeitpro/thread/cfbcd96c-bcf1-48dc-940e-5d859f44e217 On Tue, May 28, 2013 at 11:26 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi.. Am unable to attach the sheet, since there is violation in our office. As I said earlier, I have

Re: $$Excel-Macros$$ Urgent help plss..

Perhaps you have more than one sheet selected. Regards David Grugeon On 28 May 2013 14:37, Prabhu Pinky prabhupin...@gmail.com wrote: hi experts I have one excel, from that excel I am unable to copy and paste the data to new excel..even a single cell..am getting this command is cannot be

Re: $$Excel-Macros$$ Urgent help plss..

Nope I have selected only one cell in only one sheet. Prabhu R On May 28, 2013 3:50 PM, David Grugeon da...@grugeon.com.au wrote: Perhaps you have more than one sheet selected. Regards David Grugeon On 28 May 2013 14:37, Prabhu Pinky prabhupin...@gmail.com wrote: hi experts I have

Re: $$Excel-Macros$$ Urgent help plss..

Pl share your file with group. And use the appropriate subject for your query. On Tue, May 28, 2013 at 6:44 PM, Prabhu Pinky prabhupin...@gmail.comwrote: Nope I have selected only one cell in only one sheet. Prabhu R On May 28, 2013 3:50 PM, David Grugeon da...@grugeon.com.au wrote:

$$Excel-Macros$$ Urgent help plss..

hi experts I have one excel, from that excel I am unable to copy and paste the data to new excel..even a single cell..am getting this command is cannot be processd in multiple selection error message.. But am sure I selected and copied only single, but donno how am getting thus errorpls

Re: $$Excel-Macros$$ Urgent help plss..

Hi Either source sheet has filter or merged cells. Try clearing out filter and perform operation again. If doesn't work send us sheet. HTH On 28 May 2013 10:07, Prabhu Pinky prabhupin...@gmail.com wrote: hi experts I have one excel, from that excel I am unable to copy and paste the data

Re: $$Excel-Macros$$ Urgent help plss..

Dear Prabhu, Are u pressing cltr+then selecting the cells and trying to copy the things.? if u selecting the cells vertically or horizontally but in straight line then it should copy by selecting cltr key. But if u selecting the cells randomly then it will not copy and throws the message

Re: $$Excel-Macros$$ Urgent help plss..

Hi.. Am unable to attach the sheet, since there is violation in our office. As I said earlier, I have selected only one cell. So there is no matter if I use filter. Prabhu R On May 28, 2013 10:42 AM, VBA VABZ v...@vabs.in wrote: Hi Either source sheet has filter or merged cells. Try

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

: $$Excel-Macros$$ Urgent help required for Vlookup macro code 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 and if not find the DOJ filter blanks and asking next

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

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 and if not find the DOJ filter blanks and asking next file to lookup. Thanks in advance. -- ThanksRegards

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

Subject: $$Excel-Macros$$ urgent help-ActiveX Hi Expert, I am using TextBox and Listbox and multiple sheet. but when ever macros under this control run, control size being reduce. Kindly tell me whats reason may be. Divaker Pandey -- FORUM RULES (986+ members already BANNED

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

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 aware about Access or SQL. But every day I need to scrub the NDNC data which I receive it from my client side.. Volume of a data will be around 5 to 6 lake. Where I get NDNC scrubbed

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

Try Sumif Kantilal Badale On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor kapoor_arp...@yahoo.co.inwrote: Hi, Can anyone please help me with a simple formula for the below data set. All I need is to a sum of all the figures (+/-) except for those which are =1/-1 0.47 0.40 0.26

$$Excel-Macros$$ Urgent help needed please

Hi, Can anyone please help me with a simple formula for the below data set. All I need is to a sum of all the figures (+/-) except for those which are =1/-1 0.47 0.40 0.26 1.05 0.21 2.50 0.05 -0.03 -0.07 -0.08 -0.31 -0.48 -0.65 -0.66 -0.80 -11.26 I don't seem to get it, I am

Re: $$Excel-Macros$$ Urgent help needed please

Hi, Try below formula with Ctrl+Shift+Enter. =SUM(IF(A1:A160,A1:A16,0)) Find the attached file. Regards, MARIES. On Mon, Feb 27, 2012 at 4:32 PM, Arpita kapoor kapoor_arp...@yahoo.co.inwrote: = -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Urgent help needed please

Hi Arpita, You can also use.. SUMPRODUCT((A1:A160)*(A1:A16)) On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor kapoor_arp...@yahoo.co.inwrote: Hi, Can anyone please help me with a simple formula for the below data set. All I need is to a sum of all the figures (+/-) except for those which

Re: $$Excel-Macros$$ Urgent Help

Dear Pravesh,   You can use lookup too   VLOOKUP(I13:I19,D11:E24,2)     From: PRAVESH KUMAR praveshkash...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 3 February 2012 11:06 PM Subject: $$Excel-Macros$$ Urgent Help Hi, please help ASAP. please

$$Excel-Macros$$ Urgent Help

Hi, please help ASAP. please find attached sheet. Thanks Pravesh Kumar -- 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 will not get

Re: $$Excel-Macros$$ Urgent Help

- From: PRAVESH KUMAR Sent: Friday, February 03, 2012 11:36 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent Help Hi, please help ASAP. please find attached sheet. Thanks Pravesh Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ Urgent Help

This should work =INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18OFFSET($D$5:$D$18,1,0),ROW(INDIRECT(1:ROWS($D$5:$D$18))),),COUNTA($I$4:I4))) Regards, Sam Mathai Chacko On Fri, Feb 3, 2012 at 11:06 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote: Hi, please help ASAP. please find attached sheet.

Re: $$Excel-Macros$$ Urgent Help

I second Don. please keep in mind that the volunteers here 'lend' their time to the forum to help. So it would be best to give that extra bit of information in a clear and concise manner, so that it is easy for the volunteers. Sam On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko

Re: $$Excel-Macros$$ Urgent Help

Dear Pravesh, See attached sheet.. =SUMPRODUCT(($D$5:$D$18=K7)*($F$5:$F$18=2)*($E$5:$E$18)) On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko samde...@gmail.comwrote: This should work

Re: $$Excel-Macros$$ Urgent Help

OK. Here is another way AFTER sorting the source table INDEX(E:E,MATCH(I6,D:D)) Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Friday, February 03, 2012 12:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent Help This should work

Re: $$Excel-Macros$$ Urgent Help

Hi Noorain, Thanks a lot of... On 2/3/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Pravesh, See attached sheet.. =SUMPRODUCT(($D$5:$D$18=K7)*($F$5:$F$18=2)*($E$5:$E$18)) On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko samde...@gmail.comwrote: This

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

where you want the data? Do you want the file changed or do you want a list on another sheet?, etc. Don Guillett SalesAid Software dguille...@gmail.com From: nitin arora Sent: Wednesday, January 04, 2012 1:20 AM To: excel-macros Subject: $$Excel-Macros$$ Urgent help required Hi, Please find

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

a list on another sheet?, etc. Don Guillett SalesAid Software dguille...@gmail.com *From:* nitin arora nitinaror...@gmail.com *Sent:* Wednesday, January 04, 2012 1:20 AM *To:* excel-macros excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Urgent help required Hi, Please find

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

$$Excel-Macros$$ Urgent help required

Hi, Please find attached excel sheet named Errors Bifurcation. In this sheet there are many columns in which errors have been reported seperated by commas. I want that all the errors seperated by commas should appear in seperate rows with the data for Target ID and Tranaction ID. For example:

Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

@googlegroups.com Date: Wed, 14 Dec 2011 00:25:49 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance The link did not help Dear Masters, please help me to improve performance of this sheet. From: excel

RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

Of Kiran Kancherla Sent: 14 December 2011 13:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Hi Amit, I have copy the data and pasted the data in a new excel sheet. It was working fine for me. Please try. Regards, Kiran. Sent on my

Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

. Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancherla Sent: 14 December 2011 13:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Hi Amit, I have copy the data

RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

Can you please provide code for that? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of sunil jagtap Sent: 14 December 2011 18:05 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel

Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

/8749ypq === Don Guillett SalesAid Software dguille...@gmail.com From: Amit Desai (MERU) Sent: Tuesday, December 13, 2011 9:51 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Dear Friends, I have attached one excel sheet

  1   2   3   >