date:20100823

RE: $$Excel-Macros$$ Extract only from number from a text string

2010-08-23 Thread Chandra Gupt Kumar

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@googlegroups.com
Cc: Kal xcel
Subject: Re: $$Excel-Macros$$ Extract only from number from a text string

 

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 not equal. I want to
extract only Numeric part (like14gm) from that string.

 

File is attached 

 

Thanks in advance

 

Kalyan 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about
the learning and support from the group.Let friends and co-workers know they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe




-- 

Thanks & regards,

Noorain Ansari

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about
the learning and support from the group.Let friends and co-workers know they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ Rupee symbol on PC

2010-08-23 Thread Chandra Gupt Kumar

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 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 KUMAR PANDEY
>  MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
>
> On 8/21/10, ashish koul  wrote:
>> hi all
>>
>> Find  this add in  so sharing it with all . have a look
>>
>> http://blog.foradian.com/font-with-indian-rupee-symbol-download-and-u
>> s
>>
>>
>> Regards
>>
>> Ashish Koul
>> akoul.blogspot.com
>>
>> --
>> -
>> - Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ 
>> http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips 
>> and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes 
>> about the learning and support from the group.Let friends and 
>> co-workers know they can subscribe to group at 
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
>  MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
> --
> 
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip 2. Join our LinkedIN group @ 
> http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips 
> and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes 
> about the learning and support from the group.Let friends and 
> co-workers know they can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
>



--
The posting are downloaded from various sites so the sender is not liable for 
any mishape or damage or anything. download and install at your own rist. This 
might be posted somewhere else in the group, hence may be repeated...




--
Ï,¸,ø¤*°'°*¤ø,--_V  I  J  ā  Y   _--,ø¤*°'°*¤ø,¸¸,Ò©

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Naming ranges which change in size using VBA

2010-08-23 Thread David Stubbs

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 to trim down what we get from the macro 
> recorder.
>
> For example:
>
>    We can name a range without actually selecting it.
>
>    We can bundle .End(xlDown)'s (and more) together on a single line.
>
>    We can use things not available to the macro recorder, ie: CurrentRegion
>
> Regards - Dave.
>
> > Date: Fri, 20 Aug 2010 13:04:43 -0700
> > Subject: $$Excel-Macros$$ Naming ranges which change in size using VBA
> > From: davidmstu...@gmail.com
> > To: excel-macros@googlegroups.com
>
> > Hello everyone,
>
> > I am trying to write a macro to name four ranges in a sheet. The
> > ranges will have the same width every time, and the ranges below the
> > two at the top with always be separated by 1 blank row but more or
> > less rows. I thought it would work by using:
>
> > Range(Selection, Selection.End(xlDown)).Select
> > Range(Selection, Selection.End(xlToRight)).Select
>
> > To select one range, then name it and then move to the next range and
> > repeat. But when I record the macro, the cell references for the
> > ranges are hard coded in, so when I run it on new data with a
> > different number of rows, the named ranges do not correspond to the
> > new data.
>
> > The full code I have is below, and a file call “dynamic naming.xlsm”
> > has been loaded to the group site.
>
> > Any thoughts much appreciated
>
> > Thanks
>
> > David
>
> > -
>
> > Sub NamingMacro()
>
> > ActiveCell.Offset(1, 0).Range("A1").Select
> > Range(Selection, Selection.End(xlDown)).Select
> > Range(Selection, Selection.End(xlToRight)).Select
> > ActiveWorkbook.Names.Add Name:="WorldIm",
> > RefersToR1C1:="=Sheet1!R2C1:R12C6"
> > ActiveWorkbook.Names("WorldIm").Comment = ""
> > ActiveCell.Select
> > Selection.End(xlDown).Select
> > Selection.End(xlDown).Select
>
> > Range(Selection, Selection.End(xlDown)).Select
> > Range(Selection, Selection.End(xlToRight)).Select
> > ActiveWorkbook.Names.Add Name:="WorldEx",
> > RefersToR1C1:="=Sheet1!R14C1:R26C6"
> > ActiveWorkbook.Names("WorldEx").Comment = ""
> > ActiveCell.Select
> > Selection.End(xlToRight).Select
> > Selection.End(xlUp).Select
> > Selection.End(xlUp).Select
> > Selection.End(xlToRight).Select
> > ActiveCell.Offset(1, 0).Range("A1").Select
>
> > ActiveCell.Select
> > Range(Selection, Selection.End(xlToRight)).Select
> > Range(Selection, Selection.End(xlDown)).Select
> > ActiveWorkbook.Names.Add Name:="USIm",
> > RefersToR1C1:="=Sheet1!R2C10:R9C15"
> > ActiveWorkbook.Names("USIm").Comment = ""
> > ActiveCell.Offset(1, 0).Range("A1").Select
> > Selection.End(xlDown).Select
> > Selection.End(xlDown).Select
>
> > ActiveCell.Select
> > Range(Selection, Selection.End(xlDown)).Select
> > Range(Selection, Selection.End(xlToRight)).Select
> > ActiveWorkbook.Names.Add Name:="USEx",
> > RefersToR1C1:="=Sheet1!R11C10:R18C15"
> > ActiveWorkbook.Names("USEx").Comment = ""
>
> > End Sub
>
> > 
>
> > --
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links 
> > :http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 subscribers worldwide and receive many nice notes about 
> > the learning and support from the group.Let friends and co-workers know 
> > they can subscribe to group 
> > athttp://groups.google.com/group/excel-macros/subscribe
>
>
>
>  Naming Ranges.xls
> 23KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ paths between cells

