Re: $$Excel-Macros$$ Macro to sort data in Ascending/Descending order

[Sandeep Kumar Maurya]

Hi Sandip,

Please find the attached file. Feel free to ask further for any query.

Regards
Sandeep Kumar


On Wed, Jan 26, 2011 at 10:41 PM, San Pat  wrote:

> Hi Ashish,
>
> Thanks for your help.
>
> Is there any way I can make it cell specific, assign this macro to
> particular cell.
>
> For example, separate macro for cell A1, B1, C1, D1 etc.
>
> I want to put two arrows, up & down (one for Ascending sort and second for
> Descending sort), in each cell.
>
> Regards,
> Sandip
>
>
> On Tue, Jan 25, 2011 at 11:41 PM, ashish koul wrote:
>
>> Sub sort_ascending()
>> Dim Temp As String
>> Temp = ActiveCell.Address
>> x = Mid(Temp, 2, (InStr(2, Temp, "$") - 2))
>> If ActiveCell.Column <= 6 Then
>> Sheets(1).Range("a1:f" & Range("a1").End(xlDown).Row).Sort
>> key1:=Sheets(1).Range(x & "1"), order1:=xlAscending, Header:=xlYes
>>
>>
>> End If
>> End Sub
>>
>> Sub sort_des()
>> Dim Temp As String
>> Temp = ActiveCell.Address
>> x = Mid(Temp, 2, (InStr(2, Temp, "$") - 2))
>> If ActiveCell.Column <= 6 Then
>> Sheets(1).Range("a1:f" & Range("a1").End(xlDown).Row).Sort
>> key1:=Sheets(1).Range(x & "1"), order1:=xlDescending, Header:=xlYes
>>
>>
>> End If
>> End Sub
>>
>>
>>
>>
>> On Wed, Jan 26, 2011 at 7:52 AM, San Pat  wrote:
>>
>>> Hi All,
>>>
>>> I am working on a excel with data in many columns.
>>>
>>> I want to add two macro button on each heading to sort data, one for
>>> Ascending sort +and second for Descending sort.
>>>
>>> Is it possible with macro.
>>>
>>> I have attached the sample sheet.
>>>
>>> Please advice if it possible.
>>>
>>> Regards,
>>> San
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Sort Data_Aseding_Desending.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Cell Reference ( automatic Updation on Date Change)

[Sandeep Kumar Maurya]

Hi you can use the date function with offsset function in your reference
formula for this. For exact formula tell me what's your current cell address
having reference and whats the reference.

On 23-Jan-2011 2:01 PM, "kush sharma"  wrote:
> Dear All,
>
> I have a query in which i need your help. Lets Say, I am using an Excel
> sheet which has got multiple sheets inside it and a master sheet. Each
Sheet
> is made for a different item that i sell. It has got colums such as
Closing
> Balance(Yesterday), Inward and Outward and daily closing balance. using
> cross-linking the master sheet gets updated with the closing balance for
> that partiular itme. but the next day i have to change the cell reference
> for each item closing balance (cell reference) in the master sheet. I just
> have to delete thatparticular cell number and replace it with next row
> number but is there any formula which can automatically take next cell as
> reference if the date changes? or any thing else that can help me in this.
>
>
> I would apprecaite the help
>
> *Regards*
> * *
> *Kushlesh Sharma*
> *Mo.No: 9907517169*
> **
>
> "All Things are subject to interpretation, and whichever interpretation
> prevails at a given time is a function of power not truth".
>
> --
>
--
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[Sandeep Kumar Maurya]

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=xZn4GD4o61zD5UnH__xR-dBifwHhv_d2uiRDKQGL8zFE3ZFTfWRBti8nExtn9c0KYrNRRjDjsKXVs-X7bdXZc5buSfmx&gsc=brmZ0QsAAACht2TsvJ2a1-7tewzVg2bO
>
> 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 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$$ Fwd: Urgent Requirement: Excel VBA with Mini Tab

[Sandeep Kumar Maurya]

Hi,

Reply to Mr. Lalit Sharma (lalit.sha...@xentaqsys.com) for all
information. Will be better if you send your resume.

Thanks & Regards
Sandeep


-- Forwarded message --
From: Lalit Sharma 
Date: Mon, Aug 16, 2010 at 11:41 AM
Subject: Urgent Requirement: Excel VBA with Mini Tab
To: sandymau...@gmail.com


Hi Sandeep,



This is regarding our telecon held today, for the position of Excel
VBA with Minitab. For, we have good number of openings there please
forward your references as discussed.



Looking forward for your feedback!



Best regards,

Lalit Sharma

-- 
--
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$$ Need list style from data

[Sandeep Kumar Maurya]

Give me sample file with few rows

Thanks & Regards
Sandeep

