date:20101129

Re: $$Excel-Macros$$ Fwd: Help required for formule

2010-11-29 Thread ashish koul

Check the attachment see if it helps

On Tue, Nov 30, 2010 at 11:35 AM, Jagadeesh B S  wrote:

>
>  Hello Friends
>
> I need a formula or macro( preferabley formule) need to prepare this report
> .
>
> I need a formula which should get the details for the account # mentioned
> in the column A with the reference to the currency,form the sheet DATA, if
> the currency is USD It should pull the value in the column E and if the
> currency is other then USD it should pull the value in the column D.
>
>
>
> Please help with this formula…
>
>
>
> Thanks you very much.:)
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*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/pages/discussexcelcom/160307843985936?v=wall&ref=ts


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

$$Excel-Macros$$ Fwd: Help required for formule

2010-11-29 Thread Jagadeesh B S

Hello Friends

I need a formula or macro( preferabley formule) need to prepare this report
.

I need a formula which should get the details for the account # mentioned in
the column A with the reference to the currency,form the sheet DATA, if the
currency is USD It should pull the value in the column E and if the currency
is other then USD it should pull the value in the column D.



Please help with this formula…



Thanks you very much.:)

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


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

$$Excel-Macros$$ Re: issue with Data validation

2010-11-29 Thread anandydr

I have mailed you back your sheet as I have been unable to attach it
here ... I have used an IF ( ) function to solve your problem in case
you need any assistance in implementing the solution or there is
something which is not proper pleas let me know.

Regards,
Anand Kumar

On Nov 29, 3:26 pm, anil panchal  wrote:
> Dear All,
>
> Please help me on Data Vadidation :-)
>
> I have issue in multi validation I want in first cell A1 Anil & B1 I want
> list of anil like 5 name & second is A2 Sunil & B2 list 4 names.
>
> Thanks & Regards
>
> Anil Kumar
>
>  
>
>  issue with validation.xlsx
> 10KViewDownload

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: headcout dashboard report

2010-11-29 Thread anandydr

Hi,

Just mailed you a few dashboards which I had collected from different
sources on internet. Hope they solve your visualization problem. In
case you have something specific in mind do let us know.

Regards,
Anand Kumar

On Nov 29, 9:19 pm, bhavya khanna  wrote:
> Hi All,
>
> Can someone explain about headcount report in dashboard .how to make . If
> some one has idea plz explain about that or send useful sheet.
>
> 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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-29 Thread Rahul Gandhi.

Sir,

Thanks for the prompt action, But I have a Data of 9000 Employees.

I have to Send the Letters to Employees without using the Mail Merge.

Only with The Hlp of Concatenate.

Eg.

="Your Salary is increased with Rs. "&A1&"/- Please find enclosed
attachment which contains the breakup of amount"

What actually I want is the Value which is derived from A1 should be
Bold.


Thanks.
Rahul Gandhi

On Nov 28, 9:37 pm, Dilip Pandey  wrote:
> Hi Rahul,
>
> I dont think there is any existing function using which you can bold
> at text. Considering your problem, I have thought of one smart way :-
> let say A1 has the text which needs to be bold. Go to B1 and type the
> formula =a1. Now apply conditional formatting in B1 that if cell B1 is
> not blank, then text should be bold. (=not(isblank(b1))  :)
>
> Best Regards,
> DILIPandey
>
> On 11/28/10, Rahul Kamal Gandhi  wrote:
>
>
>
> > Guys, Can anyone Help me to Bold the text with the help of Formula
>
> > Eg.
>
> > A1 Cell Contains "ABC"
>
> > I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1)
>
> > And My output should be *ABC* But in Bold Format
>
> > Any Formula or Code.  Please Guys I am Struck
>
> > Regards,
> > Rahul Gandhi
> > +91-9711772297
>
> > --
> > --
> > 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
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
>
> --
> Sent from my mobile device
>
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
>   MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ help required