2010-08-23 Thread n3wsgr0ups

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 Aug 23, 10:47 am, Dave Bonallack  wrote:
> 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 need the code to do trial and error, and place all those trial 
> and error code sequences into Loops to minimze code length.
>
> Looking at the logic, the start cell can have up to 8 adjacent cells. 
> Probably using OFFSET, we would query each of these adjacent cells in a 
> pre-set way, perhaps starting straight above, and working around clockwise. 
> If the start cell was on the edge of the sheet, we'd have to skip some of the 
> 8, to prevent errors. Work around until we found a blank cell. Save that cell 
> address into a variable, then make it the subject of the next search. We 
> would have to check each cell to see if it was within the pre-defined range 
> before moving to it. We'd probably use INTERSECT for that. Each time we move 
> to a new cell, ask if it is the required Stop Point. Keep going until the 
> answer to that question is YES. That's one path. Record it somewhere, then 
> back to the first cell and start again, but this time the code must ignore 
> the 1st choice and look for a second, etc. If the path gets stuck at the edge 
> of the sheet or the edge of the pre-defined area, then that's no path. Back 
> up one step and continue around the previous cell, looking for another blank 
> cell. etc.
>
> It's fun to think about, but it would take quite a while to write - for me 
> anyway - so I'll have to leave it to you, or someone else with way too much 
> time on their hands.
>
> Regards - Dave.
>
> > Date: Sun, 22 Aug 2010 07:32:31 -0700
> > Subject: $$Excel-Macros$$ paths between cells
> > From: stozs...@gmail.com
> > To: excel-macros@googlegroups.com
>
> > Need you brains guys!
>
> > Suppose I have a defined range on my worksheet, and within that range
> > I have numbers or blank cells. i'm trying to write some vba code that
> > given 2 cells as a start and stop point, finds all the blank cell
> > "paths" between those two numbers.
>
> > ie suppose 1 is at a1 and 5 is at c4 and the range is a1 to e6, i need
> > to produce a list of non blank cell paths between the 1 and 5. a path
> > being a way to traverse the cells between the two numbers by "walking"
> > on non-blank cells including cells that touch at corners.
>
> > Thanks in anticipation.
>
> > --
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links 
> > :http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 subscribers worldwide and receive many nice notes about 
> > the learning and support from the group.Let friends and co-workers know 
> > they can subscribe to group 
> > athttp://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Lookup Multiple values and display horizontally

2010-08-23 Thread ashish koul

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" & t).Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True
Range("A" & i).Select
Application.CutCopyMode = False
Selection.Copy
Range("D" & t).Select
ActiveSheet.Paste
k = i + 1
   t = t + 1
  End If

  Next i

End Sub



regards
ashish koul
akoul.blogspot.com




On Mon, Aug 23, 2010 at 5:32 PM,  wrote:

>  Attached: Lookup Multiple values and display horizontally
> Message from shin...@gmail.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 side. What I am trying to get is a 
> combination function that looks up for multiple values and display it 
> horizontally. Requesting you to help me out.
>
> Thanks
> Shine
>
>
>
> Google Docs makes it easy to create, store and share online documents,
> spreadsheets and presentations.
> [image: Logo for Google Docs] 
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Hi guys I need your help again.

