$$Excel-Macros$$ Hide a single work sheet with password

[Kumar Punnam]

Dear Friends,


I am having important information in Sheet2 which wa named  as "Fuel Item"
along with Sheet1 "Fuel Summary", i would like to hide the sheet2 and
protect it with password so that no one can access it at all,

i need a VBA Code or any suggestion


Thanking You,


With Regards,
P.V. Ravi Kumar,
Asst, Engg,
GKC Projects Ltd.

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

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

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

$$Excel-Macros$$ Colour pallette changed when sheet imported.

[tomfabtas...@hotmail.com]

Hi,

I copied a sheet from one excel file to another (right clicking on
sheet name and ticking "Copy" box). The effect was to change the
colour pallette in the destination sheet to be the same as the colour
pallette in the original sheet. How can I get the old colour pallette
back ?

I tried copying in a sheet that had the colour pallette I wanted, but
this didn't work.

Regards,
Tom

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

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

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

$$Excel-Macros$$ Re: Help with Date

[Kishan Reddy, K]

Dear Hari Nair,

If the values in quality column are unique then copy and paste the
following formula in column G2

=VLOOKUP(E2,RATE!$C$2:$D$8,2,FALSE)

for best performance sort the Rate sheet on quality column.

Kishan Reddy, K.

On Jul 22, 4:20 pm, HARI NAIR  wrote:
> Dear Friends,
>
> I want rate automatically comes  from rate sheet in Data sheet when I enter
> the remaining details in the attached file, please help, Thanks in advance
>
> Regards,
>
> Hari
>
>  PR.xls
> 18KViewDownload

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

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

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

$$Excel-Macros$$ VBA PIVOT Help

[Rajesh Nair]

Hi All,

Can i get some VBA Pivot examples ?

Regartds,
Rajesh. NAir

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

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

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

Fwd: $$Excel-Macros$$ Auto Calculate Number to Percent

[Hari Lal C]

HLC


-- Forwarded message --
From: MNM 
Date: Fri, Jul 23, 2010 at 7:12 AM
Subject: $$Excel-Macros$$ Auto Calculate Number to Percent
To: MS EXCEL AND VBA MACROS 


Hi,

I am trying to figure out if there is a way to auto calculate number
entered into a column to total percent. Example

Column A contains 'Date'
Column B contains 'User'
Column C contains 'Hours worked'

Based on the value in column B User 'XYZ' I should be able to convert
hours worked into total percent

Date | User | Hours Worked
7/16 | ABC | 8

This should self calculate and return on save
7/16 | ABC | 100%

Example 2

Date | User | Hours Worked
7/16 | ABC | 8
7/16 | ABC | 8
7/16 | XYZ | 12
7/17 | ABC | 8

This should self calculate and return on save
7/16 | ABC | 33.3%
7/16 | ABC | 33.3%
7/16 | XYZ | 100%
7/17 | ABC | 33.3%

At the end the total should equal 100% by User

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

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

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

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

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

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

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

RE: $$Excel-Macros$$ Auto Calculate Number to Percent

[Dave Bonallack]

Hi

This can't be done with worksheet functions without the use of another column, 
because of circular referencing.

However, it can be done with macros, either automatically, or by button click.

So, which would you prefer: Worksheet functions with extra column, or VBA?

Regards - Dave.
 
> Date: Thu, 22 Jul 2010 18:42:53 -0700
> Subject: $$Excel-Macros$$ Auto Calculate Number to Percent
> From: mnaf...@gmail.com
> To: excel-macros@googlegroups.com
> 
> Hi,
> 
> I am trying to figure out if there is a way to auto calculate number
> entered into a column to total percent. Example
> 
> Column A contains 'Date'
> Column B contains 'User'
> Column C contains 'Hours worked'
> 
> Based on the value in column B User 'XYZ' I should be able to convert
> hours worked into total percent
> 
> Date | User | Hours Worked
> 7/16 | ABC | 8
> 
> This should self calculate and return on save
> 7/16 | ABC | 100%
> 
> Example 2
> 
> Date | User | Hours Worked
> 7/16 | ABC | 8
> 7/16 | ABC | 8
> 7/16 | XYZ | 12
> 7/17 | ABC | 8
> 
> This should self calculate and return on save
> 7/16 | ABC | 33.3%
> 7/16 | ABC | 33.3%
> 7/16 | XYZ | 100%
> 7/17 | ABC | 33.3%
> 
> At the end the total should equal 100% by User
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 7000 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
  
_
Need a new place to live? Find it on Domain.com.au
http://clk.atdmt.com/NMN/go/157631292/direct/01/

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

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

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

$$Excel-Macros$$ Re: Auto Calculate Number to Percent

[saggi]

I Don't think its possible by Self Calculating atleast u have to put
some criteria here

just add another column "D" for %age calculation

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

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

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

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

[Vijay Aggarwal]

Hi Mahesh,

Convertword formula is working in your file only. If I open a new file it
doesn't work.

Please let me know what should I do?

regards,
Vijay Kumar Aggarwal
048542

On Wed, Jul 21, 2010 at 11:57 AM, Mahesh parab  wrote:

