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

2017-07-17 Thread 'Storey Thomas' via MS EXCEL AND VBA MACROS
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

2017-07-17 Thread Rakesh kumar
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

2017-07-17 Thread Saleem Ansari
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

2017-07-16 Thread Rakesh kumar
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 Required

2015-08-26 Thread Paul Schreiner
- 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

2015-08-25 Thread Soumyendu Paul
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)

2015-06-03 Thread Soumyendu Paul
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 Required

2015-01-12 Thread Sunil Patil
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 required

2014-09-28 Thread Bipin Singh
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)

2013-09-07 Thread De Premor
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)

2013-09-07 Thread Ashish Kumar
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)

2013-09-07 Thread Ashish Kumar
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)

2013-09-06 Thread Ashish Kumar
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)

2013-09-06 Thread Ravinder Kumar
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

2012-06-05 Thread dguillett1
: $$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

2012-06-04 Thread Nagendra Modupalli
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

2012-06-04 Thread Anil Gawli
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

2012-06-04 Thread NOORAIN ANSARI
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

2012-04-16 Thread Shaik Waheed
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@)

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

2012-03-02 Thread Satvik
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...!

2012-03-02 Thread Shaik Waheed
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...!

2012-03-02 Thread Sourabh Salgotra
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...!

2012-03-02 Thread Satvik
@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...!

2012-03-02 Thread Shaik Waheed
-- *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...!

2012-03-02 Thread Satvik
, 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...!

2012-03-02 Thread Sourabh Salgotra
: *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...!

2012-03-02 Thread Satvik
: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...!

2012-03-02 Thread Asa Rossoff
@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

2012-01-04 Thread dguillett1
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

2012-01-04 Thread nitin arora
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

2012-01-04 Thread Rajan_Verma
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

2012-01-04 Thread Paul Schreiner
- 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

2012-01-04 Thread dguillett1
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

2012-01-04 Thread Kris
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

2012-01-03 Thread nitin arora
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 required

2011-10-14 Thread Sam Mathai Chacko
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

2011-10-13 Thread Mahesh parab
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

2011-10-13 Thread somcpardeshi
-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent Help required 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 the sample file Best Regards

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

2011-10-13 Thread dguillett1
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

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

2011-10-13 Thread Paul Schreiner
.” - 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

2011-10-13 Thread somcpardeshi
. -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

2011-10-13 Thread Dilip Pandey
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!!!!!!!!!!

2011-07-05 Thread chandrabhushan prasad
@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!!!!!!!!!!

2011-07-04 Thread Anshul Gupta
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!!!!!!!!!!

2011-07-04 Thread Dilip Pandey
*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!!!!!!!!!!

2011-07-03 Thread Rajan_Verma
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

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

2011-07-02 Thread Anshul Gupta
Hi All. As m working in a import house for that i have to sales bills on daily basis i just want a help that makes me easy to make that If someone tell that how to make 5 random numbers selection between 197.001 to 203.999 which gives the total of 1000.000 Please help meurgent guys Cheers

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

2011-07-02 Thread Rajan_Verma
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

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

2011-07-02 Thread karunanithi ramaswamy
@googlegroups.com Subject: $$Excel-Macros$$ Urgent Help required!!   Hi All.   As m working in a import house for that i have to sales bills on daily basis i just want a help that makes me easy to make that   If someone tell that how to make 5 random numbers selection between

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

2011-07-02 Thread Anshul Gupta
rajanverma1...@gmail.comwrote: *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

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

2011-01-04 Thread sujit pagare
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

2011-01-04 Thread Rohan Young
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

2011-01-04 Thread Born to Win
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

2010-12-08 Thread girish kumar
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

2010-12-06 Thread girish kumar
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

2010-11-28 Thread girish kumar
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

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

2010-11-27 Thread girish kumar
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 -- Some important links for excel users: 1.

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

2010-11-27 Thread ashish koul
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

2010-11-01 Thread Born to Win
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,

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

2010-09-07 Thread Deepak Pal Singh
-- From: Deepak Pal Singh deepaktheind...@gmail.com Date: Tue, Sep 7, 2010 at 10:21 AM Subject: $$Excel-Macros$$ Urgent Help Required To: excel-macros@googlegroups.com Hi Guy's, I've a worksheet containing three columns Serial No, Month and New/CarryForward. I want to get count of New Carry Forward