2010-08-23 Thread shariqcool4u


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 dynamically add as per the logic 
applied on back end they could be one or 100.

Thanks
Shariq
Sent on my BlackBerry® from Vodafone

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Multiple SUMIF type formula

2010-08-23 Thread None

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 cell M2 in the Log.  If it finds it, it needs to sum the 
corresponding amounts in columns P, U, etc.  


In the Log sheet in cells O2 and O3 I've given what amount the formula should 
return.

I'm hoping someone can help with this.  Thanks so much.



  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Etracting sales data as per desired criteria

2010-08-23 Thread Dilip Pandey

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 material over internet to know about the
ARRAY functionality.  Let me know if you have any challenges.  Thanks.
-- 
Thanks & Regards,

DILIP KUMAR PANDEY
  MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India


On Mon, Aug 23, 2010 at 2:09 PM, Kal xcel  wrote:

> Dear Dilip,
>
> Thank u very much for solving my problem, could you please make me
> understand the logic.
>
> Thanks once again
>
> Kalyan
>
>   On Sat, Aug 21, 2010 at 11:27 AM, Dilip Pandey wrote:
>
>> HI Kalyan,
>>
>> Please see the attached file, wherein I have given you the option to
>> select more then one Distributor.  Let me know if this solves
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY
>>  MBA-HR,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>> On Thu, Aug 19, 2010 at 12:33 PM, Kal xcel  wrote:
>> >
>> > Dear Dilip,
>> >
>> > I am attaching a file where I have raw data of Depot, Customer group,
>> Month and Sales data. There are 16 types of customer group. I need depot
>> wise month wise & Distributor+Super stockist wise(customer group) sale data.
>> >
>> > I tried with sumifs & sumproduct formula, but it's not working properly.
>> >
>> > Pivot table is not my required solution.
>> >
>> > Thanks in advance
>> >
>> > Kalyan
>> >
>> > --
>> >
>> --
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >
>> > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > HELP US GROW !!
>> >
>> > We reach over 7000 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>> >
>>
>>
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY
>>  MBA-HR,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY
  MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Re: User Defined Function not updating

2010-08-23 Thread Jacob

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 
wrote:
> Hi
> Please add this line to your function. Adding on the first line will be good.
>
> Application.Volatile
>
> This will cause recalculation of the function when any value change in
> the sheet. (So directly affect the speed if you use function on many
> cell)
>
> Thanks & Regards
> Sandeep
>
> On Fri, Aug 20, 2010 at 9:29 PM, Jacob  wrote:
> > Thanks for getting back to me.   I have attached a demo workbook.  Row
> > 14 contains one of the formulas in questions.
>
> >http://excel-macros.googlegroups.com/web/TestWkb.xlsm?gda=xZn4GD4...
>
> > Let me know if the link work for you.
>
> > Thanks,
>
> > Jacob
>
> > On Aug 20, 10:16 am, Jacob  wrote:
> >> I have a user defined function that is not updating.  The way it works
> >> is based on HireDate.  It looks at the hiredate and compares it to the
> >> budget year.   IF the budget year is in the same year as the hire date
> >> then it looks at the row which could C:N or Jan-Dec.  It works fine
> >> until I actually input a hire date in the current year.  It then zeros
> >> everything out.  If I go through the cell and hit "F2" that is = or
> >> after the hire date month then it recalculates.  I would like for it
> >> to auto recalculate without having to hit "F2" on the cell.
>
> >> Any Help would be greatly appreciated.
>
> >> Thanks,
>
> >> Jacob
>
> >> Function rre_Salary(HireDate As Variant, Rate As Long, Weeks As
> >> Integer, Allocation As Integer)
> >>     Dim BudgetYear As Integer
> >>     BudgetYear = Sheets("Primary Info").Range("C11").Value
> >>     If Year(HireDate) = BudgetYear Then
> >>         If ActiveCell.Column - 2 >= Month(HireDate) Then
> >>         rre_Salary = Rate * Allocation * Weeks
> >>         Else
> >>         rre_Salary = 0
> >>         End If
> >>     Else
> >>         rre_Salary = Rate * Allocation * Weeks
> >>     End If
> >> End Function
>
> > --
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links 
> > :http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 subscribers worldwide and receive many nice notes about 
> > the learning and support from the group.Let friends and co-workers know 
> > they can subscribe to group 
> > athttp://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Re: paths between cells

