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 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:13 AM, Rakesh kumar wrote: Hi

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 can help me. >> >> actually I have got one assignment,

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

2017-07-16 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 help. > > > -- > Thanks £ Rega

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

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

2015-08-26 Thread Paul Schreiner
e places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Soumyendu Paul To: excel-macros@googlegroups.com Sent: Wednesday, August 26, 2015 1:24 AM Subject: $$Excel-Macros$$ Urgent Help Required Hi, Want to searc

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

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

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

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 wrote: > hi friends, > > i need urgent help of yours > > in attached sheets column DOC has date. in next column 'No. of Days Req' > > if we enter 8 oct in

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

2013-09-06 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,

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

2013-09-06 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,

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

2013-09-06 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-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 wrote: > 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 h

$$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 =TIME(2,D

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

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 www.excelmacroworld.bl

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

$$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. -- Thanks&Regards Nagendra.

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@

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

2012-03-02 Thread Asa Rossoff
not return an error if the number is not found, so we need to verify that it found the correct number. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Satvik Sent: Friday, March 02, 2012 5:49 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macro

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

2012-03-02 Thread Satvik
: 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 AM, Satvik wrote: > **

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

2012-03-02 Thread Sourabh Salgotra
*To: * > *ReplyTo: *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 wrote:

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

2012-03-02 Thread Satvik
43:19 To: 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 wrote: > ** > Thanks for the replay Shaik

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

2012-03-02 Thread Shaik Waheed
erry® on Airtel > -- > *From: *Shaik Waheed > *Sender: *excel-macros@googlegroups.com > *Date: *Fri, 2 Mar 2012 18:11:44 +0530 > *To: * > *ReplyTo: *excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...! > > Hi, > > Do you want to chek wh

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

2012-03-02 Thread Satvik
Thanks for the replay Shaik... Yes I need to check with DNC.. Sent from BlackBerry® on Airtel -Original Message- From: Shaik Waheed Sender: excel-macros@googlegroups.com Date: Fri, 2 Mar 2012 18:11:44 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent

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 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 wrote: > >> Hi Every One, >> >> Friend I need a b

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 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 aware about Acce

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

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

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 Paul Schreiner
--- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ------------- From: nitin

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 nitin arora
ged 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 > > >

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

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

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 wrote: > Hi Prathap, > > If this is one time exercise then, write 100 somewhere in and copy > it. Now select the data

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 wrote: > H

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

2011-10-13 Thread somcpardeshi
. -Original Message- From: Prathap Sender: excel-macros@googlegroups.com Date: Thu, 13 Oct 2011 23:01:01 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent Help required Thank you all for your assistance. However i have a sheet (containing 67 columns &

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

2011-10-13 Thread Paul Schreiner
At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Prathap To: excel-macros@googlegroups.com Sent: Thu, October 13, 2011 1:31:01 PM Subject: Re: $$Excel-Macros$$ Urgent H

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

2011-10-13 Thread Prathap
Thank you all for your assistance. However i have a sheet (containing 67 columns & 3980 rows) were i need to change the entire cell into million. Attached is the sample sheet Best Regards, PRATHAP D M +91 9899-370-328 On 13 October 2011 20:22, Prathap wrote: > Hi, > > Is there a way to conver

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 in

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

2011-10-13 Thread somcpardeshi
@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, PRATHAP D M +91 9899-370-328

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 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 the sample file

$$Excel-Macros$$ Urgent Help required

2011-10-13 Thread Prathap
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, PRATHAP D M +91 9899-370-328 -- ---

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

2011-07-05 Thread chandrabhushan prasad
it help* > >> > >> http://www.mrexcel.com/tip069.shtml > >> > >> ** ** > >> > >> * * > >> > >> * * > >> > >> *From:* excel-macros@googlegroups.com [mailto: > >> excel-macros@googlegroups.com] *On

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

2011-07-04 Thread Dilip Pandey
roups.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

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

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

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

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

2011-07-02 Thread Anshul Gupta
Verma wrote: > *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:* $$Exc

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

2011-07-02 Thread karunanithi ramaswamy
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 wrote: From: Rajan_Verma Subject: RE: $$Excel-Macros$$ Urgent Help required!! To: excel-macros

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 for

$$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-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 wrote: > Hi, > > Please find the attachment > > Thanks & Regards > > ROHAN > 9818247278, 8860567680 > > > On Tue, Jan 4, 2011 at 2:10 PM, ashish koul wrote: > >> ignore the previous mail check thi

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 sujit pagare
pl stop this On Tue, Jan 4, 2011 at 2:07 PM, ashish koul wrote: > check the attachment see if it helps > > > > On Tue, Jan 4, 2011 at 11:58 AM, Born to Win wrote: > >> Hi Friends, >> >> Please help me to Apply sum & Average Formula at the end of Month however >> when i am taking more than 30 Ar

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 wrote: > 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 > > R

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 wrote: > its ok bro > > > On Tue

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 m

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

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

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

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

2010-09-07 Thread bhupsi1982
ut I need the count of New and Carry Forward. Saurabh can we do it without adding a new column? Thanks Deepak Kumar -- Forwarded message -- From: *Deepak Pal Singh* <mailto:deepaktheind...@gmail.com>> Date: Tue, Sep 7, 2010 at 10:21 AM Subject: $$Excel-Macros$$ Urgent Help

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

2010-09-07 Thread bhupsi1982
Pal Singh* <mailto:deepaktheind...@gmail.com>> Date: Tue, Sep 7, 2010 at 10:21 AM Subject: $$Excel-Macros$$ Urgent Help Required To: excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com> Hi Guy's, I've a worksheet containing three columns Serial No, Month and New/Carry

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

2010-09-07 Thread Dave Bonallack
Hi Deepak, Have a look at the attached to see if it's what you need. Regards - Dave Date: Tue, 7 Sep 2010 10:21:26 +0530 Subject: $$Excel-Macros$$ Urgent Help Required From: deepaktheind...@gmail.com To: excel-macros@googlegroups.com Hi Guy's, I've a worksheet containin

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

2010-09-07 Thread Deepak Pal Singh
ed message -- From: Deepak Pal Singh 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 Forwar

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

$$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 in VBA form

2010-08-06 Thread madhukar reddy
Hi Pankaj What is the password of Excel sheet Regards Madhu From: Intelligent But Crazy To: excel-macros@googlegroups.com Cc: Intelligent But Crazy Sent: Tue, 3 August, 2010 9:43:41 PM Subject: $$Excel-Macros$$ Urgent: Help required in VBA form Hi

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 wrote: > Try this, > > But check it may have adverse effects, > > Private Sub CommandButton2_Click() > UserForm1.Show 0 > End Sub > > Also c

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 wrote: > Hi Dav, > >

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

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 wrote: > My Apologiese > > Pls find the

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 Craz

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 wrote: > Hi group, > > My self pankaj, > currentally I m working on a project, I have created

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

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

2010-04-21 Thread Chaudhry Zahid Ali
or > Next c > D = ActiveCell.Value > 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 >

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

2010-04-20 Thread Dave Bonallack
Select Exit For Next c D = ActiveCell.Value 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 macr

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

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

$$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-30 Thread Sachin Shukla
Dear All, Please provied me help on attached sheet. Thanks Sachin Shukla --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),

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

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