2010-11-29 Thread Srinivasan Ethirajalu

for alphabets, have filter as "equal to *" &  filter as "greater than 0" for
numerals


On Tue, Nov 30, 2010 at 7:09 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:

> Have a filter "greater than 0"
>
>
> On Mon, Nov 29, 2010 at 11:55 PM, Aamir Shahzad 
> wrote:
>
>> Hi experts,
>>
>>
>>
>> Can anybody resolve the below issues:
>>
>>
>>
>> 1)  More than one value from vlookup function
>>
>>
>>
>> 2)  In office 2007 how I use custom filter e.g.
>>
>> 123
>>
>> 456
>>
>> 789
>>
>> Abc
>>
>> Efg
>>
>> Hij
>>
>> Klm
>>
>>
>>
>> If value begins with alphabets or number I want only alphabets or numbers.
>>
>>
>>
>> Your early response will appreciate.
>>
>>
>>
>> Regards,
>>
>>
>>
>> Aamir Shahzad
>>
>>
>>
>> --
>>
>> --
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> Srinivasan Ethirajalu,
> +919840544295
>



-- 
Srinivasan Ethirajalu,
+919840544295

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ help required

2010-11-29 Thread Srinivasan Ethirajalu

Have a filter "greater than 0"


On Mon, Nov 29, 2010 at 11:55 PM, Aamir Shahzad wrote:

> Hi experts,
>
>
>
> Can anybody resolve the below issues:
>
>
>
> 1)  More than one value from vlookup function
>
>
>
> 2)  In office 2007 how I use custom filter e.g.
>
> 123
>
> 456
>
> 789
>
> Abc
>
> Efg
>
> Hij
>
> Klm
>
>
>
> If value begins with alphabets or number I want only alphabets or numbers.
>
>
>
> Your early response will appreciate.
>
>
>
> Regards,
>
>
>
> Aamir Shahzad
>
>
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
Srinivasan Ethirajalu,
+919840544295

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ help required

2010-11-29 Thread Aamir Shahzad

Hi experts,

 

Can anybody resolve the below issues:

 

1)  More than one value from vlookup function 

 

2)  In office 2007 how I use custom filter e.g.

123

456

789

Abc

Efg

Hij

Klm

 

If value begins with alphabets or number I want only alphabets or numbers.

 

Your early response will appreciate. 

 

Regards,

 

Aamir Shahzad

 

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Selecting specified information from within a cell under a condition and paste that information to a second sheet

2010-11-29 Thread Jorge Marques

It worked perfectly, a thousand thank you for your help :)

2010/11/29 ashish koul 

> try this
>
> Sub Macro1()
> Dim z As Long
>
>Sheets("Folha1").Activate
>  If Sheets("Folha1").FilterMode Then
> Sheets("Folha1").ShowAllData
>   End If
>
>Sheets("Folha1").Range("a65356").Select
> Selection.End(xlUp).Select
>z = ActiveCell.Row
>
> Sheets("Folha1").Range("$A$6:$J" & z).AutoFilter Field:=10,
> Criteria1:="true"
> Selection.Copy
> Sheets("Folha2").Select
> Range("a1").Select
>   Sheets("Folha1").AutoFilter.Range.Copy Sheets("Folha2").Range("A1")
>
>
> If Sheets("Folha1").FilterMode Then
> Sheets("Folha1").ShowAllData
>   End If
>
> End Sub
>
>
> On Mon, Nov 29, 2010 at 12:59 AM, Jorge Marques wrote:
>
>> Hi guys i need badly your help,
>>
>> i want to copy the information of the range of cells from A7:G11 if the
>> condition is true, in this case i want it to copy the information of the
>> rows 8 and 10 to sheet number 2, thank you very much in advance, i put in
>> anex an example of what i need.
>>
>> Jorge
>>
>> --
>>
>> --
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> *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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-29 Thread Rahul Gandhi.

Dear Team,

