please add the my number 9582279261
--
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,
thanks
On Tuesday, August 9, 2016 11:21 AM, Abhishek Jain <abhishek@gmail.com>
wrote:
PFA
On Tue, Aug 9, 2016 at 11:11 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Dear Expert,
please help me out lookup and sum
Dear Expert,
please help me out lookup and sum from sheet2
regardsLAKSHMAN
--
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
OutApp = Nothing
End Sub
Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in
inbox
Lakshman Prasad
--
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
OutApp = Nothing
End Sub
Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in
inbox
Lakshman Prasad
--
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
OutApp = Nothing
End Sub
Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in
inbox
Lakshman Prasad
--
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
Dear expert
I have a sheet in which money receipt details maintain, I want to filter like
sheet “Result” means UNITNO With amount of higher value.
Reg's
Lakshman Prasad
--
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
conditional lookup
Dear Laxman,
PFA.
On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD lakshman_...@yahoo.com
wrote:
Dear Expert,
Want conditional lookup from sheet 1 those data which is active in column A ,
plz the attached file
Thanks,
Regards
LAKSHMAN--
Are you =EXP(E:RT) or =NOT(EXP
Dear Laxman,
PFA.
On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD lakshman_...@yahoo.com
wrote:
Dear Expert,
Want conditional lookup from sheet 1 those data which is active in column A ,
plz the attached file
Thanks,
Regards
LAKSHMAN--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
- Forwarded Message -
From: Waseem Saifi waseemsa...@gmail.com
To: excel-macros excel-macros@googlegroups.com
Sent: Wednesday, July 24, 2013 11:50 AM
Subject: Re: $$Excel-Macros$$ Want conditional lookup
Dear Laxman,
PFA.
On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD
still waiting
Lakshman Prasad
From: LAKSHMAN PRASAD lakshman_...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Cc: gawlianil8...@gmail.com gawlianil8...@gmail.com;
chayamon...@gmail.com chayamon...@gmail.com
Sent: Monday, April
Dear Expert,
Is there any option or code to print all open browsers.
Lakshman Prasad
--
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
NO
Lakshman Prasad
Manager (Finance)
GAURSONS INDIA LIMITED
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaursonsindia.com/
From: Lalit Mohan Pandey mohan.pande...@gmail.com
To: excel-macros@googlegroups.com
Cc: gawlianil8...@gmail.com
still waiting
Lakshman Prasad
Sr. Manager (Finance)
GAURSONS INDIA LIMITED
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaursonsindia.com/
From: LAKSHMAN PRASAD lakshman_...@yahoo.com
To: excel-macros@googlegroups.com excel-macros
Dear expert
I have a excel file, in a sheet contain some details with URL, is there any
formula add-on or marco to print all URL details in a PDF file.
Lakshman Prasad
--
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
need to.
On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote:
You are missing
SUMPRODUCT((A7:A23E1)*(A7:A23F1)*(F7:F23))
Lakshman Prasad
Manager (Finance)
GAURSONS INDIA LIMITED
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaursonsindia.com
ok
From: LAKSHMAN PRASAD lakshman_...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Tuesday, August 7, 2012 11:53 AM
Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
C the attached file. ? u r
You are missing
SUMPRODUCT((A7:A23E1)*(A7:A23F1)*(F7:F23))
Lakshman Prasad
Manager (Finance)
GAURSONS INDIA LIMITED
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaursonsindia.com/
From: Ashish Bhalara ashishbhalar...@gmail.com
To: excel
Awaited for your reply...
I
have attached sample file
Lakshman
Prasad
- Forwarded Message -
From: dguillett1
dguille...@gmail.com
To: LAKSHMAN PRASAD
lakshman_...@yahoo.com
Sent: Thursday, July 12, 2012 5:37
PM
Subject: Re: Split Workbook
into Multiple Worksheets
-???
Total-5MB
Regards
Lakshman Prasad
Manager (Finance)
GAURSONS INDIA LIMITED
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaursonsindia.com/
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
Dear Rajan and All,
I request,
Don’t say like this I will send you on your email id .If you really want to
send then send him silently.
Lakshman Prasad
Manager (Finance)
GAURSONS INDIA LIMITED
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaursonsindia.com
Hi everyone,
My name is LAKSHMAN PRASAD. I live in NOIDA, age 39 years. I work as an
Assistant Manager Accounts. I work with Excel, ERP and Word. And i also
interseted or hobbies doing Excel rd, Desktop and Laptop Hardware/software
installation and troubleshooting, photoshop, coral draw
Is this working in excel 2007?
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, June 6, 2012 11:29 PM
Subject: Re: $$Excel-Macros$$ Need a file on commonly used Formulas and
Functions for MS Excel 2010
Hi
C the att.
From: Lokesh Loki lokeshsmg2...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, June 4, 2012 6:48 PM
Subject: $$Excel-Macros$$ Date format
Hi Experts,
I want to confirm the date format whether it is showing Indian date format or
us
Hello everybody,
But if we want like under example …..
Amount Round figer
1864138 190
361408 40
465654 50
445000 40
12 10
15 10
16 20
123 100
150 100
155 200
1234 1000
1500 1000
1555 2000
Regards
LAKSHMAN
From: Asa Rossoff
me 2 plz
From: pawel lupinski lupins...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Wednesday, May 30, 2012 5:39 AM
Subject: Re: $$Excel-Macros$$ MACRO
Hi Noorain
Please send the files
thanks
Pawel
)
If IsNumeric(Mid(c, i, 1)) Then
String1 = String1 Mid(c, i, 1)
End If
Next
removetext = String1
End Function
On Mon, May 28, 2012 at 4:30 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote:
How
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 11:44 AM, LAKSHMAN PRASAD lakshman_...@yahoo.com
wrote:
Hello champ.,
This formula is picking up only first disit of cell only.
1001GANG 1
1002COL. 1
1002TEJI 1
1003SUDH 1
Regards
LAKSHMAN
From: Rajan_Verma rajanverma1...@gmail.com
To: excel-macros
How to collect only numeric value from a particular cell
1462NIRM 1462
1464NIRM 1464
1465NIRM 1465
1404--BL 1404
1031Infr 1031
8020LOKN 8020
202D.B. 202
922Parmi 922
5071RIFA 5071
1040Harj 1040
5078Harj 5078
1471Raj 1471
1571Raj 1571
414Ruchi 414
2084AJAY 2084
Regards
see the attached file
From: Amit Gandhi silkyro...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, May 23, 2012 5:18 PM
Subject: $$Excel-Macros$$ VLLOKUP IS NOT WORKING
Hi Experts
VLOOKUP is not working in attached file, can anyone help
.
Regards,
Aamir Shahzad
On Tue, May 22, 2012 at 10:03 AM, LAKSHMAN PRASAD lakshman_...@yahoo.com
wrote:
Plz see the attached file
From: Aamir Shahzad aamirshahza...@gmail.comTo:
excel-macros@googlegroups.com Sent: Monday, May 21, 2012 11:27 PM
Subject: Re: $$Excel-Macros$$ unable to use
,
Please try below formula...
=IFERROR(VLOOKUP(*A2*,Sheet2!$A$2:$B$3272,2,0),)
On Sat, May 19, 2012 at 12:16 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com
wrote:
Dear Anil,
I know
Hi, Anil,
I know that, but as per my condition or requirement, if first five number
(from left) and first name
is
10020--BLKC-MR. ANUPAM SARKAR(2)
both are not matching that,s why
Regards,
Anil Gawli
On Fri, May 18, 2012 at 6:05 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com
wrote:
Hi Anil,
Plz see cell D13 and D17 value or #NA data no coming
From: Anil Gawli gawlianil8...@gmail.com
To: excel
If you want With Attachments formats of word it would be possible.
From: renuka chari jva.ch...@gmail.com
To: excel-macros@googlegroups.com
Sent: Saturday, May 19, 2012 4:57 PM
Subject: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook
If you want With Attachments formats of word and html it would be possible.
From: LAKSHMAN PRASAD lakshman_...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Saturday, May 19, 2012 5:23 PM
Subject: Re: $$Excel-Macros
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
From: LAKSHMAN PRASAD lakshman_...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Saturday, May 19, 2012 5:32 PM
Subject: Re: $$Excel-Macros$$ Re: Hi all Experts
http://www.4tops.com/mailmergeemailpdf.htm
From: LAKSHMAN PRASAD lakshman_...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Saturday, May 19, 2012 5:23 PM
Subject: Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro
attached file
On Fri, May 18, 2012 at 4:36 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote:
Dear Expert
I m unable to use advance vlookup, plz see the attached file.
Regards
LAKSHMAN
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
table from multiple sheets in
excel 2007.
Dear Lakshman,
Please use attached Add-In
Hope it will useful for you.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Wed, May 9, 2012 at 3:41 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote:
Dear
Congrats Rajan .. bhayee
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2)
plz resend file corrupted
From: MURALI NAGARAJAN muralin...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, May 2, 2012 11:00 AM
Subject: $$Excel-Macros$$ Need rank formula
Dear experts.
I need rank formula for attached file.
Thanks in
Hi Anil,
can u share sample sheet with example.
Regards
LAKSHMAN
From: anil kumar kmr7a...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, April 30, 2012 12:35 PM
Subject: Re: $$Excel-Macros$$ Re: Hi friends, I want to know
I exprot data from
IF(AND(B3=green,B2=red),30,IF(AND(B3=red,B2=green),30,IF(AND(B3=red,B2=),30,IF(AND(B3=,B2=red),30,0
From: pawel lupinski lupins...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Monday, April 30, 2012 2:45 PM
Subject: Re:
Dear Experts,
Can we convert xls to xlsx without open xls(original file)
Regards
LAKSHMAN
--
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
-workbench/about
Rajan.
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of LAKSHMAN PRASAD
Sent: Apr/Wed/2012 11:08
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Best resource to learn MS SQL queries
Dear Expart and Vikash,
Is there any group
Dear Soni,
plz c the attached file..
From: Soni.Rajender soni.rajen...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, April 19, 2012 4:26 PM
Subject: $$Excel-Macros$$ Urgent - Pivot table
Dear Team
Please find attached the excel
Dear Soni,
plz c the attached file..
From: LAKSHMAN PRASAD lakshman_...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Thursday, April 19, 2012 5:49 PM
Subject: Re: $$Excel-Macros$$ Urgent - Pivot table
Dear Soni,
plz
Dear Expart and Vikash,
Is there any group like this (excel-macros)
LAKSHMAN
From: Vikash Chandra vks.chan...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, April 17, 2012 6:22 PM
Subject: Re: $$Excel-Macros$$ Best resource to learn MS SQL
me tooo
From: Lokesh Loki lokeshsmg2...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, April 4, 2012 7:27 PM
Subject: Fwd: $$Excel-Macros$$ VBA Classes
Hi Experts,
May i know that is there any Excel Power point Vba classes conducting in
Delhi NCR
From: Veeru TOC veerub...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, April 5, 2012 12:57 PM
Subject: Re: Fwd: $$Excel-Macros$$ VBA Classes
Venue,,, Plz,,,
On Thu, Apr 5, 2012 at 12:30 PM, LAKSHMAN PRASAD lakshman_
Dear Experts and Noorian,
Is this site (http://www.ozgrid.com/Excel/free-training/basic-index.htm) is ok
for beginner.
Regards
LAKSHMAN
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
use after trim
VLOOKUP(D6,C6:C47,1,FALSE)
From: Deba Ranjan drdeva...@gmail.com
To: excel-macros@googlegroups.com; NOORAIN ANSARI noorain.ans...@gmail.com
Sent: Tuesday, April 3, 2012 1:29 PM
Subject: $$Excel-Macros$$ Exact names Find
Dear Expert,
Dear Shrini
Plz find out solve attach file.
Regards
LAKSHMAN
From: Shrinivas Shevde shrinivas...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, April 2, 2012 12:44 PM
Subject: $$Excel-Macros$$ Count formula
Dear all ,
I have a software which takes
file.
Aamir Shahzad
On Wed, Mar 28, 2012 at 11:07 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote:
Dear Noorain,
I think he want 532, and I'd like to be converted to 05:32
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, March 28
Dear Noorain,
I think he want 532, and I'd like to be converted to 05:32
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, March 28, 2012 7:55 AM
Subject: Re: $$Excel-Macros$$ format a cell
Dear Pawel.
try to keep criteria range
instead of Criteria Range+Sum Range
--
Thanks regards,
Noorain Ansari
http://noorainansari.com/
http://excelmacroworld.blogspot.com/
On Tue, Mar 27, 2012 at 3:38 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote:
Dear Noorain,
is there any prob. when i use
SUMIF
Dear Noorain,
is there any prob. when i use
SUMIF(A1:B4,A7,B1:B4)
just for knowlege
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, March 27, 2012 7:45 AM
Subject: Re: $$Excel-Macros$$ vlookup with more than
Dear Noorian and expert,
Plz see the attached file. Is there any short formula for this result
Regards
LAKSHMAN
9582279261
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Dear Group Owner,
I am required link of Unsubscribe only my lakshman...@yahoo.com ID
LAKSHMAN
--
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
Dear Grpou Member,
Look at the attached file this solution was posted by Mr. NOORION. I was trying
to understand step by step the result. But I m unable to understand “INDIRECT”.
Can anyone clarify the steps.
Regards
LAKSHMAN
--
FORUM RULES (986+ members already BANNED for violation)
1)
Plz see the attached
From: PRAVESH KUMAR praveshkash...@gmail.com
To: excel-macros@googlegroups.com
Sent: Saturday, 18 February 2012 12:38 PM
Subject: $$Excel-Macros$$ Conditional formatting
HI,
Please help...for conditional formatting
Dear PrIyANkAtyr this
Sub Delete_Folders_FS()
objFolder = D:\Documents and Settings\lakshman-\Desktop\New Folder\*.*
Set objFSO = CreateObject(Scripting.FileSystemObject)
objFSO.deletefolder objFolder
End Sub
LAKSHMAN
From: PrIyAnKa p.dhamsa...@gmail.com
m waiting
From: Lakshman Prasad lakshman...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Cc: excelexpertsc...@yahoogroups.com excelexpertsc...@yahoogroups.com
Sent: Friday, 10 February 2012 3:01 PM
Subject: $$Excel-Macros$$ formula
Divide from lac =165221/10 (1.65221)
From: Ashish Bhalara ashishbhalar...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, 10 February 2012 5:34 PM
Subject: $$Excel-Macros$$ Transfer number in unit Rs.Lacs
Dear expert,
I require the macro to
Thanx David
From: David Grugeon grug...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, 10 February 2012 6:28 PM
Subject: Re: $$Excel-Macros$$ formula for this
Try the attached
On 10 February 2012 21:50, Lakshman Prasad lakshman
Hello Mr. Sunil
Use =AVERAGE(F2:F11,{1})
From: sunil bn bnsuni...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 9 February 2012 4:49 PM
Subject: $$Excel-Macros$$ excel macros - Sunil B.N
Hi Expert,
Please find the attached file.
1.
Sorry,
=AVERAGE(F2:F11)
From: sunil bn bnsuni...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 9 February 2012 4:49 PM
Subject: $$Excel-Macros$$ excel macros - Sunil B.N
Hi Expert,
Please find the attached file.
1. I need “average
Dear Darwin,
Plz see attached file.
is it ok?
From: Darwin Chan darwin.chankaw...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 9 February 2012 9:24 AM
Subject: $$Excel-Macros$$ Cstr function
Dear group,
Would like to ask how to use Cstr,
Dear Pravesh,
You can use lookup too
VLOOKUP(I13:I19,D11:E24,2)
From: PRAVESH KUMAR praveshkash...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, 3 February 2012 11:06 PM
Subject: $$Excel-Macros$$ Urgent Help
Hi,
please help ASAP.
please
Dear anjul
Plz See the attached file with your solution.
From: Anjul Porwal porwalan...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 2 February 2012 4:52 PM
Subject: $$Excel-Macros$$ Category wise Count.
Dear Expart,
I want to count or
Dear NOORAIN,
It is a success, you truly deserved. It is an achievement you have truly
earned. I congratulate you on your success and wish you all the best for your
future. Well done.
You met the challenge with determination, strength, and total confidence!
Congrats!
LAKSHMAN...
thanx noor
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, 20 January 2012 11:20 AM
Subject: Re: $$Excel-Macros$$ EXCEL - TIPS
Dear Kishore,
You can study attached Ebook step by step..
It will help you to learn
Dear Noorain
Anil want to do like under written
Jh yksds'k dqekj vxzoky to Shri Lokesh Kumar Aggarwal
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, 20 January 2012 2:13 PM
Subject: Re:
i think her system macro is disable.
coz, i have checked its working.
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, 17 January 2012 1:43 PM
Subject: Re: $$Excel-Macros$$ convert numbers into words
Hi Priyanka,
Because this vba for million and billion format.
For lakh you use other vba code
From: Sanjib Chatterjee chatterjee.kolk...@gmail.com
To: noorain.ansari noorain.ans...@gmail.com; excel-macros
excel-macros@googlegroups.com
Sent: Tuesday, 17 January 2012 1:19
Dear Noorain,
it, ok
but if i want to remove number/disite?
Regards
LAKSHMAN
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, 13 January 2012 8:25 PM
Subject: Re: $$Excel-Macros$$ Delete text only
Dear
To 1000
With rng
If IsNumeric(rng.Cells(i, 1).Value) Then
.Cells(i, 4).Value = .Cells(i, 1).Value
End If
End With
Next i
End Sub
Regards,
MARIES
On Sat, Jan 14, 2012 at 1:26 PM, Lakshman Prasad lakshman...@yahoo.com wrote:
Dear Noorain
me too
From: PrIyAnKa p.dhamsa...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 12 January 2012 5:51 PM
Subject: Re: $$Excel-Macros$$ Receivable Aging
still not getting what u want in output,
Kindly give one example of it in excel
On Thu, Jan
Dear Aralan,
could u put the value which u want like.
From: Muhammad Arslan arslanacca...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 12 January 2012 5:42 PM
Subject: Re: $$Excel-Macros$$ Receivable Aging
Ok For your reference see attached
Hello AsaThis =FIND(UPPER(A1),ABCDEFGHIJKLMNOPQRSTUVWXYZ)and this
is ok =CODE(UPPER(A1))-64for under result
a =1
b= 2
c=3
but what about for this
acb =132
Regards
LAKSHMAN
From: Asa Rossoff a...@lovetour.info
To: excel-macros@googlegroups.com
Message flagged
Wednesday, 21 December 2011 11:13 AM
Message Body
Hello expert,
I have thousands of mail in many archive folders in Microsoft office outlook
2007. Is any function or VBA script to save all contacts when I open any mail
automatically.
Regards
LAKSHMAN
--
FORUM RULES (934+
´t know where i got
it, and i don´t know if i can give it to you as i´m not aware if it is
coyrighted, someone gave me, but it´s for excel2003, see if it is useful for
you. Regards
2011/12/9 Lakshman Prasad lakshman...@yahoo.com
Dear All,
I don't know anything about macrosand about
Dear Tan,
Find “*” with suffix one or two character and replace only selected suffix
Like find “09*” and replace with “09”
Regards
LAKSHMAN
From: tan dennis tanbh...@yahoo.com
To: excel-macros@googlegroups.com
Sent: Friday, 9 December 2011 5:16 PM
Dear All,
I
don't know anything about macrosand about programming or
VBA to create and use macros. But I
want to do or learn seriously. Can anybody help me related this. Related basic
book or rule or anything plz guide me how can I proceed.
Regards
LAKSHMAN
9582279261
--
FORUM RULES (934+
Dear All,
Plz see the attach file. I can’t understand why I m unable to do sum. What is
the problem in sheet or number? Help anybody?
Regards
LAKSHMAN
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
to do the SUM as the data in the last column has leading
and trailing spaces.
You can use the add-on http://www.ablebits.com/excel-trim-spaces/index.php
to quickly remove the spaces, if you regularly receive/generate such data.
Cheers,
Andy
On Wed, Dec 7, 2011 at 1:43 PM, Lakshman Prasad
regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Wed, Dec 7, 2011 at 1:43 PM, Lakshman Prasad lakshman...@yahoo.com wrote:
Dear All,
Plz see the attach file. I can’t understand why I m unable to do sum. What is
the problem in sheet or number? Help
87 matches
Mail list logo