2010-08-23 Thread Manoj Kumar

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 enhancements, reply me.
>
> One important thing, people tend to ignore unknown persons.
>
>
> Regards,
> Kishan Reddy, K
>
> On Aug 22, 7:32 pm, n3wsgr0ups  wrote:
>> Need you brains guys!
>>
>> Suppose I have a defined range on my worksheet, and within that range
>> I have numbers or blank cells. i'm trying to write some vba  code that
>> given 2 cells as a start and stop point, finds all the blank cell
>> "paths" between those two numbers.
>>
>> ie suppose 1 is at a1 and 5 is at c4 and the range is a1 to e6, i need
>> to produce a list of non blank cell paths between the 1 and 5. a path
>> being a way to traverse the cells between the two numbers by "walking"
>> on non-blank cells including cells that touch at corners.
>>
>> Thanks in anticipation.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Re: paths between cells

2010-08-23 Thread Manoj Kumar

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 enhancements, reply me.
>
> One important thing, people tend to ignore unknown persons.
>
>
> Regards,
> Kishan Reddy, K
>
> On Aug 22, 7:32 pm, n3wsgr0ups  wrote:
>> Need you brains guys!
>>
>> Suppose I have a defined range on my worksheet, and within that range
>> I have numbers or blank cells. i'm trying to write some vba  code that
>> given 2 cells as a start and stop point, finds all the blank cell
>> "paths" between those two numbers.
>>
>> ie suppose 1 is at a1 and 5 is at c4 and the range is a1 to e6, i need
>> to produce a list of non blank cell paths between the 1 and 5. a path
>> being a way to traverse the cells between the two numbers by "walking"
>> on non-blank cells including cells that touch at corners.
>>
>> Thanks in anticipation.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ V look up more than one criteria

2010-08-23 Thread Balachander S

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.
>
> --
> Date: Mon, 23 Aug 2010 16:00:29 +0530
> Subject: Re: $$Excel-Macros$$ V look up more than one criteria
>
> From: sba...@gmail.com
> To: excel-macros@googlegroups.com
>
> 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 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@googlegroups.com
>
>
> I have two sheets as follows
>
> Sheet one
>
> Vilagedist  state
>     
>  
>
>
> Sheet 2
>
> Villagedist  is it in sheet one
>      =  Vlookup() in sheet one first col,1,false
>
>
> Obviously the village in sheet 2 is not the same as loked up in sheet 1  as
> th dist name differs
>
> is there a formulae to look up for more than one criteria here match
> bothvillage name and al;so dist and /or state
>
>
> S Baloo
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscrib

$$Excel-Macros$$ Lookup Multiple values and display horizontally

2010-08-23 Thread shinekn


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 side. What I am trying to get is a  
combination function that looks up for multiple values and display it  
horizontally. Requesting you to help me out.


Thanks
Shine


--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Lookup Multiple values and display horizontally.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Extract only from number from a text string