> Hi
>
> find attach sheet to convert amount into word.
>
> On Fri, Jul 16, 2010 at 11:48 AM, preeti vora wrote:
>
>>HI IS THAT ANY FORMULA WHEN WE WRIGHT NUMERICAL AMOUNT AND WANT TO
>> CONVERT IN WORD. ANY BODY KNOW FORMULA ???
>>
>> E.G = 25  ( TWENTY FIVE)
>> On Thu, Jul 15, 2010 at 12:48 PM, Kishanreddy Kethireddy <
>> kishanreddy.kethire...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> You can use iserror() function to find out any errors.
>>>
>>> You can use If() function to replace error values to zeroes.
>>>
>>> use the following formula in adjucent column/row of the actual values
>>> that you want to sum
>>>
>>> eg. you want total the values in column C, then use this formula in
>>> column D
>>>
>>> =IF(ISERROR(C3),0,C3)
>>>
>>> then use the SUM function on column D.
>>>
>>> Still have a problem, mail me at kishanreddy.kethire...@gmail.com
>>>
>>> Bye.
>>>
>>> KIshan Reddy.
>>>
>>>
>>>  On Thu, Jul 15, 2010 at 11:27 AM, preeti vora 
>>> wrote:
>>>

 Hi

 is that any formula when we do sum formula but some time in our data
 #N/A in list that's WY we not able to see sum total.
 pls find the below mention example.if anybody know pls tell me formula.

 *Total* 20 25 #N/A 20 51 10 *#N/A=sum()


 *
 On Tue, Jul 13, 2010 at 11:48 PM, Harmeet Singh <
 harmeet.hew...@gmail.com> wrote:

> may b attached tool will help you...
> Warm Regards,
>
> Harmeet Singh
> IT Analyst
> McKinsey & Company
> http://www.facebook.com/Harmeeet
>
>
>
> On Tue, Jul 13, 2010 at 10:21 PM, Anish Shrivastava <
> anish@gmail.com> wrote:
>
>> PLease help me on this.
>>
>>
>> On 7/13/10, Anish Shrivastava  wrote:
>>>
>>> Hello Experts,
>>>
>>> Yesterday, while using Google Translator manually I just thought if
>>> it
>>> can be automated using VBA. Actually what my task includes is to
>>> Convert various European language values to Standard English lang.
>>>
>>> I have values in a single Column (No fixed number of rows/values but
>>> it will be in a single column). What I do is, I separate all the
>>> European titles in different files according to their language and
>>> then upload it to google translator as a file. Then Select the
>>> language and click on go. It gives us the result on the next page.
>>>
>>> Now I just wanted to know, if VBA can do the following job for us.
>>> 1. Copies the values from those column.
>>> 2. Pastes it into a new file.
>>> 3. Saves it, Closes it.
>>> 4. Opens Internet Explorer with Google Translator.
>>>
>>> (I am able to do till here, next points are bit tricky for me or
>>> perhaps I dont know them yet).
>>>
>>> 5. Uploads the document we saved.
>>> 6. Selects the languages (Any european language to ENGLISH).
>>> 7. Runs the translator.
>>> 8. Copies the resulted values.
>>> 9. Pastes it back to excel file as values (Perhaps, it takes less
>>> time
>>> to be pasted as values rather than the format we copy from websites.)
>>>
>>> Again I can take it further from here like putting them in the
>>> adjacent cells to original values and saving it, Closing it.
>>>
>>> I would appreciate it very much if you experts help me in this. It
>>> will save lots of my time and effort in performing my current task
>>> and
>>> above to that I would be very happy if I learn the problems from
>>> Point
>>> # 5 to 9.
>>>
>>> Thanks again for helping me in all my previous queries.
>>>
>>> Regards-
>>> ANISh
>>>
>>> --
>>>
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @
>>> http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 7000 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>> --
>>
>> --

Re: $$Excel-Macros$$ Auto Calculate Number to Percent

[Sandeep Kumar Maurya]

Hi,

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

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

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


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

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


Thanks & Regards
Sandeep



On Fri, Jul 23, 2010 at 7:12 AM, MNM  wrote:
> Hi,
>
> I am trying to figure out if there is a way to auto calculate number
> entered into a column to total percent. Example
>
> Column A contains 'Date'
> Column B contains 'User'
> Column C contains 'Hours worked'
>
> Based on the value in column B User 'XYZ' I should be able to convert
> hours worked into total percent
>
> Date | User | Hours Worked
> 7/16 | ABC | 8
>
> This should self calculate and return on save
> 7/16 | ABC | 100%
>
> Example 2
>
> Date | User | Hours Worked
> 7/16 | ABC | 8
> 7/16 | ABC | 8
> 7/16 | XYZ | 12
> 7/17 | ABC | 8
>
> This should self calculate and return on save
> 7/16 | ABC | 33.3%
> 7/16 | ABC | 33.3%
> 7/16 | XYZ | 100%
> 7/17 | ABC | 33.3%
>
> At the end the total should equal 100% by User
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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


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

$$Excel-Macros$$ Auto Calculate Number to Percent

