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
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
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
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?
-
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
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 @
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
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
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
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
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
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
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
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
: $$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
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
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
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
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@)
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
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
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
@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
--
*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
, 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
: *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
: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
@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
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
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
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
-
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
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
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
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:
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.
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
-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
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
.” - 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
.
-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
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
@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
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
*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
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
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
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
@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
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
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
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
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
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?
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:
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
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.
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
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,
--
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
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
--
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
$$ 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
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,
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,
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()
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
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
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
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.
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
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
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
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
--~--~-~--~~~---~--~~
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
--~--~-~--~~~---~--~~
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
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
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
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
79 matches
Mail list logo