Please follow the link.
http://www.ozgrid.com/VBA/ExtractNum.htm
Hope it serve the purpose.
Regards,
C.G.Kumar
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Monday, August 23, 2010 5:23 PM
To: excel-macros@goog
Its rocking.
Regards,
C.G.Kumar
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of viju mobile
Sent: Monday, August 23, 2010 3:30 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rupee symbol on PC
Just use thi
Thank you Kishan and Dave, your answers were very helpful
David S
On Aug 21, 4:09 am, Dave Bonallack wrote:
> Hi David,
>
> Have a look at the attached. I hope it meets your needs.
>
> As good as the macro recorder is, it always returns way too much code. Part
> of learning VBA is learning how
Whoops, sorry if I confused you. Love your idea though. I cant help
feeling that there is some kind of maths technique using path
analysis, but probably wouldnt understand it! i'm writing this to try
and help solve hidato puzzles. Kishen, sorry I like the anonymity of
group postings.
Steve
On Au
hi sort your data on item basis first
try this
Sub Macro1()
Dim i, z, k, t As Long
t = 2
z = Application.WorksheetFunction.CountA(ActiveSheet.Range("a:a"))
k = 2
For i = 2 To z
If Range("a" & i + 1).Value <> Range("a" & i).Value Then
Range("B" & k & ":B" & i).Select
Selection.Copy
Hi,
Can any one tell me how we can link the macro code to hyperlink.
I want to navigate the sheet by click the next or previous by using
Activesheet.next.select or activesheet.previous.select
And I want this two link on each sheet present on my work.
Just for your information the sheets are d
Forgot to include the subject line. Sorry
I need a multiple SUMIF type formula.
In the attached book, there is a Log sheet that needs the formula in cells M2
and M3. The formula in cell M2 needs to look in Payment in columns EA-EU for
the last 6 digits in
You are welcome..Kalyan.
I have used the array functionallity to grasp the desired results and given
you two drop downs, which you can utilize for your desired result
selection. You can also add more drop downs as per your interest in the
similar fashion.
I would recommend you to learn some mate
Thanks guys I ended up not needing the Application.Volatile. I
replaced the activecell with adding an additional variable that would
look at the same column as the weeks. That seems to have fixed it.
Thanks again for the quick responses and help.
Jacob
On Aug 20, 12:52 pm, Sandeep Kumar Maurya
hiii tell me how can i use sum function in macro
tell me
On 8/22/10, Kishan Reddy, K wrote:
> You can use Edit -> goto (special) command to select specific cells in
> a particular range.
>
> check this command.
>
> Once you feel comfortable, record a macro.
>
> Then, if you require any further en
hiii tell me how can i use sum function in macro
tell me
On 8/22/10, Kishan Reddy, K wrote:
> You can use Edit -> goto (special) command to select specific cells in
> a particular range.
>
> check this command.
>
> Once you feel comfortable, record a macro.
>
> Then, if you require any further en
Thanks- This exactly waht I was looking for .
S Baloo
On 8/23/10, Dave Bonallack wrote:
>
> Yes, but it gets complicated. Have a look at the attached. If the
> Village/district combination is not found, then we get a #NA error. We can
> add more formula to remove it if needed.
> Regards - Dave.
Attached: Lookup Multiple values and display horizontally.xls
Sent using Google Docs http://docs.google.com/
Hi
It would be helpful if someone can provide a solution without using VBA
I have a series of data as shown on left side of the sheet. I want to get a
summary of it as shown on right s
Dear Kalyan..
Please see attached sheet..I think your problem has been soloved.
Thanks,
Noorain
On Mon, Aug 23, 2010 at 3:36 PM, Kal xcel wrote:
> Dear Experts,
>
> I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
> Instant Fairness Fruit Bleach 14gm), all strings are
Hi,
If your sample data is really representitive of ALL your data - ie, the numeric
portion is always at the end of the string - then the attached should do what
you need.
Regards - Dave.
Date: Mon, 23 Aug 2010 15:36:04 +0530
Subject: $$Excel-Macros$$ Extract only from number from a text s
Yes, but it gets complicated. Have a look at the attached. If the
Village/district combination is not found, then we get a #NA error. We can add
more formula to remove it if needed.
Regards - Dave.
Date: Mon, 23 Aug 2010 16:00:29 +0530
Subject: Re: $$Excel-Macros$$ V look up more than one c
Dear Experts,
I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
Instant Fairness Fruit Bleach 14gm), all strings are not equal. I want to
extract only Numeric part (like14gm) from that string.
File is attached
Thanks in advance
Kalyan
--
---
thanks this was what i needed.
Taking it forward "if it is in sheet 1" then can it pick up a value in
anotther column of the same row like how we use in V LOOK UP
instead of YES or NO
S Baloo
On 8/23/10, Dave Bonallack wrote:
>
> Hi,
> If the question really is "is it in sheet 1"? then this i
Just open excel file. then open this plug-in. go to tools, you will find options
unprotect workbook
unprotect sheet
choose what you want.. you are done!!
Vijay Joshi
On Wed, Aug 18, 2010 at 10:35 PM, Kumar Punnam
wrote:
> Hi Viju
> Please let me know how to use this addin.
>
> Thanks in advance
Just use this custom format..
On Sat, Aug 21, 2010 at 6:57 PM, Dilip Pandey wrote:
> Thanks Ashish...!!
>
> Can we do the comma formatting like we can do with the dollar sign?
>
> (Rupee Symbol)1,00,000
> Below is what we can do with Dollar sign.
> $100,000
>
> --
> Thanks & Regards,
>
> DILIP KU
Hi,
This is a tricky problem, made trickier by the fact that in paragraph 1 you ask
for blank cell paths, while in paragraph 2 you ask for non blank cell paths.
But which ever you want, the problem has the same level of difficulty.
Supposing we want to find blank cell paths:
Basically you nee
Hi Neil,
Nice form!
Now, to make it work, each button needs some code.
I am assuming you have XL2003.
Follow these steps.
Open the VBA window.
Right-Click UserForm1 and select View Code.
You'll see a drop-down which currently has " (General) " in it. Click on that
and you'll see a list of
Hi,
If the question really is "is it in sheet 1"? then this is a job for SUMPRODUCT!
Please see the attached to see if it helps.
Regards - Dave.
Date: Mon, 23 Aug 2010 06:28:14 +0530
Subject: $$Excel-Macros$$ V look up more than one criteria
From: sba...@gmail.com
To: excel-macros@googlegro
You can use Edit -> goto (special) command to select specific cells in
a particular range.
check this command.
Once you feel comfortable, record a macro.
Then, if you require any further enhancements, reply me.
One important thing, people tend to ignore unknown persons.
Regards,
Kishan Reddy,
Hi Vebhav,
Kindly check the group's page from Google Group, and look for files
uploaded.
There are around 100 files in the group. I am sure u'll find few good
books which may help you.
Bye for now,
Prashant.
On Aug 21, 1:53 pm, vebhav jain wrote:
> Hi All,
>
> I am interested to learn VBA Macr
25 matches
Mail list logo