[MNM]

Hi,

I am trying to figure out if there is a way to auto calculate number
entered into a column to total percent. Example

Column A contains 'Date'
Column B contains 'User'
Column C contains 'Hours worked'

Based on the value in column B User 'XYZ' I should be able to convert
hours worked into total percent

Date | User | Hours Worked
7/16 | ABC | 8

This should self calculate and return on save
7/16 | ABC | 100%

Example 2

Date | User | Hours Worked
7/16 | ABC | 8
7/16 | ABC | 8
7/16 | XYZ | 12
7/17 | ABC | 8

This should self calculate and return on save
7/16 | ABC | 33.3%
7/16 | ABC | 33.3%
7/16 | XYZ | 100%
7/17 | ABC | 33.3%

At the end the total should equal 100% by User

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

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

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

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

[Edgar]

Thanks, everyone.  What a JV mistake. :)

On Jul 21, 9:24 pm, "Soni.Rajender"  wrote:
> Hi
>
> You can use the formulaes as below:
>
> = FIND(" ",A1,1)                          or
> =SEARCH(" ",A1,1)
>
> Regards
> Rajender Soni ! 750 322 55 50
>
> On Jul 22, 2:48 am, Edgar  wrote:
>
>
>
> > I'm trying to clean up some data. I've used SEARCH and FIND to try to
> > identify the first space within a cell, but the answer comes back
> > incorrect.
>
> > I've used SEARCH("", Cell Reference)
>
> > It's giving me the first cell. For example, the answer to this would
> > be 1.
>
> > If I used SEARCH("", Cell reference, 20), it would show 20.
>
> > Any help, pls?- Hide quoted text -
>
> - Show quoted text -

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

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

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

RE: $$Excel-Macros$$ Inserting a Vertical Line

[Dave Bonallack]

Hi,

When I tried it in XL2003, the macro recorder gave:

 