$$Excel-Macros$$ Urgent Help Required

2010-09-06 Thread Deepak Pal Singh
Hi Guy's, I've a worksheet containing three columns Serial No, Month and New/CarryForward. I want to get count of New Carry Forward on Monthly basis using an excel formula not by pivot table, I've tried to done it using COUNTIF but couldn't get success. Please Help Thanks Deepak Kumar --

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

2010-09-06 Thread bhupsi1982
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

2010-08-06 Thread madhukar reddy
$$ Urgent: Help required in VBA form Hi group, My self pankaj, currentally I m working on a project, I have created a Excel VBA form for quality analysis, but i m facing a problem that when the VBA form is open in this Excel so i m unable to activate any onather Excel file. Pls help me

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

2010-08-05 Thread Kishan Reddy, K
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

2010-08-05 Thread Intelligent But Crazy
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

2010-08-05 Thread Intelligent But Crazy
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

2010-08-04 Thread Intelligent But Crazy
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

2010-08-03 Thread Ahmed Honest
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

2010-08-03 Thread Intelligent But Crazy
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

$$Excel-Macros$$ Urgent help required.

2010-06-04 Thread Born to Win
Dear All, I need your Favour.I have a database in which no. calls summary are mentioned below.But i am not able to find Any formula to map Calls Against Calls summary.If possible Please let me know is it possible through VBA.Please Find Attached Raw Dump Format of data exactly i have to give.

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

2010-04-21 Thread Chaudhry Zahid Ali
ActiveCell.Value = A Range(B).Value = D End Sub It should be quicker than a dialogue box with 3 questions. Regards - Dave. -- Date: Tue, 20 Apr 2010 14:55:44 +0300 Subject: $$Excel-Macros$$ Urgent Help Required in a macro From: chaudhry.zahid

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

2010-04-21 Thread Dave Bonallack
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

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

2010-04-20 Thread Chaudhry Zahid Ali
Hi Group, I'm working in a huge excel sheet with thousands of entries. I am currently looking for a macro, that when invoked (upon press of a key etc) would open a dialogue box having three fields. The first field being Select Row, In which I can write a row number Like 3, the second filed would

$$Excel-Macros$$ urgent help required in excel sheet

2009-09-20 Thread god is gr8 i love u
Hi i have attached 1 file, in this file i want to fill the frequency column i hv tried count formula but it doesnt work may be the way i m using the formula is rong plz help me Regards Ruchi --~--~-~--~~~---~--~~

$$Excel-Macros$$ URGENT HELP REQUIRED

2009-08-30 Thread VIRAL PANDYA
Dear Excel Champs..., Please help me out, I want to password for an XLA (add-ins) file. Is there any way to know the coding of an XLA file??? awaiting reply. Viral Pandy --~--~-~--~~~---~--~~

$$Excel-Macros$$ Urgent help required with Date/Time Format

2009-08-07 Thread Amitabh Bose
Hi All, I would be grateful if you could help me out with the following problem I am facing with regard to data formatting: The changes I need to make to the file are as follows: 1. I need to deduct one hour from the 'CaptureTime' field(column E) which is in seconds. This I

$$Excel-Macros$$ urgent Help Required

2009-07-13 Thread sachin patil
Hi, I'm Very new for this group.I'm facing problem in Excel in Date Formatting. When I'm Selecting to Column go to Option of Date in Format, Whole column is not coming accoroding to that selected Date Format. Can anybody help me out in this ? Thanks in Advance Sachin Patil Dreams are today's

$$Excel-Macros$$ urgent help required

2009-06-12 Thread god is gr8 i love u
Hi I am ruchi gaba I hv 2 probs 1- can i open the pdf file in word without using software like pdf tranformer? 2- i hv interview on monday and VBA, MS Access ,MS excel is required in the software co. i hv dont all this in my course but the probs is my concepts are not clear specially in VBA

$$Excel-Macros$$ Urgent Help required

2009-06-11 Thread Balachander S
May be this is very simple for you experts . I am unable to crack the converiosn from Test file to excel for the data below. The fields are not aligned to draw column lines for import the dtat is not of conistent length. Only patterm I see is the text and numeric data nd spaces in between (these