2010-08-23 Thread NOORAIN ANSARI

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 not equal. I want to
> extract only Numeric part (like14gm) from that string.
>
> File is attached
>
> Thanks in advance
>
> Kalyan
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Thanks & regards,
Noorain Ansari

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Copy of Extract_only_number_from_a_text_string(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ Extract only from number from a text string

2010-08-23 Thread Dave Bonallack


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 string
From: kalx...@gmail.com
To: excel-macros@googlegroups.com
CC: dilipan...@gmail.com


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 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Extract only number from a text string(1).xlsx
Description: Binary data

RE: $$Excel-Macros$$ V look up more than one criteria

2010-08-23 Thread Dave Bonallack


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 criteria
From: sba...@gmail.com
To: excel-macros@googlegroups.com


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 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@googlegroups.com 


I have two sheets as follows

Sheet one

Vilagedist  state
    
 


Sheet 2

Villagedist  is it in sheet one
     =  Vlookup() in sheet one first col,1,false


Obviously the village in sheet 2 is not the same as loked up in sheet 1  as th 
dist name differs

is there a formulae to look up for more than one criteria here match 
bothvillage name and al;so dist and /or state


S Baloo




-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe



-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe



-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Villages.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Extract only from number from a text string

2010-08-23 Thread Kal xcel

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

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Extract only number from a text string.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ V look up more than one criteria

2010-08-23 Thread Balachander S

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 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@googlegroups.com
>
>
> I have two sheets as follows
>
> Sheet one
>
> Vilagedist  state
>     
>  
>
>
> Sheet 2
>
> Villagedist  is it in sheet one
>      =  Vlookup() in sheet one first col,1,false
>
>
> Obviously the village in sheet 2 is not the same as loked up in sheet 1  as
> th dist name differs
>
> is there a formulae to look up for more than one criteria here match
> bothvillage name and al;so dist and /or state
>
>
> S Baloo
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ PASSWORD REMOVER

2010-08-23 Thread viju mobile

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
>
> With Regards
> P.V. Ravi Kumar
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
The posting are downloaded from various sites so the sender is not
liable for any mishape or damage or anything. download and install at
your own rist. This might be posted somewhere else in the group, hence
may be repeated...




--
Ï,¸,ø¤*°'°*¤ø,--_V  I  J  ā  Y   _--,ø¤*°'°*¤ø,¸¸,Ò    ©

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Rupee symbol on PC

2010-08-23 Thread viju mobile

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 KUMAR PANDEY
>  MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
>
> On 8/21/10, ashish koul  wrote:
>> hi all
>>
>> Find  this add in  so sharing it with all . have a look
>>
>> http://blog.foradian.com/font-with-indian-rupee-symbol-download-and-us
>>
>>
>> Regards
>>
>> Ashish Koul
>> akoul.blogspot.com
>>
>> --
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
>  MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
The posting are downloaded from various sites so the sender is not
liable for any mishape or damage or anything. download and install at
your own rist. This might be posted somewhere else in the group, hence
may be repeated...




--
Ï,¸,ø¤*°'°*¤ø,--_V  I  J  ā  Y   _--,ø¤*°'°*¤ø,¸¸,Ò    ©

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


How to apply Indian Comma Style?
Choose Cells option from Format Menu.
In the Code Box type
[>999]""##\,##\,##\,##0;[>9]""##\,##\,##0;""##,##0

RE: $$Excel-Macros$$ paths between cells

2010-08-23 Thread Dave Bonallack


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 need the code to do trial and error, and place all those trial 
and error code sequences into Loops to minimze code length.

Looking at the logic, the start cell can have up to 8 adjacent cells. Probably 
using OFFSET, we would query each of these adjacent cells in a pre-set way, 
perhaps starting straight above, and working around clockwise. If the start 
cell was on the edge of the sheet, we'd have to skip some of the 8, to prevent 
errors. Work around until we found a blank cell. Save that cell address into a 
variable, then make it the subject of the next search. We would have to check 
each cell to see if it was within the pre-defined range before moving to it. 
We'd probably use INTERSECT for that. Each time we move to a new cell, ask if 
it is the required Stop Point. Keep going until the answer to that question is 
YES. That's one path. Record it somewhere, then back to the first cell and 
start again, but this time the code must ignore the 1st choice and look for a 
second, etc. If the path gets stuck at the edge of the sheet or the edge of the 
pre-defined area, then that's no path. Back up one step and continue around the 
previous cell, looking for another blank cell. etc.

It's fun to think about, but it would take quite a while to write - for me 
anyway - so I'll have to leave it to you, or someone else with way too much 
time on their hands.

Regards - Dave.
 
> Date: Sun, 22 Aug 2010 07:32:31 -0700
> Subject: $$Excel-Macros$$ paths between cells
> From: stozs...@gmail.com
> To: excel-macros@googlegroups.com
> 
> Need you brains guys!
> 
> Suppose I have a defined range on my worksheet, and within that range
> I have numbers or blank cells. i'm trying to write some vba code that
> given 2 cells as a start and stop point, finds all the blank cell
> "paths" between those two numbers.
> 
> ie suppose 1 is at a1 and 5 is at c4 and the range is a1 to e6, i need
> to produce a list of non blank cell paths between the 1 and 5. a path
> being a way to traverse the cells between the two numbers by "walking"
> on non-blank cells including cells that touch at corners.
> 
> Thanks in anticipation.
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 7000 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ what is coding of previous and next button in excel

2010-08-23 Thread Dave Bonallack


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 CommandButtons. About now we realise that we have to 
name our buttons more meaningfull than XL default does.

Close the drop-down and doubleclick on UserForm1 to return to the form design 
view.

Right-click on your ADD button and select Properties.

Fid Name in the list, which will be "CommandButton5" or something like that. 
Change it to "Button_Add" (without the quotes)

Do the same for each button, giving it a name you will recognise later.

Once you've done that, right-Click UserForm1 and select View Code again.

Click on the dropdown that contains (General) and now you see a more sensible 
list.

Select Button_Add.

You should now have the following:

 

Private Sub Button_Add_Click()

 

End Sub


Now insert your code that you want for the Add button.

Do the same with all your buttons.

 

Let me know how you get on.

Regards - Dave.

 

 


 


Date: Sun, 22 Aug 2010 14:25:55 +0530
Subject: $$Excel-Macros$$ what is coding of previous and next button in excel
From: neil.jh...@googlemail.com
To: excel-macros@googlegroups.com

Hi Everyone, 

I make user form in excel. But I don't know how to run "Previous button and 
next Button" in excel by making vba code. Please help . 

What is Syntax of this button ?

I know only Syntax = dim lastrow 
lastrow = range("A65550").end(xlup).row+1
range("A" &lastrow).value = textbox1.text
range("B" & lastrow).value = textbox2.text


Thanks 



-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ V look up more than one criteria

2010-08-23 Thread Dave Bonallack


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@googlegroups.com

I have two sheets as follows

Sheet one

Vilagedist  state
    
 


Sheet 2

Villagedist  is it in sheet one
     =  Vlookup() in sheet one first col,1,false


Obviously the village in sheet 2 is not the same as loked up in sheet 1  as th 
dist name differs

is there a formulae to look up for more than one criteria here match 
bothvillage name and al;so dist and /or state


S Baloo







-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Villages.xls
Description: Binary data

$$Excel-Macros$$ Re: paths between cells

2010-08-23 Thread Kishan Reddy, K

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, K

On Aug 22, 7:32 pm, n3wsgr0ups  wrote:
> Need you brains guys!
>
> Suppose I have a defined range on my worksheet, and within that range
> I have numbers or blank cells. i'm trying to write some vba  code that
> given 2 cells as a start and stop point, finds all the blank cell
> "paths" between those two numbers.
>
> ie suppose 1 is at a1 and 5 is at c4 and the range is a1 to e6, i need
> to produce a list of non blank cell paths between the 1 and 5. a path
> being a way to traverse the cells between the two numbers by "walking"
> on non-blank cells including cells that touch at corners.
>
> Thanks in anticipation.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: Need Mentor's Tips

2010-08-23 Thread rsPrashant

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 Macros and i know only basics as of now (i.e)
> Recording.
>     Please can you suggest any books or site which will help me to learn
> better.
>
> Thanks & Regards,
> Vebhav Jain

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ Extract only from number from a text string

RE: $$Excel-Macros$$ Rupee symbol on PC

Re: $$Excel-Macros$$ Naming ranges which change in size using VBA

Re: $$Excel-Macros$$ paths between cells

Re: $$Excel-Macros$$ Lookup Multiple values and display horizontally

$$Excel-Macros$$ Hi guys I need your help again.

$$Excel-Macros$$ Multiple SUMIF type formula

Re: $$Excel-Macros$$ Etracting sales data as per desired criteria

Re: $$Excel-Macros$$ Re: User Defined Function not updating

Re: $$Excel-Macros$$ Re: paths between cells

Re: $$Excel-Macros$$ Re: paths between cells

Re: $$Excel-Macros$$ V look up more than one criteria

$$Excel-Macros$$ Lookup Multiple values and display horizontally

Re: $$Excel-Macros$$ Extract only from number from a text string

RE: $$Excel-Macros$$ Extract only from number from a text string

RE: $$Excel-Macros$$ V look up more than one criteria

$$Excel-Macros$$ Extract only from number from a text string

Re: $$Excel-Macros$$ V look up more than one criteria

Re: $$Excel-Macros$$ PASSWORD REMOVER

Re: $$Excel-Macros$$ Rupee symbol on PC

RE: $$Excel-Macros$$ paths between cells

RE: $$Excel-Macros$$ what is coding of previous and next button in excel

RE: $$Excel-Macros$$ V look up more than one criteria

$$Excel-Macros$$ Re: paths between cells

$$Excel-Macros$$ Re: Need Mentor's Tips

25 matches

Site Navigation

Mail list logo

Footer information