ActiveSheet.Shapes.AddLine(431.25, 188.25, 678#, 423.75).Select

 

Try pasting that into xl2007 and see what you get.

Regards - Dave.

 

 

 


 
> Date: Thu, 22 Jul 2010 09:07:29 -0700
> Subject: $$Excel-Macros$$ Inserting a Vertical Line
> From: steve.slec...@gmail.com
> To: excel-macros@googlegroups.com
> 
> I've been trying to use the macro recorder to capture the code on
> inserting a vertical line from the Insert-->Shapes part of the menu in
> Excel 2007. For some reason it appears that the recorder does not
> capture drawing tools.
> 
> I want to be able to place a line through VB and control the length,
> width, location, angle, etc.
> 
> Does anyone have any code snippets on doing this?
> 
> Thank You.
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 7000 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
  
_
Browse profiles for FREE! Meet local singles online.
http://clk.atdmt.com/NMN/go/150855801/direct/01/

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

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

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

$$Excel-Macros$$ Excel 2007 Information Rights Management + macro

[Blazito J]

Hello
I have a xlsm (macro-enabled spreadsheet) file with IRM using free
Microsoft's authentication services (windows live based) to protect
the file from being redistributed without my knowledge and consent.
The IRM itself has been working flawlessly so far.
However, I have not managed to successfully enable macros in such a
file. I am not sure, if it is even possible to have both these Excel
features working together. Is there something I am missing? All your
help will be appreciated.
Thanks in advance

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

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

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

$$Excel-Macros$$ Re: Help with Date

[George]

 Hi HARI,

Please look at that:
http://marchello.ccx-grads.org/files/PR.xls
All you need is key of your fields (dot-separated) and VLOOKUP
standart function.
You can press "F9" if your seetings do not allow automatic
calculation.
Enjoy!


On 22 Лип, 14:20, HARI NAIR  wrote:
> Dear Friends,
>
> I want rate automatically comes  from rate sheet in Data sheet when I enter
> the remaining details in the attached file, please help, Thanks in advance
>
> Regards,
>
> Hari
>
>  PR.xls
> 18KДивитисьЗавантажити

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

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

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

$$Excel-Macros$$ Inserting a Vertical Line

[SteveS]

I've been trying to use the macro recorder to capture the code on
inserting a vertical line from the Insert-->Shapes part of the menu in
Excel 2007. For some reason it appears that the recorder does not
capture drawing tools.

I want to be able to place a line through VB and control the length,
width, location, angle, etc.

Does anyone have any code snippets on doing this?

Thank You.

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

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

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

Re: $$Excel-Macros$$ Preventing unauthorized access for your excel files

[Rajesh Srinivasaraghavan]

Thanks Dave. I will try this!

Regards
Rajesh

On Thu, Jul 22, 2010 at 6:37 PM, Dave Bonallack
wrote:

> Hi,
> Create a new sheet. On that, in large font, enter "Macros must be enabled
> to use this workbook."
> Create a workbook close event macro that makes all sheets xlveryhidden
> except the new sheet.
> Create a workbook open event macro that hides the new sheet and unhides all
> the others.
> If the macros are disabled on open, the open workbook macro wont run, the
> notice sheet will be displayed, and all others will be hidden.
> (Sheets that are xlveryhidden can only be opened by vba)
> Regards - Dave.
>
> --
> Date: Thu, 22 Jul 2010 15:29:46 +0530
> Subject: $$Excel-Macros$$ Preventing unauthorized access for your excel
> files
> From: taur...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Hi Group,
> I need help in preventing unauthorized users from accessing my excel work
> book(s). Right now i have written the following vba code to achieve my
> objective. However, if some one were to choose to click 'Disable Macros',
> they can still access the contents of my file.
>
> Sub auto_open()
>
> UserN = Application.UserName
>
> Select Case (UserN)
> ...
> ...*Show contents if UserN is a authorized user else, close the work book*
> ...
>
> I am looking for means to close the file the moment an unauthorized person
> tries to access my file(s). Can some one help?
>
> Regards
> Rajesh
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
> Find it on Domain.com.au  Need a new place to 
> live?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

Re: $$Excel-Macros$$ RE: Need macro for attd workbook

[sudhir kumar]

in addition of this macro,there is one more thing , if i want to edit one of
my cell, and want to allow multiple secletion, then how it could be done,
plz tell

On Thu, Jul 22, 2010 at 8:00 PM, sudhir kumar  wrote:

> Dear  Dave Bonallack sir  thanks for sharing this important macro
>
>
>
>
>
> On Thu, Jul 22, 2010 at 6:29 PM, Dave Bonallack  > wrote:
>
>>  You're welcome.
>> Dave.
>>
>> > From: vidyutm...@gmail.com
>> > Date: Thu, 22 Jul 2010 17:42:58 +0530
>> > Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook
>>
>> > To: excel-macros@googlegroups.com
>> >
>> > Thank you so much sir "Dave Bonallack". Its what i was looking for.
>> Thanks again
>> >
>> > On Thu, Jul 22, 2010 at 5:37 PM, Dave Bonallack
>> >  wrote:
>> > > Hi,
>> > > Have a look at the attached.
>> > > The macro prevents the selection of multiple cells.
>> > > If the selected cell contains data, it will be locked.
>> > > If the selected cell is blank, it will be unlocked.
>> > > Once a blank cell is edited, it will be locked automatically.
>> > > The protection is not password protected. You can add that if you
>> need.
>> > >
>> > > Regards - Dave.
>> > >
>> > >
>> > >> From: vidyutm...@gmail.com
>> > >> Date: Thu, 22 Jul 2010 12:09:43 +0530
>> > >> Subject: $$Excel-Macros$$ Need macro for attd workbook
>> > >> To: excel-macros@googlegroups.com
>> > >>
>> > >> Hi respected members.
>> > >>
>> > >> i want ur help in macro. i v attd sample workbook, in that i want
>> > >> macro that can protect rows which is not empty and unprotect empty
>> > >> rows
>> > >>
>> > >> --
>> > >>
>> > >>
>> --
>> > >> Some important links for excel users:
>> > >> 1. Follow us on TWITTER for tips tricks and links :
>> > >> http://twitter.com/exceldailytip
>> > >> 2. Join our LinkedIN group @
>> http://www.linkedin.com/groups?gid=1871310
>> > >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> > >>
>> > >> To post to this group, send email to excel-macros@googlegroups.com
>> > >>
>> > >> <><><><><><><><><><><><><><><><><><><><><><>
>> > >> HELP US GROW !!
>> > >>
>> > >> We reach over 7000 subscribers worldwide and receive many nice notes
>> about
>> > >> the learning and support from the group.Let friends and co-workers
>> know they
>> > >> can subscribe to group at
>> > >> http://groups.google.com/group/excel-macros/subscribe
>> > >
>> > > 
>> > > Find it on Domain.com.au Need a new place to live?
>> > >
>> > > --
>> > >
>> --
>> > > Some important links for excel users:
>> > > 1. Follow us on TWITTER for tips tricks and links :
>> > > http://twitter.com/exceldailytip
>> > > 2. Join our LinkedIN group @
>> http://www.linkedin.com/groups?gid=1871310
>> > > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> > >
>> > > To post to this group, send email to excel-macros@googlegroups.com
>> > >
>> > > <><><><><><><><><><><><><><><><><><><><><><>
>> > > HELP US GROW !!
>> > >
>> > > We reach over 7000 subscribers worldwide and receive many nice notes
>> about
>> > > the learning and support from the group.Let friends and co-workers
>> know they
>> > > can subscribe to group at
>> > > http://groups.google.com/group/excel-macros/subscribe
>> > >
>> >
>> > --
>> >
>> --
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >
>> > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > HELP US GROW !!
>> >
>> > We reach over 7000 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>> --
>> Find it at CarPoint.com.au New, Used, Demo, Dealer or 
>> Private?
>>
>> --
>>
>> --
>> 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?gi

Re: $$Excel-Macros$$ RE: Need macro for attd workbook

[sudhir kumar]

Dear  Dave Bonallack sir  thanks for sharing this important macro




On Thu, Jul 22, 2010 at 6:29 PM, Dave Bonallack
wrote:

>  You're welcome.
> Dave.
>
> > From: vidyutm...@gmail.com
> > Date: Thu, 22 Jul 2010 17:42:58 +0530
> > Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook
>
> > To: excel-macros@googlegroups.com
> >
> > Thank you so much sir "Dave Bonallack". Its what i was looking for.
> Thanks again
> >
> > On Thu, Jul 22, 2010 at 5:37 PM, Dave Bonallack
> >  wrote:
> > > Hi,
> > > Have a look at the attached.
> > > The macro prevents the selection of multiple cells.
> > > If the selected cell contains data, it will be locked.
> > > If the selected cell is blank, it will be unlocked.
> > > Once a blank cell is edited, it will be locked automatically.
> > > The protection is not password protected. You can add that if you need.
> > >
> > > Regards - Dave.
> > >
> > >
> > >> From: vidyutm...@gmail.com
> > >> Date: Thu, 22 Jul 2010 12:09:43 +0530
> > >> Subject: $$Excel-Macros$$ Need macro for attd workbook
> > >> To: excel-macros@googlegroups.com
> > >>
> > >> Hi respected members.
> > >>
> > >> i want ur help in macro. i v attd sample workbook, in that i want
> > >> macro that can protect rows which is not empty and unprotect empty
> > >> rows
> > >>
> > >> --
> > >>
> > >>
> --
> > >> Some important links for excel users:
> > >> 1. Follow us on TWITTER for tips tricks and links :
> > >> http://twitter.com/exceldailytip
> > >> 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> > >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> > >>
> > >> To post to this group, send email to excel-macros@googlegroups.com
> > >>
> > >> <><><><><><><><><><><><><><><><><><><><><><>
> > >> HELP US GROW !!
> > >>
> > >> We reach over 7000 subscribers worldwide and receive many nice notes
> about
> > >> the learning and support from the group.Let friends and co-workers
> know they
> > >> can subscribe to group at
> > >> http://groups.google.com/group/excel-macros/subscribe
> > >
> > > 
> > > Find it on Domain.com.au Need a new place to live?
> > >
> > > --
> > >
> --
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > > http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> > >
> > > To post to this group, send email to excel-macros@googlegroups.com
> > >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> > >
> > > We reach over 7000 subscribers worldwide and receive many nice notes
> about
> > > the learning and support from the group.Let friends and co-workers know
> they
> > > can subscribe to group at
> > > http://groups.google.com/group/excel-macros/subscribe
> > >
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
> >
> > We reach over 7000 subscribers worldwide and receive many nice notes
> about the learning and support from the group.Let friends and co-workers
> know they can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
> Find it at CarPoint.com.au New, Used, Demo, Dealer or 
> Private?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 

Re: $$Excel-Macros$$ RE: Need macro for attd workbook

[vidyut more]

Sir i stuck in your macro. 1 ) filter is not working 2) I have
usecanother macro for that sheet then where should i put ur macro. my
macro as follows