On Mon, Jul 26, 2010 at 8:01 PM, Nadine S  wrote:
> Can you help me again?  I've loaded all my data and I have 3549 rows and
> columns A-Y.  All column headers are the same except Col Y = Adjustment.
> When I try to run the second macro it doesn't work.  I don't know how to
> debug it.
> Thanks.
> Nadine
> ____________
> From: Sandeep Kumar Maurya 
> To: excel-macros@googlegroups.com
> Sent: Sun, July 25, 2010 10:48:42 AM
> Subject: Re: $$Excel-Macros$$ Need list style from data
>
> Macro Name                  Purpose
>
> CreateList1                    create list as per all items and place
> them in Solution sheet starting from A2
> CreateList2                    create list as per given cost/price and
> don't include blank cells. This is also in Solution Sheet starting
>                                     from cell A2
>
> Why you can't see the difference which is blank cost values for some
> item ( If I'm correct ). Did you enable the macro for this file?
>
>
> What these macro needed.
>
> A worksheet named "Data" for data source with same format as given in your
> file.
> A worksheet named "Solution" for your list.
>
> Note: These macro deletes everything from cells A2:E65536 and then put the
> list.
>
> You can extend Items and Rows in "Data" sheet.
>
>
> Thanks & Regards
> Sandeep
>
>
> On Sun, Jul 25, 2010 at 7:39 PM, Nadine S  wrote:
>> When I run either macro I don't see anything different.  So I can't tell
>> if
>> it's working.  Also, how do I put this macro into my original file?  I
>> just
>> sent a sample.  Thanks.
>>
>> 
>> From: Sandeep Kumar Maurya 
>> To: excel-macros@googlegroups.com
>> Sent: Sat, July 24, 2010 3:57:17 AM
>> Subject: Re: $$Excel-Macros$$ Need list style from data
>>
>> Hi Nadine
>>
>> See the attached file it has two macros as you needed.
>>
>> Thanks & Regards
>> Sandeep
>>
>> On Sat, Jul 24, 2010 at 12:53 AM, Nadine S  wrote:
>>> Hi all,
>>>
>>> I have attached a spreadsheet that shows list data to the left but then
>>> under the Item numbers is the amount of reach combo in the list and item
>>> number.  I would like the data in list format instead of pivot table
>>> style
>>> format.  The result I'd like to see is included in the worksbook with 2
>>> different solution options.
>>>
>>> Thanks.
>>>
>>> Nadine
>>>
>>> --
>>>
>>>
>>> --
>>> 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 !!
>>
&g

Re: $$Excel-Macros$$ Macro to clean up file

[Sandeep Kumar Maurya]

Hi,
I got your file but next time use gmail and attach in the mail.


Thanks & Regards
Sandeep

On Sun, Jul 25, 2010 at 1:02 AM, JD <5635.daw...@gmail.com> wrote:
> How do I attach? I placed in file section of
> MS EXCEL AND VBA MACROS.
>
>
> On Jul 24, 5:35 am, Sandeep Kumar Maurya 
> wrote:
>> Hi JD,
>>
>> You forgot to attach file.
>>
>> Thanks & Regards
>> Sandeep
>>
>> On Sat, Jul 24, 2010 at 5:52 AM, JD <5635.daw...@gmail.com> wrote:
>> > I am looking to clean up a file that gets sent to me weekly see
>> > "example file.xlsx" on file page. The file may look like the first tab
>> > the 1st week it is sent to me and like the second tab the 2nd week it
>> > is sent to me but I need it to look like the 3rd tab all the time for
>> > import into database. Can anyone help me with this?
>>
>> > --
>> > --
>> > 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
>

-- 
--
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$$ Macro to clean up file

[Sandeep Kumar Maurya]

Hi JD,

You forgot to attach file.

Thanks & Regards
Sandeep

On Sat, Jul 24, 2010 at 5:52 AM, JD <5635.daw...@gmail.com> wrote:
> I am looking to clean up a file that gets sent to me weekly see
> "example file.xlsx" on file page. The file may look like the first tab
> the 1st week it is sent to me and like the second tab the 2nd week it
> is sent to me but I need it to look like the 3rd tab all the time for
> import into database. Can anyone help me with this?
>
> --
> --
> 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$$ Auto Calculate Number to Percent

[Sandeep Kumar Maurya]

Hi Dave,

Please send the VBA solution for me. I can't get a logic which can
solve this problem without saving "Hour Worked" values. The problem
part with me is when a new value added to data it will not show the
correct percentage value. The cause I already mentioned in previous
reply.

If MNM need this with worksheet functions then he already have it.

So please send the VBA.

Thanks & Regards
Sandeep



On Fri, Jul 23, 2010 at 10:43 AM, Dave Bonallack
 wrote:
> Hi
> This can't be done with worksheet functions without the use of another
> column, because of circular referencing.
> However, it can be done with macros, either automatically, or by button
> click.
> So, which would you prefer: Worksheet functions with extra column, or VBA?
> Regards - Dave.
>
>> Date: Thu, 22 Jul 2010 18:42:53 -0700
>> Subject: $$Excel-Macros$$ Auto Calculate Number to Percent
>> From: mnaf...@gmail.com
>> To: excel-macros@googlegroups.com
>>
>> Hi,
>>
>> I am trying to figure out if there is a way to auto calculate number
>> entered into a column to total percent. Example
>>
>> Column A contains 'Date'
>> Column B contains 'User'
>> Column C contains 'Hours worked'
>>
>> Based on the value in column B User 'XYZ' I should be able to convert
>> hours worked into total percent
>>
>> Date | User | Hours Worked
>> 7/16 | ABC | 8
>>
>> This should self calculate and return on save
>> 7/16 | ABC | 100%
>>
>> Example 2
>>
>> Date | User | Hours Worked
>> 7/16 | ABC | 8
>> 7/16 | ABC | 8
>> 7/16 | XYZ | 12
>> 7/17 | ABC | 8
>>
>> This should self calculate and return on save
>> 7/16 | ABC | 33.3%
>> 7/16 | ABC | 33.3%
>> 7/16 | XYZ | 100%
>> 7/17 | ABC | 33.3%
>>
>> At the end the total should equal 100% by User
>>
>> --
>>
>> --
>> 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
>
> 
> Find it on Domain.com.au Need a new place to live?
>
> --
> --
> 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$$ Auto Calculate Number to Percent

[Sandeep Kumar Maurya]

Hi,

If I say clearly then this is not possible to change the "Hour Worked"
value in percentage in the same column.

The reason is that when a value is changed to percent what will
converted to a fraction.

Date User   Hours Worked Hours Worked % 
16-Jul   ABC8 33.3% = 0.333
16-Jul   ABC8 33.3% = 0.333
16-Jul   XYZ   12100.0% = 1
17-Jul   ABC8 33.3% = 0.333


Now if the "Hour worked" value of 8 converted to 0.333. And you
Enter new data in next row 8 for ABC then it will compared to
0. not with 8, because 8 had been already changed to
0. hence will give a wrong value for percentage.

So you have to store the Hour worked value for correct percentage. See
the attached file for the same.


Thanks & Regards
Sandeep



On Fri, Jul 23, 2010 at 7:12 AM, MNM  wrote:
> Hi,
>
> I am trying to figure out if there is a way to auto calculate number
> entered into a column to total percent. Example
>
> Column A contains 'Date'
> Column B contains 'User'
> Column C contains 'Hours worked'
>
> Based on the value in column B User 'XYZ' I should be able to convert
> hours worked into total percent
>
> Date | User | Hours Worked
> 7/16 | ABC | 8
>
> This should self calculate and return on save
> 7/16 | ABC | 100%
>
> Example 2
>
> Date | User | Hours Worked
> 7/16 | ABC | 8
> 7/16 | ABC | 8
> 7/16 | XYZ | 12
> 7/17 | ABC | 8
>
> This should self calculate and return on save
> 7/16 | ABC | 33.3%
> 7/16 | ABC | 33.3%
> 7/16 | XYZ | 100%
> 7/17 | ABC | 33.3%
>
> At the end the total should equal 100% by User
>
> --
> --
> 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


convert.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ how do you identify the first space within a series of words within a a text

[Sandeep Kumar Maurya]

Hi Edgar,

Function you are applying is correct. So please attached your file so
that problem can be solved.

Thanks & Regards
Sandeep

On Thu, Jul 22, 2010 at 3:18 AM, Edgar  wrote:
> I'm trying to clean up some data. I've used SEARCH and FIND to try to
> identify the first space within a cell, but the answer comes back
> incorrect.
>
> I've used SEARCH("", Cell Reference)
>
> It's giving me the first cell. For example, the answer to this would
> be 1.
>
> If I used SEARCH("", Cell reference, 20), it would show 20.
>
> Any help, pls?
>
> --
> --
> 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: [Fwd: Help for format converson required]

[Sandeep Kumar Maurya]

Hi,

A good solution Dilip Ji.

Please see the attached file with just a little modification.

Thanks & Regards
Sandeep

On Tue, Jul 20, 2010 at 4:00 PM, Dilip Pandey  wrote:
> Hi Pradeep,
>
> Look out for green shaded cell in the attached spreadsheet, in which I have
> done something for you.
>
> Let me know if it works.
> --
> 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 Tue, Jul 13, 2010 at 3:52 PM, Pradeep 
> wrote:
>>
>>
>> "The information contained in this electronic message and any attachments
>> to this
>> message are intended for exclusive use of the addressee(s) and may contain
>> confidential or privileged information. If you are not the intended
>> recipient, please
>> notify the sender at LIC OF INDIA or co_mailad...@licindia.com immediately
>> and
>> destroy all copies of this message and any attachments. The views
>> expressed in
>> this E-mail message / Attachments, are those of the individual sender."
>>
>>
>> -- Forwarded message --
>> From: Pradeep 
>> To: "excel-macros@googlegroups.com" 
>> Date: Tue, 13 Jul 2010 13:17:48 +0530
>> Subject: Help for format converson required
>> Dear
>> Gurus,
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> row 2 & 4
>> are the
>> bank
>> statement
>> format
>> which I
>> receive. I
>> want it to
>> be
>> converted
>> as row 3 &
>> 5
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> or finally
>> as row 16
>> for
>> merging
>> them in
>> our
>> software
>> for bank
>> reconciliation.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Can some
>> one help
>> me.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Thanks in
>> advance
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Pradeep
>> Agarwal
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
> --
> --
> 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


format.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Data Logic

[Sandeep Kumar Maurya]

Hi Al,

Please find the attached file for your required solution.

Regards
Sandeep

On Thu, Jul 15, 2010 at 5:46 AM, Al  wrote:
>
> Dear All:
>
>
> This is the sample spread sheet i have.
>
>  pat meds stdt spdt
>  111 ABC 1 .
>  111 CDE 130 150
>  111 NNN 132 140
>  111 GHI 160 170
>  111 LMN 165 .
>  111 OPQ 168 .
>  222 ABC 1 .
>  222 CBM 130 140
>  222 AAA 135 140
>  222 KHA 1 .
>  ;
> run;
>
>
>
> I am trying to count the number of meds at different time points and
> create three fields week 20,week 24 and diff
> based on the following.
>
> number of meds at week 20 = number of meds with no spdt and stdt = 1 +
> any meds between (127(stdt) to 154(spdt)) + any meds between
> (127(stdt) to 154(spdt)) and spdt = .
>
> number of meds at week 24 = number of meds with no spdt and stdt = 1 +
> any meds between (155(stdt) to 182(spdt)) + any meds between
> (155(stdt) to 182(spdt)) and spdt = .
>
> Ideally, this is what i am tring to get to ,one record per pat
>
>
> Pat week 20 week 24 diff(week 24-week 20)
> 111  3        4       1
> 222  4        2      -2
>
> I hope i wasnt confusing ..
>
> Thanks in advance ..
> Al
>
> --
> --
> 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


Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Finding a cell based on multiple criteria typed into cells

[Sandeep Kumar Maurya]

Hi David,

Please find the solution you required. Feel free to ask anything from me.

Regards
Sandeep

On Wed, Jul 14, 2010 at 3:11 PM, Sach1810  wrote:
> Hi, I have a table of data giving different prices of different items.
> Below is a sample of that data. I want to be able to type in teh
> criteria (Shape Weight  Colour  condition) and then the document to show
> me the price for that criteria.
>
> Say A1 = SHAPE
> B1=Weight
> c1 = colour
> d1 = condition
>
> And where the table says circle its cell b3
>
> Circle   square
> Blue     Red     Blue    Red
> old     new     old     new     old     new     old     new
> Weight
> 0.1     £1.00   £3.00   £2.00   £4.00   £1.50   £3.50   £2.50   £4.50
> 0.2     £2.00   £4.00   £3.00   £5.00   £2.50   £4.50   £3.50   £5.50
> 0.3     £3.00   £5.00   £4.00   £6.00   £3.50   £5.50   £4.50   £6.50
> 0.4     £4.00   £6.00   £5.00   £7.00   £4.50   £6.50   £5.50   £7.50
> 0.5     £5.00   £7.00   £6.00   £8.00   £5.50   £7.50   £6.50   £8.50
> 0.6     £6.00   £8.00   £7.00   £9.00   £6.50   £8.50   £7.50   £9.50
>
> Thanks
>
> Your help will be much appreciated
>
> Sacha David
>
> --
> --
> 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


Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Index match with 3 criteria

[Sandeep Kumar Maurya]

Hi,

Yes I can, but need a sample file for proper result you want.

Regards
Sandeep

On Thu, Jul 15, 2010 at 2:09 AM, Nadine S  wrote:
> I need to lookup a value based on matching 3 other columns.  I do not want
> to use a concatenation and then look up that.
>
> I have Sheet1 that has 4 columns in it and Sheet2 that has 3.
> In Sheet 2, Column D, I need a formula that will return the text in Col D on
> Sheet1 if the values in the first three columns in each sheet match.  Does
> anyone know how to do this in Excel 2003?
>
> 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$$

[Sandeep Kumar Maurya]

Hi,

Please find the attached file for your required solution.

Regards
Sandeep



On Tue, Jul 6, 2010 at 4:28 PM, Ankit Chandna wrote:

> Dear,
>
> Can u plz tell me exact procedure.i do hv ASAP utilities.
>
> --- On *Tue, 6/7/10, Mahesh * wrote:
>
>
> From: Mahesh 
> Subject: Re: $$Excel-Macros$$
> To: excel-macros@googlegroups.com
> Date: Tuesday, 6 July, 2010, 9:50 AM
>
>
>  Hi Ankit,
>
> Use ASAP utilities, it will solve your problem.
>
>
>
> On Tue, Jul 6, 2010 at 1:02 PM, Ankit Chandna 
> http://in.mc950.mail.yahoo.com/mc/compose?to=ankit.chan...@yahoo.in>
> > wrote:
>
>> Hi,
>>
>>
>> hi to all ..i need a help PFA and help me to get reqired result.
>>
>> Regards,
>> Ankit
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> With Love,
> Mahesh Bisht
> --
>
> --
> 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


help.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ How to display cell contects as password *****

[Sandeep Kumar Maurya]

Hi,

You can use an alternate way to over come this. change the text color
of cell to same as background then lock and hide it. After this
protect the sheet.

Thanks and Regards
Sandeep.



On Tue, Jun 15, 2010 at 10:45 AM, Rajesh Bedse  wrote:
> thx Vikas.
>
> The issue with this formatting is that it shows  only when the
> cell data is number.
> I want the cell should always show the data as  no matters what
> the actual data is in the cell i.e. for number as well as for
> character data.
>
> Please suggest.
>
> ~ Rajesh
>
> On Jun 11, 9:49 pm, Vikas Chouhan  wrote:
>> Chk this
>>
>>
>>
>> On Fri, Jun 11, 2010 at 7:19 PM, Rajesh Bedse  wrote:
>> > hey Paul,
>>
>> > Plz let me know how can I atleast display the data like '***'
>> > See teh below message sent my Saurabh... using this we can hike the
>> > contents from formula bar.
>>
>> > Just go to format Cell --> Protection Tab --> Check the hidden box and
>> > uncheck the locked box. Then protect the work sheet.
>>
>> > @ Saurabh
>> > thnx a lot
>>
>> > ~ Rajesh
>>
>> > On Jun 11, 10:11 am, Rajesh Bedse  wrote:
>> > > Thnx Paul,
>>
>> > > Yeah.. it will display data in formula bar. I don't want to display
>> > > that.
>> > > Plz help.
>>
>> > > ~ Rajesh
>>
>> > > On Jun 10, 10:58 pm, Paul Schreiner  wrote:
>>
>> > > > the problem is that you can change the cell formatting to make it LOOK
>> > like "***"
>> > > > but you'll see the actual value in the toolbar at the top, which isn't
>> > good!!!
>>
>> > > > P
>>
>> > > > 
>> > > > From: Rajesh Bedse 
>> > > > To: MS EXCEL AND VBA MACROS 
>> > > > Sent: Thu, June 10, 2010 6:35:28 AM
>> > > > Subject: $$Excel-Macros$$ How to display cell contects as password
>> > *
>>
>> > > > Hi friends,
>>
>> > > > I want to display a cell content as password (i.e. like )
>> > > > but the data should exist there.. so that I can use the same data in
>> > > > macro for login purpose.
>>
>> > > > ~ Rajesh
>>
>> > > > --
>>
>> > --
>> > > > 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 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 at
>> >http://groups.google.com/group/excel-macros/subscribe
>>
>> --
>> One Team One Dream One Goal
>>
>> Warm Regards,
>> Vikas Chauhan
>> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
>> 9911868518,
>> "We can't Spell S_ccess without U"
>>
>> Life is Very beautiful !!!
>> ¨`•.•´¨) Always
>> `•.¸(¨`•.•´¨) Keep
>> (¨`•.•´¨)¸.•´ Smiling!
>> `•.¸.•´.
>>
>>  Passwords.JPG
>> 54KViewDownload
>
> --
> --
> 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.go

Re: $$Excel-Macros$$ IF AND formulas

[Sandeep Kumar Maurya]

Hi Mike,

It will be better if you send a sample file with some data and your
query. As it may give you a shorter and simple formula for your task.

And about this formula, one can only show  you the syntax error and
that not guaranteed for formula to give desired result.

So if you can than attach a sample file.

Thanks & Regards
Sandeep

On Wed, May 12, 2010 at 2:22 AM, mikeb  wrote:
> I would appreciate any help on the following formula which I cannot
> get to work:
>
> =IF(AND('TEST PLAN'!$U$14:$U$10134="11",(IF(SUM(IF('Test Plan'!$I$13:$I
> $10134="NB",1,0)))>0,SUM(IF('Test Plan'!$I$13:$I$10134="NB",1,0)),
> 0)+IF(SUM(IF('Test Plan'!$I$13:$I$10134="QU",1,0))>0,SUM(IF('Test
> Plan'!$I$13:$I$10134="QU",1,0)),0)+IF(SUM(IF('Test Plan'!$I$13:$I
> $10134="SLIQ",1,0))>0,SUM(IF('Test Plan'!$I$13:$I$10134="SLIQ",1,0)),
> 0)+IF(SUM(IF('Test Plan'!$I$13:$I$10134="PQB",1,0))>0,SUM(IF('Test
> Plan'!$I$13:$I$10134="PQB",1,0)),0-A3
>
> I am trying to qualify the formulas at the beginning by testing to see
> if 'TEST PLAN'!$U$14:$U$10134="11" if it is true then I want to
> proceed with the rest of the formulas.
>
> Thank you for any help.
>
> Mike B
>
> --
> --
> 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 6,800 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 6,800 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: Extract Right Word in Line

[Sandeep Kumar Maurya]

Hi Anand,

You are right, that Asish solution is perfect,
but if you don't want to use VBA you can use this one.

=RIGHT(A1,LEN(A1)-FIND("~",SUBSTITUTE(A1,"
","~",LEN(A1)-LEN(SUBSTITUTE(A1," ","")

Don't see its size, because it is smallest possible using formula.

And I assume that your text don't have '~' character in them if they
have then change this character in formula with one which is absent in
your text.

Thanks & Regards
Sandeep


On Fri, May 7, 2010 at 3:36 PM, anand shivappa  wrote:
> I am fine buddy.
>
>
> If it is more than 5 words in a cell  how will you extract the right word.
>
> Probably Ashish has sent was the perfect solution for it.
>
> Thanks and Regards,
> Anand S
>
>
> On Fri, May 7, 2010 at 9:49 AM, Vikas Chouhan  wrote:
>>
>> hi anand how are you
>>
>>
>>    A    B
>> 1 vikas kumar   =right(A1,LEN(A1)-FIND(" ",A1)   RESULT IS "KUMAR"
>>
>> On Thu, May 6, 2010 at 9:39 AM, P.VIJAYKUMAR  wrote:
>>>
>>> Use the function RIGHT(Select the whole text in which the textor the
>>> thing which you want is there,number of characters which you want from the
>>> text)
>>> Ex: If a Cell B2 Contains    TIGER999 .Use the function = RIGHT(B2,3) to
>>> get the required 999 as the answer.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Thu, May 6, 2010 at 9:22 PM, ashish koul 
>>> wrote:

 Public Function exright(Str)
     Dim i, NumStr1
     NumStr1 = ""

     For i = Len(Str) To 1 Step -1
     If (Mid(Str, i, 1)) <> " " Then
     NumStr1 = Mid(Str, i, 1) & NumStr1

 Else
 Exit For

     End If
     Next i
     exright = NumStr1
 End Function



 On Thu, May 6, 2010 at 6:15 PM, anand shivappa
  wrote:
>
> Please help out. I got struct here.
>
>
>
> On Thu, May 6, 2010 at 5:45 PM, anand shivappa
>  wrote:
>>
>> Hi Everyone,
>>
>> I need to extract a rightmost word in a line through excel functions.
>>
>> Like USA Street is having no 10.  I need to extract the last word like
>> 10.
>>
>> Please help me out.
>>
>>
>> Thanks and Regards,
>> Anand S
>>
>>
>> --
>> When everything fails Patience will win
>
>
>
> --
> When everything fails Patience will win
>
> --
>
> --
> 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 6,800 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 6,800 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
>>>
>>>
>>>
>>> --
>>> P.VIJAY 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 6,800 subscribers worldwide and receive 

Re: $$Excel-Macros$$ Maximum Date

[Sandeep Kumar Maurya]

@Dilip Ji

You are always Welcome sir.

Thanks
Sandeep

On Mon, May 10, 2010 at 7:54 PM, Dilip Pandey  wrote:
> Thanks Sandy,
>
> @ Dheeraj, I think you have got the answer for your query.
>
> Get back, in case of any other queries.
>
> --
> 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, May 10, 2010 at 3:32 PM, Dheeraj Bankoti  wrote:
>>
>> Thanks to Dilip,
>> I have one more query & attachment is find herewith.
>>
>>
>>
>> Regards
>>
>>
>> --
>>
>> --
>> 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 6,800 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 6,800 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 6,800 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$$ vlookup with 2 criteria

[Sandeep Kumar Maurya]

Hi nino,

check my reply in the $$Excel-Macros$$ Maximum Date problem.

Thanks & Regards
Sandeep

On Sun, May 9, 2010 at 1:12 PM, Ravi Megharaj  wrote:
>
> You can concatenate Column A and Column B to get the unique value. Then do a 
> vlookup to get the exact value. Once performing this operation, you can 
> delete the concatenated column.
>
> Hope this helps
>
> Ta
> Ravi
>
> On Sun, May 9, 2010 at 12:04 PM, madhu nair  wrote:
>>
>> send a sample sheet buddy
>>
>> On Sun, May 9, 2010 at 12:07 AM, nino  wrote:
>>>
>>> hi,
>>> does anyone have idea or solution to solve search over 2 columns range
>>> where both criteria needs to be met.
>>> e.g. if you have database with 3 columns. column A is account, column
>>> B is cost centar and column C is value.
>>> I would like to search for value of specific account for specific cost
>>> center. vlookup can find the value for specific account, but sa,e
>>> account occurs on multiple cost centres. thx. nino
>>>
>>> --
>>> --
>>> 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 6,800 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,
>>
>> Madhu Nair
>>
>> --
>> --
>> 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 6,800 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 6,800 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 6,800 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$$ Maximum Date

[Sandeep Kumar Maurya]

Hi Dheeraj,

Check the attached file, I think it will satisfy you. Both are array
formula, so you have to press CTRL+SHIFT+ENTER.

Thanks & Regards
Sandeep

On Mon, May 10, 2010 at 3:32 PM, Dheeraj Bankoti  wrote:

>
> Thanks to Dilip,
> I have one more query & attachment is find herewith.
>
>
>
> Regards
>
>
> --
>
> --
> 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 6,800 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 6,800 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


formula.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ TOUGH QUESTION

[Sandeep Kumar Maurya]

Hi,

It is possible AZHAR. What you have to do is

1. Mail merge all the links in word document.
2. Then use macro in MS Word to insert picture for all the links which have
a image extension, like jpg, bmp etc.

How you will do this.

Apply the straight method of learning VBA.

1. Record a macro for the process you want. Then remove lines and see the
effect in document to get the only needed lines of code.
2. Do your stuff in 2 or 3 macros to get it clearly and perfectly.
3. Finally edit and combine the macros to get only 1 final macro for your
job.


Thanks & Regards
Sandeep

On Fri, May 7, 2010 at 7:03 PM, Aindril De  wrote:

> Hi azhar,
>
> Are these images stored somewhere in your local disk or online?
>
> Regards,
> aindril
>
> On Fri, May 7, 2010 at 10:46 AM, Azhar Rai  wrote:
>
>> Dear Members
>>
>> Can someone help me create a trick related to mail merge in Office
>> 2007/2010.
>>
>> I want to mail merge pictures FROM an excel sheet (where there are
>> hyperlink to different pictures) TO a word document.
>>
>> Your help will save a lot of my time and efforts.
>>
>> Regards
>>
>> AZHAR RAI
>> Cell: 0333-552-7731
>> Skype: azhar.rai
>>
>> --
>>
>> --
>> 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 6,800 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 6,800 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 6,800 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$$ EXCEL SHORTCUT -- PLEASE HELP :-)

[Sandeep Kumar Maurya]

When we write function in any excel cell, EXCEL 2007 shows us a list of
functions available from the word or character we written in the cell.

Michael wants to know how we can get the function in the cell when list
appears without writing it completely.

So the solution is start to write your function in cell and when list
appears then go to the desired function by down arrow key and then press tab
to get the function in cell.

Thanks Regards
Sandeep

On Fri, May 7, 2010 at 1:03 PM, L.K. Modi  wrote:

>
> sorry did not get select the funcion and presss tab can u expalin this dear
> friend
>
>
>
>
>
>
>
> On Fri, May 7, 2010 at 11:54 AM, Sandeep Kumar Maurya <
> sandymau...@gmail.com> wrote:
>
>> Select the function and press tab.
>>
>> Thanks & Regards
>> Sandeep
>>
>>
>> On Thu, May 6, 2010 at 11:38 PM, Michael  wrote:
>>
>>> I posted a picture of what I'm trying to discover:
>>>
>>>
>>> http://excel-macros.googlegroups.com/web/5-6-2010%2010-30-03%20AM.png?gsc=KEUGpSMAAABiUNuXkcp8v73inTrP5WRB6rVQQoo7NfTRwCUKHBmr860IoyLhPG2x5smOr2otMGI
>>>
>>> Does anyone know of a shortcut to select from the drop down of
>>> suggested terms when creating a formula? (i.e. what would I need to
>>> press on my keyboard to finish populating the "chain" named range into
>>> my formula without typing out the thing?)
>>>
>>> Currently, I know you need to double click with your mouse to
>>> accomplish this; however, it's cumbersome when updating complex array
>>> formulas.
>>>
>>> Thanks so much for yoour help in advance!
>>>
>>> Michael
>>>
>>> --
>>>
>>> --
>>> 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 6,800 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 6,800 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 !!

Re: $$Excel-Macros$$ EXCEL SHORTCUT -- PLEASE HELP :-)

[Sandeep Kumar Maurya]

Select the function and press tab.

Thanks & Regards
Sandeep

On Thu, May 6, 2010 at 11:38 PM, Michael  wrote:

> I posted a picture of what I'm trying to discover:
>
>
> http://excel-macros.googlegroups.com/web/5-6-2010%2010-30-03%20AM.png?gsc=KEUGpSMAAABiUNuXkcp8v73inTrP5WRB6rVQQoo7NfTRwCUKHBmr860IoyLhPG2x5smOr2otMGI
>
> Does anyone know of a shortcut to select from the drop down of
> suggested terms when creating a formula? (i.e. what would I need to
> press on my keyboard to finish populating the "chain" named range into
> my formula without typing out the thing?)
>
> Currently, I know you need to double click with your mouse to
> accomplish this; however, it's cumbersome when updating complex array
> formulas.
>
> Thanks so much for yoour help in advance!
>
> Michael
>
> --
>
> --
> 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 6,800 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 6,800 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$$ Urgent need some about how can calculate week

[Sandeep Kumar Maurya]

May be you want this.
Find the attached file.

Regards
Sandeep

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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 6,800 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

To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
"REMOVE ME" as the subject.


round up function-1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Who to remove hyperlinks

[Sandeep Kumar Maurya]

Hi,

write 1 in a blank cell and then copy it and use multiply option in 'paste
special'.
It also put 0 in blank selected cells.

Regards
Sandeep

On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram <06n...@gmail.com> wrote:

> Hi Members,
>
> i have huge data with hyperlinks.
> Is there any shortcut key or formula to remove all hyperlinks at once.
>
>
> Thanks,
>
> Naniram
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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 6,800 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
>
> To unsubscribe from this group, send email to excel-macros+
> unsubscribegooglegroups.com or reply to this email with the words "REMOVE
> ME" as the subject.
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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 6,800 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

To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
"REMOVE ME" as the subject.

Re: $$Excel-Macros$$ Excel Formula Required

[Sandeep Kumar Maurya]

Simplest possible. But needed unique list (no duplication).

Regards
Sandeep

On Thu, Mar 18, 2010 at 8:37 PM, Dilip Pandey  wrote:

> Dear Venkatesan,
>
> Attached file has two solutions for your query.
> Let me know in case of any challenge(s).
>
>
> --
> 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, Mar 18, 2010 at 2:31 PM, Venkatesan c wrote:
>
>> Dear All,
>>
>> Any one can Assist me attached file query It's something like reverse
>> Lookup
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 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 6,800 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 Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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 6,800 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 Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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 6,800 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

To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
"REMOVE ME" as the subject.


Query-Reverse Vlookup by DILipandey.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Require help on a condition

[Sandeep Kumar Maurya]

Hi,

Find the attached sheet with formula.

Regards
Sandeep

On Fri, Nov 20, 2009 at 10:35 AM, Sivakumar E.S  wrote:

> pooja Sharma
>
> Find attached an excel file with vba macro.  place ur cursor anywhere in
> reference column and run macro... u will see result in next sheet Hope
> this helps
>
> Regards
> sivakumar
>
> On Thu, Nov 19, 2009 at 1:35 PM, Pooja Sharma wrote:
>
>> Hi All,
>>
>> I've attached a file in which, a data is mentioned with the required
>> solution. If any body can help me in this, it will be of great help.
>>
>> --
>> Best Regards
>> Pooja Sharma
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Conditional result.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ How to sum on the basis of color

[Sandeep Kumar Maurya]

Hi,

You can filter on the basis of color in excel 2007. And with that you can
use subtotal(9,Range) for your data.

Subtotal don't sum those value which are hidden.

Thus you can get sum on the basis of color in excel 2007 using filter and
subtotal.

But if you want to see both value at time then it is not possible using this
method. There are many experienced person in the group who may help you out.

Regards
Sandeep

On Fri, Nov 20, 2009 at 5:30 PM, Dave Bonallack
wrote:

>  Hi Manoj,
> I've looked at XL2007, but it appears I was mis-informed. I see no built-in
> function for summing by colour. Sorry.
>
> Regards - Dave.
>
> --
> Date: Thu, 19 Nov 2009 13:40:27 +0530
>
> Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
> From: manojsnegi.uttranc...@gmail.com
> To: excel-macros@googlegroups.com
>
> Thank you very much Dave.
> Can you suggest some clue how to do the same think in excel 2007 without
> macro.
>
> Unfeigned Regards
> Manoj S Negi
> Skype - manojsnegi
>
>
> -- Forwarded message --
> From: *Dave Bonallack* 
> Date: Thu, Nov 19, 2009 at 1:12 PM
> Subject: RE: $$Excel-Macros$$ How to sum on the basis of color
> To: "excel-macros@googlegroups.com" 
>
>
>  Hi,
> The attached uses a macro to do your bidding. But I think XL2007 can do
> this without macros, but I only have XL2003.
> Regards - Dave
>
> --
> Date: Thu, 19 Nov 2009 12:45:00 +0530
> Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
> From: manojsnegi.uttranc...@gmail.com
>
> To: excel-macros@googlegroups.com
>
> Hi All,
>
> please help on this
>
>
> Unfeigned Regards
> Manoj S Negi
> Skype - manojsnegi
>
>
> -- Forwarded message --
> From: *Manoj S Negi* 
> Date: Wed, Nov 18, 2009 at 12:56 PM
> Subject: $$Excel-Macros$$ How to sum on the basis of color
> To: excel-macros@googlegroups.com
>
>
> Hi All,
>
>
> Kindly help me out as I want to sum the no. as per the color. Is there any
> command by which we can sum the data as per color.
>
>
> Sheet is also attached for further reference.
>
> Hoping for a favorable response soon.
>
>
> *Unfeigned Regards
> Manoj S Negi
> Skype - manojsnegi*
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
> --
> Brought to you exclusively by Windows Live Download new and classic
> emoticon packs at Emoticon 
> World
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, p

Re: $$Excel-Macros$$ Plz Urguntly Help needfull

[Sandeep Kumar Maurya]

Hi Anil,

>From Insert menu goto Define Names (As you do for named ranges) then give
the Each name (Anil) the value you want.

Then
   A B
1Anil   =indirect(A1)
2Saxena =Indirect(A2)


Regards
Sandeep

On Thu, Nov 19, 2009 at 2:39 PM, Anil Saxena wrote:

>
>
> -- Forwarded message --
> From: Anil Saxena 
> Date: Thu, Nov 19, 2009 at 10:28 AM
> Subject: $$Excel-Macros$$ Plz Urguntly Help needfull
> To: Dilip Pandey 
> Cc: excel-macros@googlegroups.com
>
>
> Hi Ayush
> plz help me Urguntly
>
> Plz suggest me how to use formula like these e. g. when i written any names
> automatically put value. when I written "Saxena" then show the value of
> Saxena that is 155
>
> e. g.
>
>  Anil 100
> Saxena 155  Saxena 155
> Guni 290  Pratham 285
> Yash ___  Guni 290
> Sonu ___  Sonu 145
> Anil ___  Yash 50
> Pratham ___
>
>
>
>
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Flagging duplicate values with Countif and Search functions re partial matches

[Sandeep Kumar Maurya]

Check the file.

On Sun, Nov 15, 2009 at 6:39 PM, Dilip Pandey  wrote:

> Dear Dan,
>
> I have tried to build up the data as mentioned by you and able to get the
> desired result.
> Same spreadsheet is attached herewith for your review.
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On 11/15/09, dsulliva  wrote:
>>
>> Hi Everyone...I have a list of names (column A) and in column B I want
>> a formula to flag all duplicate items in column A. I was using the
>> formula =IF(COUNTIF($A$2:$A$10,A2)>1,1,0) where "1" would flag me to a
>> possible duplicte (i.e. I could filter on it).
>>
>> The data in column A is causing problems. Column A contains names. It
>> could be in the format first name / last name or last name / first
>> name. There also could be a comma or a semi-colon separating the 2.
>> There almost always will be a space between the two. My solution was
>> to use the last 4 or 5 charactes of the column A cell and use that as
>> a condition in the count if. It looks something like this, but I can't
>> get it to work.
>> =IF(COUNTIF($A$2:$A$13,IF(ISERROR(SEARCH(RIGHT($A2,2),$A2,1))=TRUE,
>> 0,1)), 1,0)
>>
>> Can someone give me some advice? I'm also open to other formulas /
>> functions that would allow me to flag possible duplicate names based
>> upon a partial match of the cell (e.g. a cell in column A containing
>> "Ron Smith" would have to identify "Smith, Ron"; "Smith Ron"; "Smith;
>> Ron"; "Ron, Smith" as a potential duplicate values). Then there's
>> possible duplicate data that contains spelling errors (e.g. Smith vs.
>> Smithh vs. Smyth). I don't think there's any help for that??
>>
>> I'd prefer not to sort, subtotal, etc. the data and I'm using Excel
>> 2003. I also don't want VBA solutions.
>>
>> Thanks
>> Dan
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain  @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Flagging duplicate values.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need Urgent Help ~ Vlookup

[Sandeep Kumar Maurya]

Hi Anish,

See the attached file. Don't change position of 'Auto Reset', 'Counter' and
'Auto Switch' else it may not work properly.

Also it can be done easily with VBA, so if you need then ask the solution in
VBA and you will get a quick response from the group.

Regards
Sandeep

On Fri, Nov 13, 2009 at 1:01 PM, Anish Shrivastava wrote:

> Hello Experts,
>
> Once agian I am here with a new problem (Thanks for helping me earlier, on
> my code).
>
> This time I am stuck with Vlookup, actually I have a list of lot # for
> which I have to find TIC # from another table but the problem is it has got
> multiple occurances. Our simple vlookup picks the first one (as it alwasy
> does :-) ) . But I want all the values *(TIC #)* in column B (as
> Concatenated) for the *"lot numbers"* available in Column A from the
> table.
>
> I tried with INDEX and various formulas available on net..but not
> successful
>
> Hope to have a solution from you experts soon... (have attached the file
> wid bit explaination there too)
>
> Thanks!!
> ANISH
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Anish_Prob.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Excel macro-Help

[Sandeep Kumar Maurya]

Hi,

I update the macro as per your use and assign a shortcut too. There are some
guidelines follow them to use desired result.

Regards
Sandeep

On Tue, Oct 6, 2009 at 11:35 PM, Umesh Matkar  wrote:

>
>
> Dear Friends,
> I have one query regarding macro.
> i want to record a macro for goal seek.
> Attached reference sheet says following
>
> Column A - my goal starts from 2009 for 16 years till 2024.
> B - Accumulated amount equal to one row up for column E
> C - goal seek result i.e investment amount, please refer below macro
>  Sub Macro1()
> '
> ' Macro1 Macro
> '
>
> '
> Range("E18").GoalSeek Goal:=2032281, ChangingCell:=Range("C3")
> End Sub
>
> Column D - interest rates
> Column E - Future value of present investments with given interest rate in
> column D
>
> What i have done in this is that i got a target amount of 2032281 which i
> want after 16 years. So the amount what i have to invest monthly with given
> interest rate acquired from goal seek in cell C3.
>
> Challenge is goal years may vary, say it may be for 20 years or 25 years or
> 50 years also not sure. One thing is sure that the interest rate for last
> five years will remain same as given but for remaining previous years it
> will be as what is in starting.
> E.g: if you see in this sheet first 11 years interest rate is same and last
> five years we have to keep interest rate same what is given
> but if we go for 20 years then last five years interest will be same what
> is given. but for prior 15 years interest rate has to be change what is
> given for 11 years above. accordingly table should be prepared and goal seek
> features should also be used in macro.
>
> I am attaching the file. Please revert in case of any questions.
> Please help.
>
>
> Thanks
> Umesh
>
>
>
>
>
>
>
>
> --
> Warm Regards,
>
> You mesh
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



goalSeek Solved.xlsm
Description: application/vnd.openxmlformats-officedocument.spreadsheetml

$$Excel-Macros$$ Re: excel + vba + html

[Sandeep Kumar Maurya]

Hi,
There are many free online spreadsheet solution, you should give try to one
of them (Personally I never use them because I never need and online excel
file).

Follow this link and you will get many online spreadsheet solution and
choose as per your need.

http://mashable.com/2008/02/06/forget-excel-14-online-spreadsheet-applications/

Regards
Sandeep

On Wed, Oct 7, 2009 at 1:21 AM, Ane  wrote:

>
> Hello everyone,
>
> I am from Brazil and I am developing a document in excel with a lot of
> vba codes (buttons, combobox, hyperlinks) and it has arount 150sheets
> (some are hidden, and I only have access to it if I select on a
> combobox)
>
> I am thinking about to post this document on a webpage, but not as a
> link.
> I would like to export it as a page and I would like to see all my
> buttons and codes working properly.
>
> I would like to know if is there any possibility to do it.
>
> could someone help me?
>
> Thanks a lot.
>
> kind regards.
>
> Ane
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Looking for most effecient way to convert lots of data

[Sandeep Kumar Maurya]

Hi,

First you have to retrieve unique phone numbers I have given the steps in
attached file then use the formula as shown in the file.

Regards
Sandeep

On Wed, Oct 7, 2009 at 6:41 AM, bruce  wrote:

>
> I am creating a program that does daily QA of our products. I work for
> a phone company and we sell differnt lines, with differnt options
> What I need to do is to convert one speadsheet where the features of
> the phone lines are in a list, one feature per row
>
> Simplified input file
> PhoneNum
> 555-Caller ID
> 555-Voice Mail
> 555-Call Waiting
> 555-Speed Dial
> 555-Caller ID
> 555-Call Forwarding
> 555-Call Waiting
>
> The output I need is to be 1 row per phone number, with each feature
> checked in it own column
> Desired output would be
> PhoneNum   CallerIDVoiceMailCallWaitingSpeedDial
> CallForwarding
> 555-  Yes Yes  Yes
> Yes   No
> 555-  Yes  No   Yes
> No   Yes
>
>
> I have over 200K row of input, each phone may be upwards of 40
> features each
> I recieve about 600 new entries a day
>
> this is a very simplified example, as I need to deal with the account
> numbers, each account can have upto about 32 phone lines (each row
> will be its own phone number), and the source data is broken into 6
> differnt files, each with its own key, that needs to be related to a
> differnt key/file) These different files have the different "feature
> sets" (for security reasons, none of these files have the phone
> number, so I still need to pull that from a DIFFERENT file, and then
> cross reference)
>
> There are, between yellow page features, phone feature, directory
> assist listing info, there are about 100 items that each number COULD
> have any selection of (I will need to build in error correcting, as
> some feature will force other feature OFF, but that is a seperate item
> unto itself)
>
> What would be the most effecient way to handle this? A top down from
> the SOURCE, processing each line one by one, or getting a list of the
> phone numbers, and then from the desired output, find the phone, and
> desired feature to check for.
>
>
> I think the first way would be the best way, but I am not sure I would
> need to process each source, line by line, and then doing a look of
> the phone number in its speardsheet, then do a lookup in the output
> file.I think with the fact of the cross referencing going on, option 2
> might be easier, but I would be doing lots of vlookup/matches, and
> creating "key fields" to search on.
>
> Are there other ways I might consider?
>
> Thanks
> Mctabish
>
>
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



QA_solution.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: DATA>IMPORT >XML Missing in excel 2003 standard edition

[Sandeep Kumar Maurya]

Hi,

Don't your Excel 2003 has Data->XML->Import. Check Again.

Regards
Sandeep

On Tue, Oct 6, 2009 at 5:57 PM, Manoj Kukrej  wrote:

>  Hi,
>
> I want to know how I can add xml in it
>
> I have checked in tools > commands>xml is also missing
>
> Regards
>
>
>
> Manoj
>
> --
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this e-mail
> or its contents to any other person and any such actions that are unlawful.
> This e-mail may contain viruses. Ocimum Biosolutions has taken every
> reasonable precaution to minimize this risk, but is not liable for any
> damage you may sustain as a result of any virus in this e-mail. You should
> carry out your own virus checks before opening the e-mail or attachment.
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Best Way to Mimic Relational Data?

[Sandeep Kumar Maurya]

Hi,
I used vlookup( ) for this. See the attached solution.

Regards
Sandeep

On Wed, Oct 7, 2009 at 2:34 AM, HumanJHawkins  wrote:

>
> I have a list of 15000 rows of response data about questions that
> showed up on a series of tests. There is often more than one row for
> each test question, because each question was used in more than one
> event.
>
> So the data may be like:
> 1   A   3.33
> 1   B   2.99
> 2   A   1.11
> 2   C   1.13
> etc.
>
> Unfortunately, I need to match up a different type of ID to each row.
> I have a table of ID translations that looks like this:
> 1   N23
> 2   O12
> etc.
>
> What is the easiest way to relate these two sets of data so I get a
> table like this:
> 1   N23   A   3.33
> 1   N23   B   2.99
> 2   O12   A   1.11
> 2   O12   C   1.13
>
> Thanks in advance for any suggestions.
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Solution_using_vlookup.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Unique record retrieval

[Sandeep Kumar Maurya]

Hi,

If you want to retrieve a unique row then select all data go to 'Advance
filter' and check 'unique records only'. Choose 'Filter the list, In place'
if you want to just filter the data and choose 'Copy to another location' if
you want to copy the filter list to another place, (select any blank cell
below your data for 'Copy to another location' option.

If you need more info then ask me freely.

Regards
Sandeep

On Mon, Sep 28, 2009 at 6:49 PM, Aligahk06  wrote:

> Please find the attachment for my query.Help require vba or formulae or
> any optimized solution?
>
> Rgds,
> Aligahk06
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: help plz

[Sandeep Kumar Maurya]

Hello Ashish,

Do you have your data ready or you want to enter the data then a new row
below it.
Means your data already have "parent co" in column B are you going to enter
it in column B.

Regards
Sandeep


On Wed, Sep 23, 2009 at 10:29 AM, ashish koul  wrote:

> inserting a blank row with matching value in a cell
>
> like when
>
> my cell vale in  colm b  is "parent co"
>
>
> i want to insert a blank row
>
> and shifting my data down
>
>
>
> Thanks
>
>
> Ashish
>
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Need urgent help on finding formula

[Sandeep Kumar Maurya]

Hi VR,

Find the attached solution.

Regards
Sandeep

On Tue, Sep 22, 2009 at 8:05 PM, vinod rao  wrote:

> HI Team,
> need a foumula to find the latest Date and in next column the Status
> Plz find attached.file.
>
> Thanks in advance.
> VR
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Work (Solved by Sandeep).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Fwd: Name Matching In Excel

[Sandeep Kumar Maurya]

Hi Sonal,

I take a look on your data and find that your data in file1 and file2 are
not same as there are some short names and no middle name in one of the file
but the other one has full name and short middle name.

It can be done with VBA but if your data is not unique then there is no
guarantee of right answer due to unmatched names in file1 and file2. Means
it may give wrong answer if there are two Manoj in your data with different
surname but same first surname letter or Any mukesh have same surname as
Manoj and written in short form M Vartak.

Regards
Sandeep

On Tue, Sep 22, 2009 at 10:28 PM, Sonal Gadgil wrote:

> Hi All.
>
> Please help me in this
>
> Thanks & Regards
> Sonal Gadgil
>
>
> -- Forwarded message --
> From: Sonal Gadgil 
> Date: Mon, Sep 21, 2009 at 9:46 PM
> Subject: Name Matching In Excel
> To: excel-macros@googlegroups.com
>
>
> Hi...
>
> I am new in this group.
>
> I am facing one proble while working in the excel.
>
> I am having two excel files where i have to map the customer based on
> customer name by matching customer name manually.
>
> Now, in case there is any macro available which help me to search & map
> names this will be great help to me & other users
>
> Example:
>
>
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Need help on formula

[Sandeep Kumar Maurya]

Hi Vinod,

Did you find my solution or not?
This is my seventh mail.

Regards
Sandeep

On Wed, Aug 26, 2009 at 9:50 AM, Prashant Bhawar
wrote:

>
>
> On Tue, Aug 25, 2009 at 9:52 PM, vinod rao  wrote:
>
>> Hello Team,
>>
>> How do i rank only positive numbers. Plz help me on formula.
>>
>> Example
>>
>> Amount Rank
>> 200 2
>> 100 3
>> -50NA
>> 10  4
>> -5  NA
>> 3001
>>
>>
>>
>>
> i attched a solution
>
> --
> Warm Regard
>
> Prashant Bhawar
>
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Rank positive.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Separate Fields in fastest way

[Sandeep Kumar Maurya]

Hi,
find the attach solution for your problem.

Sandeep

On Wed, Jul 8, 2009 at 10:50 AM, Deepak Rawat wrote:

> Dear friends
> have attached a file in which all fields are merged and have
> to separate all fields as soon as possible.
> pl suggest me the way.
>
> there is another problem, i want to filter the records which have character
> and not numbers is there any wild card combination to apply such filter.
>
>  Regards,
> Deepak Rawat
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,000 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---