I Checked the appendedlinks, It only shows the Format,

I want my output in bold format.

Thanks


On Nov 29, 3:54 pm, roberto mensa  wrote:
> 2010/11/29 Chandra Shekar 
>
> > Hi,
>
> > Pls check this site it might help you.
>
> >http://www.mrexcel.com/forum/showthread.php?t=20611
>
> > Thanks
>
> > Chandra Shekar
>
> get.cell returns (not set) information about the formatting, location, or
> contents of a cell.
> A function used in a formula can return a value. It cannot make any changes
> to the workbook.
> There are some exceptions:
>
> Merge
> UnMerge
> AddComment
> ClearComments
> InsertIndent
>
> regards
> r

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ headcout dashboard report

2010-11-29 Thread bhavya khanna

Hi All,

Can someone explain about headcount report in dashboard .how to make . If
some one has idea plz explain about that or send useful sheet.

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$

2010-11-29 Thread Anindya Roy

Thanks a million Dave. You have just served it on a platter for me.

Simply awesome.

But would request you to explain the steps if possible as I am a begginer in
excel. What I could decipher is that

You have formed a separate column and have put the formula.

Then you have formed a separate drop down column in G2 putting the months as
reference - *How did you do this particular step??*

*It also seems that you have done conditional formatting in the main table.
But how is that only the month which am sorting is showing red in
colour??You need to explain me this step too.
*
*Regards*
*Anindya


*
On Mon, Nov 29, 2010 at 2:44 PM, Dave Bonallack
wrote:

> Hi,
> Not quite sure what you mean by "sort out names" but have a look at the
> attached. You can select the month you want by using the drop-down in cell
> G2 (1 to 12)
> The main table contains Conditional Formatting, while Col E contains
> formulas.
> Regards - Dave.
>
> --
> Date: Sun, 28 Nov 2010 23:15:14 +0530
> Subject: $$Excel-Macros$$
> From: anind...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Suppose I have a file which contains names of the candidates along with
> their date of birth. Now if i want to sort out names which have birthday
> falling in the month of november.
>
> How do I do that.
>
> Please note that DOB is mm/dd/ format.
>
>  S.No
>  Beneficiary Name
>  Ward No
>  DOB
>  1
>  Ambarish Ghosh
>  11
>  12/8/1985
>  2
>  Anirban Chakraborty
>  50
>  7/13/1991
>  3
>  Anasuya Das
>  21
>  6/21/1981
>  4
>  Ananya Dasgupta
>  37
>  8/28/1984
>  5
>  Asish Majhi
>  41
>  2/11/1990
>  6
>  Amit Kumar Sharma
>  27
>  2/12/1984
>  7
>  Abhijit Golui
>  37
>  9/30/1989
>  8
>  Bidisha Manik
>  12
>  7/19/1985
>  9
>  Baishakhi Mallick
>  9
>  4/15/1986
>  10
>  Biswajit Paul
>  10
>  9/18/1984
>  11
>  Barnali Roy
>  19
>  11/11/1976
>  12
>  Dipanjan Karar
>  18
>  1/20/1988
>  13
>  Jesmine Mondal
>  39
>  12/18/1985
>  14
>  Kabita Mukherjee
>  38
>  8/24/1984
>  15
>  Kabita Roy Bagchi
>  41
>  8/12/1980
>  16
>  Kalpana Dey
>  48
>  5/6/1983
>  17
>  Kartick Ghosh
>  48
>  11/17/1988
>  18
>  Kuntal Mukherjee
>  50
>  5/5/1982
>  19
>  Madhumita Das
>  39
>  6/4/1985
>  20
>  Madhumita Sardar
>  39
>  5/3/1986
>  21
>  Moumita Debnath
>  34
>  12/23/1988
>  22
>  Poly Mukherjee
>  45
>  9/16/1988
>  23
>  Papia Nath
>  49
>  10/21/1979
>  24
>  Rituparna Pal
>  22
>  12/6/1983
>  25
>  Rini Banerjee
>  33
>  4/21/1988
>  26
>  Shrabani Dey
>  40
>  8/5/1975
>  27
>  Subhajit Sheet
>  49
>  3/10/1991
>  28
>  Soma Ghosh
>  24
>  12/19/1979
>
> Thanks & Regards
> Anindya Roy
>
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ How to set up:payments made and due on a calendar?