'Private Sub Worksheet_Change(ByVal Target As Range)
Dim Cell As Range
Dim pcNum As Long
Dim party As String
Dim prod As String
Dim ws As Worksheet
Dim tgtRowNum As Long
Dim lastDataRow As Long
Set ws = ActiveSheet
lastDataRow = ws.Range("A1").End(xlDown).Row
'end the procedure if the cursor is not in the first empty cell in
column AIf Target.Column <> 1 Then Exit Sub
If Target.Row <> lastDataRow Then Exit Sub
'find the last identifier
With Range("A:A")  'The range to search
On Error Resume Next
Set Cell = .Find(Target.Value, ActiveCell, xlValues, xlWhole,
xlByRows, xlPrevious)
End With
'
If Cell Is Nothing Then

'If a new number series is required, use an input box routine here
Exit Sub
Else
pcNum = Cell.Offset(0, 8).Value
prod = Cell.Offset(0, 1).Value
party = Cell.Offset(0, 2).Value
Target.Offset(0, 8).Value = pcNum + 1
Target.Offset(0, 1).Value = prod
Target.Offset(0, 2).Value = party
End If
End Sub

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

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

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

Re: $$Excel-Macros$$ Re: VBA code for importing data from excel to Access table

[debasish]

thanks for the reply...
its possible to import data from excel to Access.

Debasish

