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 vebhav.j...@gmail.com wrote:
Hi All,
I am
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,
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:
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,
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
Just use this custom format..
On Sat, Aug 21, 2010 at 6:57 PM, Dilip Pandey dilipan...@gmail.com 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,
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
mr.ravikumar@gmail.com wrote:
Hi Viju
Please let me know how to use this
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 davebonall...@hotmail.com wrote:
Hi,
If the question really is is it in
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
--
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
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
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 kalx...@gmail.com wrote:
Dear Experts,
I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
Instant Fairness Fruit Bleach 14gm),
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
Thanks- This exactly waht I was looking for .
S Baloo
On 8/23/10, Dave Bonallack davebonall...@hotmail.com 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
hiii tell me how can i use sum function in macro
tell me
On 8/22/10, Kishan Reddy, K kishanreddy.kethire...@gmail.com 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
hiii tell me how can i use sum function in macro
tell me
On 8/22/10, Kishan Reddy, K kishanreddy.kethire...@gmail.com 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 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
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
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
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
Range(E
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
Thank you Kishan and Dave, your answers were very helpful
David S
On Aug 21, 4:09 am, Dave Bonallack davebonall...@hotmail.com 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
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
23 matches
Mail list logo