2010-11-29 Thread Ed from AZ

In XL2000, I have a calendar set up.  I can set the month and year,
and formulas create the calendar for that month and about the next two
weeks of the next month.  On another sheet, I can list events
(example: client name, date and time of event, activity), and the info
shows up in the calendar on the correct day.  (I forgot who I got this
from, but big mega-thank-yous)

I'd like to set up another calendar for payments made and due.  I can
track this just in a worksheet, but I'd like to see it visually on a
calendar - it would help in plotting other things to see on what day
the money is coming in.

I hope I can describe what I'm thinking well enough for y'all to
understand:
-- Let's say a client has a lesson every week.  Each lesson is $10.
-- In my sheet listing all the client's info, I input that each entry
in the Activities calendar is worth $10.
-- Every time I make an entry for that client on the Activities sheet,
an entry populates on the Payments sheet that this client owes me $10
for this time, and has an outstanding balance of $100.
-- On the Payments calendar, the client's entry shows up.
-- On the Payments sheet, I make an entry for Payment Pending from
this client on some date for $60.
-- On the Payments calendar, an entry shows up for Payment Pending
from this client for $60.
(All that is the easy part.  Now the part that stumps me ...)
-- On the Payments calendar, the first six of the client's entries
beginning from the last date the client was paid up to now show up
formatted italics (or maybe a color), indicating a pending payment to
cover those lessons.
-- On the Payments sheet, I record Payment Received for $100.
-- On the Payments calendar, ten lessons from the last date the client
was paid up to now show up formatted bold (or some other color) to
indicate the lesson was paid for.

The way I see it now, I need to get the dates the client was paid up
to, and the date the next payment will pay up to, and format every
entry for that client between those dates.  I'd prefer to use a
formula, but I can use a macro if necessary.  Maybe a UDF?  The
possible problem is that the visible dates for the calendar are
changeable, so I can't simply start at the top and say "find this
client, starting from this date" - that date might not be visible.

Or maybe I can do the calculations in the Payments sheet - if this
lesson entry is covered by a pending payment, mark "X" in this column;
if covered by a received payment, mark "P".  Add that to the entry for
the lesson, and use conditional formatting: if entry ends in "X",
format italics; if entry ends in "P", format bold.

Is there an easier way that I'm not seeing?  Or a "gotcha" that I'm
not thinking of?

Ed

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ 'Automatic' change to Line Chart from XY Scatter Chart

2010-11-29 Thread Daniel

Hello,

I've been working with (x,y) data which is typically ordered in
groups, but the groups are unordered (e.g. points 50->100 then points
151->101 then points 49->1).  I add the appropriate index (x-value)
and then re-order the data based on that index.  The index is a
distance (in metres) and the points are about 1 metre apart (but not
exactly 1 m).  There are typically 3 or 4 series of data on the graph.

Before I re-order the data, I graph the data with an XY-scatter chart,
which normally works fine.  After I re-order the data based on the
index, my chart magically becomes a line chart instead of the xy
scatter chart.  When I check the chart type (right-click on the series
-> "Chart type") it reports that it is still an xy scatter chart.

I tried changing to a line chart and changing back, but this doesn't
help.  I also tried checking/setting the chart type to xy scatter
using a macro, but that also didn't work.  Sometimes reverting to a
less ordered state of data (cutting-pasting chunks of data around)
will fix it, but not always.

Any ideas what I'm doing wrong/is happening here?  I appreciate any
help.