On Jul 20, 7:01 pm, VILAS CHAVAN  wrote:
> Hi
> is it posible, to export data excel to access using vba code
>
> vilas chavan
>
> On 7/19/10, Kishan Reddy, K  wrote:
>
> > Hello,
>
> > Very simple.
>
> > Select the macros tab.
>
> > click on the new button. Macro window will appear.
>
> > In actions column select 'TRANSFERSPREADSHEET'.
>
> > In action arguments column -
> > specify transfer type, spreadsheet type, table name into which data to
> > be exchanged, excel file name with path,
> > if the excel sheet is having header row in first column - set Has
> > field names to yes.
> > If you want to import only specified range from excle then mention the
> > range.
>
> > Just save it and name it accordingly.
>
> > Then select the macro and say RUN.
>
> > the macro will be executed.
>
> > If you still have a problem, send me the excel file and access DB to
> > me.
>
> > Regards,
>
> > Kishan Reddy, K
> > kishanreddy.kethire...@gmail.com
>
> > On Jul 19, 10:20 am, debasish  wrote:
> >> I am a novice in macro... could you please elaborate more on this..
>
> >> Thanks & regards,
> >> Debasish
>
> >> On Jul 18, 8:40 pm, Kishan K  wrote:
>
> >> > Hi,
>
> >> > In access, try to create a MACRO with action TRANSFERSPREADSHEET.
>
> >> > Regards,
>
> >> > Kishan Reddy K.
> >> > kishanreddy.kethire...@gmail.com
>
> >> > On Jul 16, 12:29 pm, debasish  wrote:> Hello
> >> > Everybody,
> >> > > I am working on a access database where in I have to import data from
> >> > > excel data on daily basis. I need a code so that i can update my
> >> > > access table with my excel file daily.
> >> > > Please help
> >> > > regards,
> >> > > Debasish- Hide quoted text -
>
> >> - Show quoted text -
>
> > --
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
> --
> With Best Regards,
>
> Vilas Chavan
> Email : cvi...@ymail.com, vilaschav...@gmail.com
> Mumbai - Maharashtra
> 9967458882

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

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

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

$$Excel-Macros$$ Re: Reverse of rounding

[larry]

I think that explains it. Thanks.

On Jul 21, 11:08 am, Stuart Redmann  wrote:
> On 20 Jul., larry wrote:
>
> > > > I have a macro where I copy data into an array from one sheet and then
> > > > post it in another sheet and there is something odd. .8 becomes ,
> > > > 79, .15 becomes .1501. The other way around this would be
> > > > rounding. It only changes the values in the first column. Any ideas on
> > > > what is going on?
>
> On 21 Jul., larry wrote:
>
> > Since the data was hard entered, typed directly, there shouldn't be
> > any extra digits hanging around.
>
> It does not matter whether you have entered the number exactly because
> Excel has to transform your text into a floating point number. Since
> there is no floating point number that has the value 0.15, Excel will
> use a floating point number that is closest to 0.15 (in your example
> 0.151). However, Excel performs some magic with floating point
> values so that it will display "0.15" even if the floating point value
> is 0.151 (seehttp://www.cs.berkeley.edu/~wkahan/ARITH_17.pdffor
> some examples of what Excel does). Apparently Excel does not cope with
> the case that the number is entered via some macro, hence you see the
> slighly "off" values. This may be a bug, although some people rather
> consider Excel's displaying "0.15" a bug.
>
> Regards,
> Stuart

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

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

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

Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

[Harmeet Singh]

Hi There,

See attached file.



Warm Regards,

Harmeet Singh
IT Analyst
McKinsey & Company
http://www.facebook.com/Harmeeet


On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal  wrote:

> Please help to add the product of two columns e.g.
>
> Column1Column2
>
> 23 119
> 8954
> 63   32
>
> Want to add (r1c1*r1c2+r2c1*r2c2+r3c1*r3c2)
>
> Thanks Ravi
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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


Book4.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

[Aindril De]

Use =SUMPRODUCT(A1:A3,B1:B3)

Assuming Column 1 is A and Column 2 is B

Cheers
Andy

On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal  wrote:

> Please help to add the product of two columns e.g.
>
> Column1Column2
>
> 23 119
> 8954
> 63   32
>
> Want to add (r1c1*r1c2+r2c1*r2c2+r3c1*r3c2)
>
> Thanks Ravi
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

RE: $$Excel-Macros$$ Preventing unauthorized access for your excel files

[Dave Bonallack]

Hi,Create a new sheet. On that, in large font, enter "Macros must be enabled to 
use this workbook."Create a workbook close event macro that makes all sheets 
xlveryhidden except the new sheet.Create a workbook open event macro that hides 
the new sheet and unhides all the others.If the macros are disabled on open, 
the open workbook macro wont run, the notice sheet will be displayed, and all 
others will be hidden.(Sheets that are xlveryhidden can only be opened by 
vba)Regards - Dave.

Date: Thu, 22 Jul 2010 15:29:46 +0530
Subject: $$Excel-Macros$$ Preventing unauthorized access for your excel files
From: taur...@gmail.com
To: excel-macros@googlegroups.com

Hi Group,
I need help in preventing unauthorized users from accessing my excel work 
book(s). Right now i have written the following vba code to achieve my 
objective. However, if some one were to choose to click 'Disable Macros', they 
can still access the contents of my file.

 
Sub auto_open()

UserN = Application.UserName

Select Case (UserN)
...
...Show contents if UserN is a authorized user else, close the work book
...
 
I am looking for means to close the file the moment an unauthorized person 
tries to access my file(s). Can some one help?
 
Regards
Rajesh




-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

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

 

<><><><><><><><><><><><><><><><><><><><><><>

HELP US GROW !!

 

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  
_
Need a new place to live? Find it on Domain.com.au
http://clk.atdmt.com/NMN/go/157631292/direct/01/

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

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

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

RE: $$Excel-Macros$$ RE: Need macro for attd workbook

[Dave Bonallack]

