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
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,
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
First of all:I enjoy helping.Normally, I sort my list of emails (sometimes a
hundred or more)and immediately delete the emails with subjects like:"Please
Help", "Urgent" and "Help Required".Because ALL the people that post to these
sites are doing so because they need assistance, and to THEM, it
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
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,
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,
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
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
May I ask why your request is more urgent and more important than the other
requests.??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Nagendra Modupalli
Sent: Monday, June 04, 2012 11:30 PM
To: excel-macros@googlegroups.com
Subject:
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
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
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@
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
: 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:
> **
>
>> **
>> Thanks for the replay Shaik...
>>
>> Yes I need to check with DNC..
>> Sent from BlackBerry® on Airtel
>> --
>> *From: *Shaik Waheed
>> *Sender: *excel-macros@googlegroups.com
>> *Date: *Fri, 2 Mar 2012 18:11:44
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
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
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
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
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
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
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
---
“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
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 excel
Hi Don,
My apologies for the subject and I promise this wont happen in future. As
far as "Me" is concerned I am relatively new to this concept of groups so i
have no Idea where should I go to change it to my name. Any help on this
front would be highly appreciated.
As far as the request is concer
FIRST. To some of us, ME, “urgent help required” is a NO NO. All requests are
urgent.
Now, you will need to explain the logic of what you want. If you want to find
every comma on the sheet, what will you do with numbers, etc? You need to
specify which columns to search and you need to tell us wh
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
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
.
-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 &
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
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
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
Hi
Just divide this by 100
Try this formula =A1/10^6
Thanks and Regards,
Somnath C Pardeshi
Sent from my BlackBerry® Smartphone on Loop Mobile.
-Original Message-
From: Prathap
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Oct 2011 20:22:52
To:
Reply-To: excel-macros@googl
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
it help*
> >>
> >> http://www.mrexcel.com/tip069.shtml
> >>
> >> ** **
> >>
> >> * *
> >>
> >> * *
> >>
> >> *From:* excel-macros@googlegroups.com [mailto:
> >> excel-macros@googlegroups.com] *On
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
*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
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
No dude its not owrking proerly which buttun you give to generate thats is
also not working and the random numbers are not coming in decimels there
coming in proper figure.
Anyone else who can help me out buddy's
please help me out
cheers!!!
On Sat, Jul 2, 2011 at 8:25 PM, Rajan_Verma wrot
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
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
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
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
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
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
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
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
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
>
>
>
>
>
>> --
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
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 containing three columns Se
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
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 g
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
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,
>
>
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
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
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
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
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
Thanks a bundle Dave. This has expedited my work even more. :-)
(P.S) Can anyone refer me to a good course from where I can learn to write
macros...
On Wed, Apr 21, 2010 at 4:31 AM, Dave Bonallack
wrote:
> Hi Zac,
> Can I suggest a simpler approach?
> Using the Ctrl key, select the 2 cel
Hi Zac,
Can I suggest a simpler approach?
Using the Ctrl key, select the 2 cells you want to swap, then use a shortcut
key to run this code:
Sub swap()
If Selection.Count <> 2 Then Exit Sub
A = ActiveCell.Value
B = ActiveCell.Address
For Each c In Selection
c.Select
62 matches
Mail list logo