Thanks,
Daniel

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Selecting specified information from within a cell under a condition and paste that information to a second sheet

2010-11-29 Thread ashish koul

try this

Sub Macro1()
Dim z As Long

   Sheets("Folha1").Activate
 If Sheets("Folha1").FilterMode Then
Sheets("Folha1").ShowAllData
  End If

   Sheets("Folha1").Range("a65356").Select
Selection.End(xlUp).Select
   z = ActiveCell.Row

Sheets("Folha1").Range("$A$6:$J" & z).AutoFilter Field:=10,
Criteria1:="true"
Selection.Copy
Sheets("Folha2").Select
Range("a1").Select
  Sheets("Folha1").AutoFilter.Range.Copy Sheets("Folha2").Range("A1")


If Sheets("Folha1").FilterMode Then
Sheets("Folha1").ShowAllData
  End If

End Sub


On Mon, Nov 29, 2010 at 12:59 AM, Jorge Marques wrote:

> Hi guys i need badly your help,
>
> i want to copy the information of the range of cells from A7:G11 if the
> condition is true, in this case i want it to copy the information of the
> rows 8 and 10 to sheet number 2, thank you very much in advance, i put in
> anex an example of what i need.
>
> Jorge
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$

2010-11-29 Thread roberto mensa

of course is:
=OFFSET($B$1,SMALL(IF(MONTH($D$2:$D$29)=11,ROW($B$2:$B$29)),ROW(A1))-1,)
regards
r


2010/11/29 roberto mensa 

> =OFFSET($B$1,SMALL(IF(MONTH($D$2:$D$29)=3,ROW($B$2:$B$29)),ROW(A1))-1,)
>
> CTRL+SHIFT+ENTER
> drag down
> regards
> r
>
> 2010/11/28 Anindya Roy 
>
>  Suppose I have a file which contains names of the candidates along with
>> their date of birth. Now if i want to sort out names which have birthday
>> falling in the month of november.
>>
>> How do I do that.
>>
>> Please note that DOB is mm/dd/ format.
>>
>>  S.No
>>  Beneficiary Name
>>  Ward No
>>  DOB
>>  1
>>  Ambarish Ghosh
>>  11
>>  12/8/1985
>>  2
>>  Anirban Chakraborty
>>  50
>>  7/13/1991
>>  3
>>  Anasuya Das
>>  21
>>  6/21/1981
>>  4
>>  Ananya Dasgupta
>>  37
>>  8/28/1984
>>  5
>>  Asish Majhi
>>  41
>>  2/11/1990
>>  6
>>  Amit Kumar Sharma
>>  27
>>  2/12/1984
>>  7
>>  Abhijit Golui
>>  37
>>  9/30/1989
>>  8
>>  Bidisha Manik
>>  12
>>  7/19/1985
>>  9
>>  Baishakhi Mallick
>>  9
>>  4/15/1986
>>  10
>>  Biswajit Paul
>>  10
>>  9/18/1984
>>  11
>>  Barnali Roy
>>  19
>>  11/11/1976
>>  12
>>  Dipanjan Karar
>>  18
>>  1/20/1988
>>  13
>>  Jesmine Mondal
>>  39
>>  12/18/1985
>>  14
>>  Kabita Mukherjee
>>  38
>>  8/24/1984
>>  15
>>  Kabita Roy Bagchi
>>  41
>>  8/12/1980
>>  16
>>  Kalpana Dey
>>  48
>>  5/6/1983
>>  17
>>  Kartick Ghosh
>>  48
>>  11/17/1988
>>  18
>>  Kuntal Mukherjee
>>  50
>>  5/5/1982
>>  19
>>  Madhumita Das
>>  39
>>  6/4/1985
>>  20
>>  Madhumita Sardar
>>  39
>>  5/3/1986
>>  21
>>  Moumita Debnath
>>  34
>>  12/23/1988
>>  22
>>  Poly Mukherjee
>>  45
>>  9/16/1988
>>  23
>>  Papia Nath
>>  49
>>  10/21/1979
>>  24
>>  Rituparna Pal
>>  22
>>  12/6/1983
>>  25
>>  Rini Banerjee
>>  33
>>  4/21/1988
>>  26
>>  Shrabani Dey
>>  40
>>  8/5/1975
>>  27
>>  Subhajit Sheet
>>  49
>>  3/10/1991
>>  28
>>  Soma Ghosh
>>  24
>>  12/19/1979
>>
>>
>> Thanks & Regards
>> Anindya Roy
>>
>>
>> --
>>
>> --
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$