You're welcome.Dave.

> From: vidyutm...@gmail.com
> Date: Thu, 22 Jul 2010 17:42:58 +0530
> Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook
> To: excel-macros@googlegroups.com
> 
> Thank you so much sir "Dave Bonallack". Its what i was looking for. Thanks 
> again
> 
> On Thu, Jul 22, 2010 at 5:37 PM, Dave Bonallack
>  wrote:
> > Hi,
> > Have a look at the attached.
> > The macro prevents the selection of multiple cells.
> > If the selected cell contains data, it will be locked.
> > If the selected cell is blank, it will be unlocked.
> > Once a blank cell is edited, it will be locked automatically.
> > The protection is not password protected. You can add that if you need.
> >
> > Regards - Dave.
> >
> >
> >> From: vidyutm...@gmail.com
> >> Date: Thu, 22 Jul 2010 12:09:43 +0530
> >> Subject: $$Excel-Macros$$ Need macro for attd workbook
> >> To: excel-macros@googlegroups.com
> >>
> >> Hi respected members.
> >>
> >> i want ur help in macro. i v attd sample workbook, in that i want
> >> macro that can protect rows which is not empty and unprotect empty
> >> rows
> >>
> >> --
> >>
> >> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> HELP US GROW !!
> >>
> >> We reach over 7000 subscribers worldwide and receive many nice notes about
> >> the learning and support from the group.Let friends and co-workers know 
> >> they
> >> can subscribe to group at
> >> http://groups.google.com/group/excel-macros/subscribe
> >
> > 
> > Find it on Domain.com.au Need a new place to live?
> >
> > --
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
> >
> > We reach over 7000 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> > http://groups.google.com/group/excel-macros/subscribe
> >
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>  
> To post to this group, send email to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 7000 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
  
_
New, Used, Demo, Dealer or Private? Find it at CarPoint.com.au
http://clk.atdmt.com/NMN/go/206222968/direct/01/

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

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

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

Re: $$Excel-Macros$$ Re: $excel-macros$ help

[Chandru]

Dear Kishan Reddy

This is a very good tip and many thanks for sharing the same. I knew about
excel clip board for many years but this idea of using "Paste all" to
combine all sheets is really a magic.

Thanks
Chandru

On Thu, Jul 22, 2010 at 11:36 AM, Kishan Reddy, K <
kishanreddy.kethire...@gmail.com> wrote:

> Hello,
>
> Open the Office clipboard: From Menu select Edit -> Office clipboard.
>
> Office clipboard will appear on the right side.
>
> Goto sheet 1 and select Data, and Press Control+C, Data will appear on
> Office Clipboard.
>
> Repeat the above step for all sheets.
>
> Then use the Paste All Option on Office clipboard.
>
> Then use clear all to clear all copies.
>
> This is the easiest and simple method.
>
>
>
>
> On Jul 21, 8:40 pm, preeti vora  wrote:
> > Hi team
> >
> > i have one excel file there is 10 to 15 sheet different but i want to
> marge
> > in one sheet is that possible to do???
> >
> > --
> > Regards,
> >
> > Preeti Vora.
> >
> >  data.xls
> > 24KViewDownload
>
>

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

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

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

Re: $$Excel-Macros$$ RE: Need macro for attd workbook

[vidyut more]

Thank you so much sir "Dave Bonallack". Its what i was looking for. Thanks again

On Thu, Jul 22, 2010 at 5:37 PM, Dave Bonallack
 wrote:
> Hi,
> Have a look at the attached.
> The macro prevents the selection of multiple cells.
> If the selected cell contains data, it will be locked.
> If the selected cell is blank, it will be unlocked.
> Once a blank cell is edited, it will be locked automatically.
> The protection is not password protected. You can add that if you need.
>
> Regards - Dave.
>
>
>> From: vidyutm...@gmail.com
>> Date: Thu, 22 Jul 2010 12:09:43 +0530
>> Subject: $$Excel-Macros$$ Need macro for attd workbook
>> To: excel-macros@googlegroups.com
>>
>> Hi respected members.
>>
>> i want ur help in macro. i v attd sample workbook, in that i want
>> macro that can protect rows which is not empty and unprotect empty
>> rows
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>
> 
> Find it on Domain.com.au Need a new place to live?
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

$$Excel-Macros$$ Preventing unauthorized access for your excel files

[Rajesh Srinivasaraghavan]

Hi Group,
I need help in preventing unauthorized users from accessing my excel work
book(s). Right now i have written the following vba code to achieve my
objective. However, if some one were to choose to click 'Disable Macros',
they can still access the contents of my file.

Sub auto_open()

UserN = Application.UserName

Select Case (UserN)
...
...*Show contents if UserN is a authorized user else, close the work book*
...

I am looking for means to close the file the moment an unauthorized person
tries to access my file(s). Can some one help?

Regards
Rajesh

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

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

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

Re: $$Excel-Macros$$ Need macro for attd workbook

[Beer Bahadur]

Hello Vidyut,

Please find the attached file for your reference.

Regards,

Beer.

On Thu, Jul 22, 2010 at 12:09 PM, vidyut more  wrote:

> Hi respected members.
>
> i want ur help in macro. i v attd sample workbook, in that i want
> macro that can protect rows which is not empty and unprotect empty
> rows
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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


Macro help needed.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Help with Date

[HARI NAIR]

Dear Friends,

I want rate automatically comes  from rate sheet in Data sheet when I enter
the remaining details in the attached file, please help, Thanks in advance

Regards,

Hari

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

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

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


PR.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ RE: Need macro for attd workbook

[Dave Bonallack]

Hi,

Have a look at the attached.

The macro prevents the selection of multiple cells.

If the selected cell contains data, it will be locked.

If the selected cell is blank, it will be unlocked.

Once a blank cell is edited, it will be locked automatically.

The protection is not password protected. You can add that if you need.

 

Regards - Dave.


 
> From: vidyutm...@gmail.com
> Date: Thu, 22 Jul 2010 12:09:43 +0530
> Subject: $$Excel-Macros$$ Need macro for attd workbook
> To: excel-macros@googlegroups.com
> 
> Hi respected members.
> 
> i want ur help in macro. i v attd sample workbook, in that i want
> macro that can protect rows which is not empty and unprotect empty
> rows
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 7000 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
  
_
Need a new place to live? Find it on Domain.com.au
http://clk.atdmt.com/NMN/go/157631292/direct/01/

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

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

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


Macro help needed.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

[Dilip Pandey]

Hi Mr. Patwal,

Try using SumProduct funtion to achieve desired results...!!

SumProduct((First Column Reference),(Second Column Reference))

-- 
Thanks & Regards,

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


On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal  wrote:

> Please help to add the product of two columns e.g.
>
> Column1Column2
>
> 23 119
> 8954
> 63   32
>
> Want to add (r1c1*r1c2+r2c1*r2c2+r3c1*r3c2)
>
> Thanks Ravi
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

Re: $$Excel-Macros$$ excel help

[Dilip Pandey]

Hi Preeti,

Vlookup requires col_index_num and range_lookup to function properly,
If reqd., instead of Vlookup you can use Index, Match, Offset, SumIf,
Sumproduct etc as well.  :)


-- 
Thanks & Regards,

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


On Wed, Jul 21, 2010 at 9:01 PM, preeti vora  wrote:

> Hi team,
>
> when we do vlookup is that possible without col_index_num and range_lookup
> for use vlookup..or can we use any other function instead of vlookup...
>
> --
> Regards,
>
> Preeti Vora.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

$$Excel-Macros$$ Need macro for attd workbook

[vidyut more]

Hi respected members.

i want ur help in macro. i v attd sample workbook, in that i want
macro that can protect rows which is not empty and unprotect empty
rows

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

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

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


Macro help needed.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: excel help

[Kishan Reddy, K]

col_index_num is mandatory for vlookup function, range_lookup is
optional.
If range_lookup is not given it will take it  as TRUE.
One important point for using Vlookup is that the table array should
be sorted on the first column.


On Jul 21, 8:31 pm, preeti vora  wrote:
> Hi team,
>
> when we do vlookup is that possible without col_index_num and range_lookup
> for use vlookup..or can we use any other function instead of vlookup...
>
> --
> Regards,
>
> Preeti Vora.

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

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

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

$$Excel-Macros$$ How to ADD product of two columns in a single cell

[Rave Patwal]

Please help to add the product of two columns e.g.

Column1Column2

23 119
8954
63   32

Want to add (r1c1*r1c2+r2c1*r2c2+r3c1*r3c2)

Thanks 
Ravi 


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

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

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

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

$$Excel-Macros$$ Re: $excel-macros$ help

[Kishan Reddy, K]

Hello,

Open the Office clipboard: From Menu select Edit -> Office clipboard.

Office clipboard will appear on the right side.

Goto sheet 1 and select Data, and Press Control+C, Data will appear on
Office Clipboard.

Repeat the above step for all sheets.

Then use the Paste All Option on Office clipboard.

Then use clear all to clear all copies.

This is the easiest and simple method.




On Jul 21, 8:40 pm, preeti vora  wrote:
> Hi team
>
> i have one excel file there is 10 to 15 sheet different but i want to marge
> in one sheet is that possible to do???
>
> --
> Regards,
>
> Preeti Vora.
>
>  data.xls
> 24KViewDownload

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

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

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

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

[saggi]

Use = Search (" ",cellreference)
Like Search (" ", White Black) result will be 6

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

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

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

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

[Soni.Rajender]

Hi

You can use the formulaes as below:

= FIND(" ",A1,1)  or
=SEARCH(" ",A1,1)

Regards
Rajender Soni ! 750 322 55 50


On Jul 22, 2:48 am, Edgar  wrote:
> I'm trying to clean up some data. I've used SEARCH and FIND to try to
> identify the first space within a cell, but the answer comes back
> incorrect.
>
> I've used SEARCH("", Cell Reference)
>
> It's giving me the first cell. For example, the answer to this would
> be 1.
>
> If I used SEARCH("", Cell reference, 20), it would show 20.
>
> Any help, pls?

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

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

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