date:20101128

Re: $$Excel-Macros$$ Integrating Outlook with Excel

2010-11-28 Thread Yogesh Kudva

Hi,

Thanks for your prompt response.

I am using Office 2007.

My requirement is to first create a rule that will sort the mails depending
on the deadlines. Secondly create a list of mails received.

Thanks & Regards,

Yogesh Kudva

On Sun, Nov 28, 2010 at 11:59 AM,  wrote:

> Dear Yogesh,
>
> Pl state your requirement in terms if action to be performed on receipt of
> email.
>
> Also mention which version of Excel you are using.
>
> Sent on my BlackBerry® from Vodafone
>
> -Original Message-
> From: Yogesh Kudva 
> Sender: excel-macros@googlegroups.com
> Date: Sat, 27 Nov 2010 21:14:31
> To: MS EXCEL AND VBA MACROS
> Reply-To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Integrating Outlook with Excel
>
> Hello Group,
>
> My office email account is configured in Outlook 2007. Along with that
> I also have a Mailbox configured with my Primary account. We get mails
> from our clients on which we need to action and there are different
> deadlines (Deadline 1 to 4). The subject of the mails which we receive
> are not uniform. Some mention the Account #, some mention the Name,
> whereas some of them mention a different #. Secondly there are some
> mails which we receive for deadline 2 or 3 early in the morning
> itself.
>
> I tried to create rules but they don’t seem to work on the mailbox. I
> found a macro which creates  a list of mails received in Excel but
> that too works only for the mails of the Primary Inbox and not of the
> Mailbox Inbox.
>
> Could anyone of you help me with the same?
>
> Thanking you in anticipation.
>
> Yours truly,
>
> Yogesh Kudva
>
> --
>
> --
> 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$$ URGENTHelp Required

2010-11-28 Thread girish kumar

Dear Ashish / Experts

Its wonderfull, its solved what i need.

But i need VBA code for this because i need to send this file to my higher
officials if formulas are there it wont be look good.

and for drop box (Column XFD) u put only those destinations which are in
Master sheet, if i need to add more destination what i have to do.

Thanx in Advance.

Regards

Girish

On Sat, Nov 27, 2010 at 7:14 PM, ashish koul  wrote:

>
> check the attachment see if it helps .
>
> On Sat, Nov 27, 2010 at 6:46 PM, girish kumar  > wrote:
>
>>  Dear Experts,

>>>
>> I need your help to sort this problem
>>
>> i have attached one file, i have mentioned my problem in file itself.
>>
>> thanks in advance
>>
>> regards
>>
>> Girish
>>
>>
>>
>>
>>
>>> --
 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
>>
>
>
>
> --
> *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
>



-- 
Warm Regards,

*Girish Sherigar*