2010-11-29 Thread roberto mensa

=OFFSET($B$1,SMALL(IF(MONTH($D$2:$D$29)=3,ROW($B$2:$B$29)),ROW(A1))-1,)

CTRL+SHIFT+ENTER
drag down
regards
r

2010/11/28 Anindya Roy 

> Suppose I have a file which contains names of the candidates along with
> their date of birth. Now if i want to sort out names which have birthday
> falling in the month of november.
>
> How do I do that.
>
> Please note that DOB is mm/dd/ format.
>
>  S.No
>  Beneficiary Name
>  Ward No
>  DOB
>  1
>  Ambarish Ghosh
>  11
>  12/8/1985
>  2
>  Anirban Chakraborty
>  50
>  7/13/1991
>  3
>  Anasuya Das
>  21
>  6/21/1981
>  4
>  Ananya Dasgupta
>  37
>  8/28/1984
>  5
>  Asish Majhi
>  41
>  2/11/1990
>  6
>  Amit Kumar Sharma
>  27
>  2/12/1984
>  7
>  Abhijit Golui
>  37
>  9/30/1989
>  8
>  Bidisha Manik
>  12
>  7/19/1985
>  9
>  Baishakhi Mallick
>  9
>  4/15/1986
>  10
>  Biswajit Paul
>  10
>  9/18/1984
>  11
>  Barnali Roy
>  19
>  11/11/1976
>  12
>  Dipanjan Karar
>  18
>  1/20/1988
>  13
>  Jesmine Mondal
>  39
>  12/18/1985
>  14
>  Kabita Mukherjee
>  38
>  8/24/1984
>  15
>  Kabita Roy Bagchi
>  41
>  8/12/1980
>  16
>  Kalpana Dey
>  48
>  5/6/1983
>  17
>  Kartick Ghosh
>  48
>  11/17/1988
>  18
>  Kuntal Mukherjee
>  50
>  5/5/1982
>  19
>  Madhumita Das
>  39
>  6/4/1985
>  20
>  Madhumita Sardar
>  39
>  5/3/1986
>  21
>  Moumita Debnath
>  34
>  12/23/1988
>  22
>  Poly Mukherjee
>  45
>  9/16/1988
>  23
>  Papia Nath
>  49
>  10/21/1979
>  24
>  Rituparna Pal
>  22
>  12/6/1983
>  25
>  Rini Banerjee
>  33
>  4/21/1988
>  26
>  Shrabani Dey
>  40
>  8/5/1975
>  27
>  Subhajit Sheet
>  49
>  3/10/1991
>  28
>  Soma Ghosh
>  24
>  12/19/1979
>
>
> Thanks & Regards
> Anindya Roy
>
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Guidance needed for intercompany reco...stmt..

2010-11-29 Thread roberto mensa

without a sample sheet with your data is not understood your request
regards
r



2010/11/29 Jagadeesh B S 