* (¨`·.·´¨) *
*`·.¸(¨`·.·´¨)* *Keep*
* (¨`·.·´¨)¸.·´ Smiling!*
* `·.¸.·´*

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

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

2010-11-28 Thread Ankit Agrawal

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$$ Salary sending problem

2010-11-28 Thread Ankit Agrawal

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

2010-11-28 Thread dkumar9...@gmail.com

Hi ashish, is sumif is ok for you ?? If you still not fond the solution you can 
first make pivot and use lookup.

Thanxs & Regards,
Dheeraj S Chauhan

*All things are difficult before they are easy*

Sent from my Nokia phone
-Original Message-
From: ashish koul
Sent:  28/11/2010 17:17:23
Subject:  Re: $$Excel-Macros$$ Queries

use sumif  check the attachment see if it helps

On Sun, Nov 28, 2010 at 2:06 PM, neil johnson wrote:

> Hi Everyone.
>
> I have large data in excel. for example in sheet 1. and we have name in
> sheet 2 . I use vlookup function and fetch the production using vlookup .
> now when i saw the total there is difference between two . When i see in the
> sheet 1 . there is duplicate name as well as value is difference. can some
> one explain how can we fetch the data by using small function + vlookup
> function + offset function. of second value of harmeet. So total may be
> similar.
>
> I have no complete idea about that .
>
>
> 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
>



-- 
*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-28 Thread roberto mensa

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

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

2010-11-28 Thread Jorge Marques

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


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

$$Excel-Macros$$

2010-11-28 Thread 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

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

2010-11-28 Thread Simran Singh

Hi Rahul,

You can do this with the help of replace option.

Ist open the replace option by pressing ctrl + H.

2nd on "Find What" option write abc or any text you want to bold.

3rd on "Replace With" write abc or any text you want to bold.

4th on the right hand side of the "Replace with" option you will find
"Format" option. From here you can chose any kind of format you want to
replace with.

5th after selection the type of format, press the "Replace All" button.

Hope this will sort your problem

Thanks
Simran

On Sun, Nov 28, 2010 at 7:56 PM, 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 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$$ select the specified sheet

2010-11-28 Thread Rajesh K R

Hi Ashish
what i exactly want is that for attendance record i using an excel
file which 12 pages for entry and 1 page for printing purpose. in the
sheet for printing i create a macro , its working well but every month
i have to change the selected sheet name January, February etc.
instead of this if the macro is able to understand which sheet i have
to copy & extract required data it shall be very helpful.
 Sheets("January").select
  Selection.copy

I need the code to write before this.

Regards & Thanks
Rajesh Kainikkara

On 11/28/10, ashish koul  wrote:
> try this see if it helps
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Row = 1 And Target.Column = 1 Then
> On Error Resume Next
> Sheets(Range("a1").Text).Activate
> End If
>
> End Sub
>
>
>
> On Sun, Nov 28, 2010 at 5:32 PM, Rajesh K R
> wrote:
>
>> Hi experts
>>
>> How can i select a sheet from file having many sheets just type the
>> sheet name in cell A1 in
>> sheet1.
>>
>> Thanks in advance
>> Rajesh Kainikkara
>>
>> --
>>
>> --
>> 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

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

2010-11-28 Thread Dilip Pandey

I think same post is replicated here. Duplicate posting :)

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

-- 
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$$ Bold a Text with Help Of Formula

2010-11-28 Thread Dilip Pandey

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

-- 
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$$ two database in one file which can open with two password

2010-11-28 Thread Dilip Pandey

Hi,

Anyone can press Alt+F11 to go to visual basic editor but if the vba
project is password protected then they wld not be able to see the
code.

Your way is also good.

Best Regards,
DILIPandey

On 11/27/10, Rajesh K R  wrote:
> Hi Dilip
> i tried your code its working well, but if anybody press ALT + F 8 any
> body get some macro code is there i solved it in this way is there any
> better way for this
> Sub unhidesheet()
> If Application.InputBox("ENTER PASSWORD") = "123" Then
> Sheet1.Visible = xlSheetVisible
> Else
> Sheets("hide").Visible = True
> End If
> End Sub
>
> Regards
> Rajesh Kainikkara
>
> On 11/25/10, Dilip Pandey  wrote:
>> Hi Rajesh,
>>
>> You can use following code:-
>>
>> Sheet1.Visible = xlSheetVeryHidden
>> Or
>> Sheets("Sales").Visible = xlSheetVeryHidden
>>
>> Now, you can not see it using Format->Sheet-> unhide
>> To get it, use following code
>>
>> Sheet1.Visible = True
>>
>> Further to this, you can protect your VBA code as well, so that no one
>> can edit the code to unhide the sheets.
>>
>>
>> Best Regards,
>> DILIPandey
>>
>>
>> On 11/24/10, Rajesh K R  wrote:
>>> what i need is that i have many files in my computer each having a
>>> many worksheets
>>> among this many of the sheets contain datas which is not allowed
>>> others to access
>>> if i am simply hide a sheet or range they will understand that some
>>> sheets or data is hided here .i want to over come this. normaly nobody
>>> should not find some data is protected viewing in tools menu.
>>>
>>> Regards&Thanks
>>> Rajesh kainikkara
>>>
>>> On 11/23/10, Dilip Pandey  wrote:
 Hi Rajesh,

 If you are talking in terms of Excel, then use the following path:-
 Tools -> Protection->Allow users to Edit Ranges

 In this you can have different passwords for different ranges.
 Additionally you can also show or hide sheets and protect and
 un-protect them using passwords.  Workbook passwords or Macros can be
 used to achieve this.

 Feel free to get back in case you need further help.

 Best Regards,
 DILIPandey



 On 11/22/10, Rajesh K R  wrote:
> Hi Experts
> is it possible to make file which having hided and unguided sheets and
> open them using different passwords.
> Regards
> Rajesh kainikkara
>
> --
> --
> 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
>


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

>>>
>>> --
>>> --
>>> 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
>>>
>>
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY
>>   MBA-HR,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>

Re: $$Excel-Macros$$ select the specified sheet

2010-11-28 Thread ashish koul

try this see if it helps

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 And Target.Column = 1 Then
On Error Resume Next
Sheets(Range("a1").Text).Activate
End If

End Sub



On Sun, Nov 28, 2010 at 5:32 PM, Rajesh K R wrote:

> Hi experts
>
> How can i select a sheet from file having many sheets just type the
> sheet name in cell A1 in
> sheet1.
>
> Thanks in advance
> Rajesh Kainikkara
>
> --
>
> --
> 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

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

2010-11-28 Thread 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

$$Excel-Macros$$ select the specified sheet

2010-11-28 Thread Rajesh K R

Hi experts

How can i select a sheet from file having many sheets just type the
sheet name in cell A1 in
sheet1.

Thanks in advance
Rajesh Kainikkara

-- 
--
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$$ Again Doubt in project

2010-11-28 Thread ashish koul

 try this macro

Sub delete()

Dim FoundCell As Range

Dim myRng As Range
Dim sh As Worksheet



Set sh = Sheets("Dump")

Set myRng = sh.Range("A:A")


Set FoundCell =
myRng.Find(What:=Sheets("main").Range("b16").Value, After:=Range("a1"), _
LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False)

If FoundCell Is Nothing Then
Exit Sub
Else
FoundCell.EntireRow.delete
End If



End Sub

On Sun, Nov 28, 2010 at 3:47 PM, SAJID MEMON  wrote:

>  dear Dilip & ashish koul
>
> Sheets("Dump").Range("a1:D65356").Clear
>
> If i do the above line in attached project then entire data will be
> deleted.
>
>
> My doubt is only pink color data display should be deleted from dump sheet.(I 
> have attached file again to try to understanding you my doubt )
>
> With awaiting your reply
>
> Sajid Memon
> +91 94376 38986. (Orissa, 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
>



-- 
*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$$ Queries

2010-11-28 Thread ashish koul

use sumif  check the attachment see if it helps

On Sun, Nov 28, 2010 at 2:06 PM, neil johnson wrote:

> Hi Everyone.
>
> I have large data in excel. for example in sheet 1. and we have name in
> sheet 2 . I use vlookup function and fetch the production using vlookup .
> now when i saw the total there is difference between two . When i see in the
> sheet 1 . there is duplicate name as well as value is difference. can some
> one explain how can we fetch the data by using small function + vlookup
> function + offset function. of second value of harmeet. So total may be
> similar.
>
> I have no complete idea about that .
>
>
> 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
>



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


Book1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Again Doubt

2010-11-28 Thread SAJID MEMON


dear Dilip & ashish koul
 
Sheets("Dump").Range("a1:D65356").Clear
 
If i do the above line in attached project then entire data will be deleted.
 
 
My doubt is only pink color data display should be deleted from dump sheet. (I 
have attached file again to try to understanding you my doubt )
 
With awaiting your reply
 
Sajid Memon
+91 94376 38986. (Orissa, 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

$$Excel-Macros$$ Queries

2010-11-28 Thread neil johnson

Hi Everyone.

I have large data in excel. for example in sheet 1. and we have name in
sheet 2 . I use vlookup function and fetch the production using vlookup .
now when i saw the total there is difference between two . When i see in the
sheet 1 . there is duplicate name as well as value is difference. can some
one explain how can we fetch the data by using small function + vlookup
function + offset function. of second value of harmeet. So total may be
similar.

I have no complete idea about that .


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


Book1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Integrating Outlook with Excel

2010-11-28 Thread in . vaibhav

Dear Yogesh,

Pl state your requirement in terms if action to be performed on receipt of 
email.

Also mention which version of Excel you are using.

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Yogesh Kudva 
Sender: excel-macros@googlegroups.com
Date: Sat, 27 Nov 2010 21:14:31 
To: MS EXCEL AND VBA MACROS
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Integrating Outlook with Excel

Hello Group,

My office email account is configured in Outlook 2007. Along with that
I also have a Mailbox configured with my Primary account. We get mails
from our clients on which we need to action and there are different
deadlines (Deadline 1 to 4). The subject of the mails which we receive
are not uniform. Some mention the Account #, some mention the Name,
whereas some of them mention a different #. Secondly there are some
mails which we receive for deadline 2 or 3 early in the morning
itself.

I tried to create rules but they don’t seem to work on the mailbox. I
found a macro which creates  a list of mails received in Excel but
that too works only for the mails of the Primary Inbox and not of the
Mailbox Inbox.

Could anyone of you help me with the same?

Thanking you in anticipation.

Yours truly,

Yogesh Kudva

-- 
--
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-28 Thread in . vaibhav

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

-Original Message-
From: Ankit Agrawal 
Date: Sat, 27 Nov 2010 08:37:47 
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$$ Integrating Outlook with Excel

Re: $$Excel-Macros$$ URGENTHelp Required

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

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

RE: $$Excel-Macros$$ Queries

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

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

$$Excel-Macros$$

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

Re: $$Excel-Macros$$ select the specified sheet

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

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

Re: $$Excel-Macros$$ two database in one file which can open with two password

Re: $$Excel-Macros$$ select the specified sheet

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

$$Excel-Macros$$ select the specified sheet

Re: $$Excel-Macros$$ Again Doubt in project

Re: $$Excel-Macros$$ Queries

$$Excel-Macros$$ Again Doubt

$$Excel-Macros$$ Queries

Re: $$Excel-Macros$$ Integrating Outlook with Excel

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

22 matches

Site Navigation

Mail list logo

Footer information