> Hello all,
>
> Could someone please help me for my requirement
>
> Thanks in advance
> Jagadeesh B S
>
> On Fri, Nov 26, 2010 at 12:44 PM, Jagadeesh B S  wrote:
>
>> Hello all
>>
>> I need to prepare the reconciliation report for my company  and send it
>> to all the person who is responsible for their a/c.
>>
>> I will be filling the date in the reconsheet only for column E and now I
>> need to send only the a/c and the details for which they are handling.
>>
>> I need formulas to populate the values and a macro to integrate Excel and
>> mailbox so that I can send it to all the people with the data highlighted in
>> the box above.
>>
>> Please guide me to write the formulas for myself.
>>
>>
>>
>> Thanks for looking into it and helping me.
>>
>>
>>
>> Thanks in advance
>>
>> Jagadeesh B S
>>
>> 9963025705
>>
>> --
>>
>> --
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-29 Thread roberto mensa

2010/11/29 Chandra Shekar 

> Hi,
>
> Pls check this site it might help you.
>
> http://www.mrexcel.com/forum/showthread.php?t=20611
>
> Thanks
>
> Chandra Shekar
>

get.cell returns (not set) information about the formatting, location, or
contents of a cell.
A function used in a formula can return a value. It cannot make any changes
to the workbook.
There are some exceptions:

Merge
UnMerge
AddComment
ClearComments
InsertIndent

regards
r

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ issue with Data validation

2010-11-29 Thread anil panchal

Dear All,

Please help me on Data Vadidation :-)


I have issue in multi validation I want in first cell A1 Anil & B1 I want
list of anil like 5 name & second is A2 Sunil & B2 list 4 names.



Thanks & Regards

Anil 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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


issue with validation.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Guidance needed for intercompany reco...stmt..

2010-11-29 Thread Jagadeesh B S

Hello all,

Could someone please help me for my requirement

Thanks in advance
Jagadeesh B S

On Fri, Nov 26, 2010 at 12:44 PM, Jagadeesh B S  wrote:

> Hello all
>
> I need to prepare the reconciliation report for my company  and send it to
> all the person who is responsible for their a/c.
>
> I will be filling the date in the reconsheet only for column E and now I
> need to send only the a/c and the details for which they are handling.
>
> I need formulas to populate the values and a macro to integrate Excel and
> mailbox so that I can send it to all the people with the data highlighted in
> the box above.
>
> Please guide me to write the formulas for myself.
>
>
>
> Thanks for looking into it and helping me.
>
>
>
> Thanks in advance
>
> Jagadeesh B S
>
> 9963025705
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-29 Thread Chandra Shekar

Hi,

Pls check this site it might help you.

http://www.mrexcel.com/forum/showthread.php?t=20611

Thanks

Chandra Shekar

On Mon, Nov 29, 2010 at 4:23 AM, roberto mensa  wrote:

> with UDF you can not:
> look here:
>
> http://spreadsheetpage.com/index.php/oddity/a_user_define_function_cant_change_the_worksheet_oh_yeah/
>
> regards
> r
>
>
>
> 2010/11/28 Rahul Kamal Gandhi 
>
> Guys, Can anyone Help me to Bold the text with the help of Formula
>>
>> Eg.
>>
>> A1 Cell Contains "ABC"
>>
>> I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1)
>>
>> And My output should be *ABC* But in Bold Format
>>
>>
>> Any Formula or Code.  Please Guys I am Struck
>>
>>
>>
>> Regards,
>> Rahul Gandhi
>> +91-9711772297
>>
>> --
>>
>> --
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Salary sending problem

2010-11-29 Thread in . vaibhav

Hi Again,

I can generate in PDF for that u will require to have Office 2007, but password 
protection is not possible at present.

Is it OK.

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Ankit Agrawal 
Date: Mon, 29 Nov 2010 11:42:43 
To: 
Cc: 
Subject: Re: $$Excel-Macros$$ Salary sending problem

Again a recommendation, if it is transfer in to the PDF with password.can it
possible.

Regards,
Ankit

On Mon, Nov 29, 2010 at 11:19 AM, Ankit Agrawal
wrote:

> thank you sir,
>
> Its done dana done.
>
>
> On Sun, Nov 28, 2010 at 11:12 AM,  wrote:
>
>> Dear Ankit,
>>
>> Thanks for your appreciation, Is your query solved. If not then what type
>> of error is occurring.
>>
>> You need to create payslips folder in C drive. And all files are stored in
>> that folder.
>>
>> Pl note folder name is Payslips and not payslip.
>>
>> The location and name of folder can be also changed by editing cell in red
>> colour on sheet Form which contains "C:/payslips".
>>
>> Please revert.
>>
>> Sent on my BlackBerry® from Vodafone
>> --
>> *From: * Ankit Agrawal 
>> *Date: *Sat, 27 Nov 2010 08:37:47 +0530
>> *To: *in.vaib...@googlemail.com
>> *Cc: *
>> *Subject: *Re: $$Excel-Macros$$ Salary sending problem
>>
>> Namste Vaibhav ji,
>>
>> *Unbelievable task. *how I tell you what you are? but sir after clicking
>> it, it add sheet and creating the file as well. but not saving it and
>> occurring a error. so please implement it also.
>>
>> Thanks & Regards
>> Ankit
>> 
>>
>> On Fri, Nov 26, 2010 at 8:37 PM, in.vaib...@googlemail.com <
>> in.vaib...@gmail.com> wrote:
>>
>>> Dear Ankit,
>>>
>>> Check the attached file. It meets all requirements.
>>>
>>> Create folders name "payslip" in C:
>>>
>>> //BR
>>>
>>> VaibhavJ
>>>
>>> Life is cool...
>>>
>>>
>>> On Thu, Nov 25, 2010 at 11:05 PM,  wrote:
>>>
 Dear Ankit,

 I have made one macro this will send payslip as in-line to email.

 Follow the instruction sheet. If format and everything is OK then I will
 work for your other requirement.

 Pl note that I will able to generate password protected XLS file.

 Please revert for help.

 Sent on my BlackBerry® from Vodafone
 --
 *From: * Ankit Agrawal 
 *Sender: * excel-macros@googlegroups.com
 *Date: *Tue, 16 Nov 2010 18:53:55 +0530
 *To: *
 *ReplyTo: * excel-macros@googlegroups.com
 *Subject: *$$Excel-Macros$$ Salary sending problem

 Hello Sir,

 I have a problem related to mail through excel. basically I have to make
 salary slip. and forward it to the employees. I manage the data into the
 excel and use mail merge in MS word. now the problem is, I have to make
 separate file for each employee and have to send one by one on their e-mail
 id.

 Question

 1- Is any way that we can make separately file automatically and send to
 it mail automatically to each employee.
 2- is any way that every file having its own password and its password
 would be employee DOB or their PAN may be any other key

 Here  I am sending you sample file so please illustrate it because I am
 new in the excel and don't know much more about other computer software &
 tools


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

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

>>>
>>>
>>
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Fwd: Help required for formule

$$Excel-Macros$$ Fwd: Help required for formule

$$Excel-Macros$$ Re: issue with Data validation

$$Excel-Macros$$ Re: headcout dashboard report

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

Re: $$Excel-Macros$$ help required

Re: $$Excel-Macros$$ help required

$$Excel-Macros$$ help required

Re: $$Excel-Macros$$ Selecting specified information from within a cell under a condition and paste that information to a second sheet

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

$$Excel-Macros$$ headcout dashboard report

Re: $$Excel-Macros$$

$$Excel-Macros$$ How to set up:payments made and due on a calendar?

$$Excel-Macros$$ 'Automatic' change to Line Chart from XY Scatter Chart

Re: $$Excel-Macros$$ Selecting specified information from within a cell under a condition and paste that information to a second sheet

Re: $$Excel-Macros$$

Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Guidance needed for intercompany reco...stmt..

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

$$Excel-Macros$$ issue with Data validation

Re: $$Excel-Macros$$ Guidance needed for intercompany reco...stmt..

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

Re: $$Excel-Macros$$ Salary sending problem

23 matches

Site Navigation

Mail list logo

Footer information