date:20121023

Re: $$Excel-Macros$$ Re:Data Validation

2012-10-23 Thread Umar Abeer

Hi Rajan

I think I was not clear enough my bad.

Basically, normal validation in excel works by limiting/controlling the
inputs to a cell. Here on my P&L, I have my net profit line which I don't
want to change and is liked to like a 100 sheets and comes through formula.

One way of doing it is to lock the entire workbook for editing but in my
case that is not feasible. So I was thinking maybe if some kind of
validation control could be devised so as to prompt me whenever the net
profit number changes.

Thanks
Dino

On Tue, Oct 23, 2012 at 6:36 PM, Rajan_Verma wrote:

> *So what is the issue??*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Umar Abeer
> *Sent:* 23 October 2012 1:54
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re:Data Validation
>
> ** **
>
> Hi Guys
>
> ** **
>
> I have a workbook with lots of sheets culminating in a P&L. I wish to put
> a sort of validation that if my final net profit number changes because of
> any reason, excel throws a validation error? 
>
> ** **
>
> Many Thanks
>
> Dino
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Macro Not working in shared Work Book

2012-10-23 Thread Paul Schreiner

I've usually come across this if the password supplied with
the unprotect method is incorrect.

can you check that?
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Viswanathan Yoganathan 
To: "excel-macros@googlegroups.com" 
Sent: Tue, October 23, 2012 3:24:34 PM
Subject: $$Excel-Macros$$ Macro Not working in shared Work Book


Hi, 
 
I am getting the below error if I run the macro in a shared and protected 
workbook.
 
‘Run time Error 1004 unprotect method of worksheet class failed’ 
 
Do we have any solution to overcome.
 
 
Thanks,
Vishwa.
"CONFIDENTIALITY NOTICE: This message and any attachment are confidential and 
may also be privileged. If you are not the intended recipient of this e-mail 
you 
may not copy, forward, disclose or otherwise use it or any part of it in any 
form whatsoever. If you are not the intended recipient please telephone or 
e-mail the sender and delete this message and any attachment from your 
system."-- 

Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Macro Not working in shared Work Book

2012-10-23 Thread Viswanathan Yoganathan

Hi,

I am getting the below error if I run the macro in a shared and protected 
workbook.

'Run time Error 1004 unprotect method of worksheet class failed'

Do we have any solution to overcome.


Thanks,
Vishwa.
"CONFIDENTIALITY NOTICE: This message and any attachment are confidential and 
may also be privileged. If you are not the intended recipient of this e-mail 
you may not copy, forward, disclose or otherwise use it or any part of it in 
any form whatsoever. If you are not the intended recipient please telephone or 
e-mail the sender and delete this message and any attachment from your system."

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Need your advise - MS Access 2007 drop down list Macro

2012-10-23 Thread Mangesh Vimay

Thanks Ashish for the great support !!!
Please try to solve the query of RajaSekhar as it is also important for me.
Thanks again 

On Tue, Oct 23, 2012 at 1:17 AM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:

> Hi Ashish,
>
> Adding to below i do maintain huge data base of access but if i want to
> export to excel i am facing the problem
>
> as there are more than 2lac rows or records in access Just require ur
> expertise can i use the same macro which is listed below if so please
> advise the sql command to get for example
>
> to export  complete details in batches wise
>
> 1st record to 6 th record like wise.
>
> Thanks,
> Raj
>
>
> On Sun, Oct 21, 2012 at 10:13 PM, ashish koul wrote:
>
>> Option Compare Database
>>
>> Private Sub Command11_Click()
>> ' Add microsoft Excel
>> ' ADD aTIEVEX DATA OBJECT
>>
>> Dim xla As Excel.Application
>> Dim wk As Excel.Workbook
>> Dim cn As New ADODB.Connection
>> Dim rs As New ADODB.Recordset
>> Dim j As Long
>>
>> Set cn = CurrentProject.Connection
>> qry = "select * from Details where [Details].[Details] like '%" &
>> Me.Text12.Value & "%'"
>> rs.Open qry, cn, adOpenDynamic, adLockOptimistic
>>
>> If rs.EOF = True Then
>> MsgBox "No Records found", vbInformation, "Note: "
>> rs.Close
>> cn.Close
>> Exit Sub
>> End If
>>
>>
>> Set xla = New Excel.Application
>> Set wk = xla.Workbooks.Add
>>
>> For i = 0 To rs.Fields.Count - 1
>> wk.Sheets(1).Cells(1, i + 1).Value = rs.Fields(i).Name
>> Next
>>
>>
>> wk.Sheets(1).Range("A2").CopyFromRecordset rs
>> wk.Sheets(1).UsedRange.EntireColumn.AutoFit
>> xla.Visible = True
>>
>> End Sub
>>
>>
>> On Sun, Oct 21, 2012 at 9:24 PM, Mangesh Vimay 
>> wrote:
>>
>>> Deal ALL,
>>>
>>> Please help me on above issue.
>>> Please !!!
>>>
>>>
>>> With regards,
>>>
>>> Mangesh
>>>
>>>
>>> On Sat, Oct 20, 2012 at 11:08 PM, Mangesh Vimay >> > wrote:
>>>
 Hi Ashish,

 It is for just exporting result set to Excel.
 But, I need code for search criteria as well.

 Please do needful.

 Thanks !!!

 With regards,

 Mangesh


 On Sat, Oct 20, 2012 at 10:32 PM, ashish koul wrote:

> just make small changes in this file and it will work as per your
> requirement
>
>
> http://accessvbaprogramming.wordpress.com/2012/09/18/type-sql-query-in-text-box-in-access-form-and-export-output-to-excel/
>
>
>
> On Sat, Oct 20, 2012 at 10:30 PM, Mangesh Vimay <
> mangesh.da...@gmail.com> wrote:
>
>> Hi Noorain,
>>
>> Thank you so much for your reply.
>> I have attached database file (sample) to show you what exact I need.
>> Please find the file "Temp".
>> In Temp we have two objects
>> Table - Detail
>> Form - City Details
>> In the Form I have inserted search criteria text box in which if I
>> enter the text "Capital" and click on the Search button. Then It should
>> export the result into Excel file with the result set like below :
>>ID City Details  3 Mumbai Financial Capital of India  6 Delhi Capital
>> of India
>> So I get above output in excel file because it is containing the
>> string "capital".
>> It can be done by Macro.
>> And please help- me on this.
>>
>> Thanks
>>
>> With regards
>>
>> Mangesh
>>
>>
>> On Sat, Oct 20, 2012 at 6:35 AM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear mangesh,
>>>
>>> Please see attached access database. Hope it will help to  you.
>>>
>>>
>>> On Sat, Oct 20, 2012 at 12:20 AM, Mangesh Vimay <
>>> mangesh.da...@gmail.com> wrote:
>>>
 Hi Friends,

 I am using MS Access 2007.
 I have table called "City".
 The table "City" contains the information of the different cities of
 INDIA with their details.

 For example,
 CityDetails
 Mumbai  It is the Financial capital of India
 Delhi Capital of India
 I have also form for retrieving details of the city
 It contains the drop down list for all cities of India
 If I select Mumbai from the drop down list, then it should display
 the details.
 However, I have another search option i.e. "Search by Keyword"
 In Search by keyword, if we enter any string from the details
 column.
 It should display all records that consists the specified string.
 For example, if we enter the string "capital" in text box, then it
 should display all records containing the string "capital".
 I need the macro (or any other solution) to do this.
 I hope, I am able to explain what I need.
 I know, this group is dedicated to MS Excel only. But I also know
 there are many experts who does well in Access as well.

 So I request all please help me by providing suitable solutions.
 Ap

$$Excel-Macros$$ Re: Vlookup with total

2012-10-23 Thread Vishwanath

Hi,
You can also use sumif function

=SUMIF(A2:B8,E5,B2:B8). Attachment is with formula results are derived.
rgsd
vishwanath


   
On Tuesday, October 23, 2012 12:56:36 PM UTC+5:30, Amit Desai (MERU) wrote:
>
>  Dear All,
>
>  
>
> I have an excel file for which, there is Incentive worked out based on 2-3 
> parameters for the same Technician.
>
>  
>
> I want to do a vlookup with the total amount (of 2-3 amounts) against that 
> person. Please help me with a formula.
>
>  
>
> Best Regards,
>
> Amit
>
>  
>  
> --
> Disclaimer: This message and its attachments contain confidential 
> information and may also contain legally privileged information. This 
> message is intended solely for the named addressee. If you are not the 
> addressee indicated in this message (or authorized to receive for 
> addressee), you may not copy or deliver any part of this message or its 
> attachments to anyone or use any part of this message or its attachments. 
> Rather, you should permanently delete this message and its attachments (and 
> all copies) from your system and kindly notify the sender by reply e-mail. 
> Any content of this message and its attachments that does not relate to the 
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have 
> been sent or endorsed by any of them. Email communications are not private 
> and no warranty is made that e-mail communications are timely, secure or 
> free from computer virus or other defect.
>  

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Vlookup with sumtotal(Amit)_1.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ MsgBox Query

2012-10-23 Thread Rajan_Verma

Ah.. Did I ask anything?

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: 23 October 2012 9:02
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ MsgBox Query

 

hmm... just to be clear, your statement:

"Just remove the inverted commas"

is not entirely accurate.

 

Those are quotes (") not commas(,)

and, "inverted" means up-side-down.

 

The quotes that were used is what is called "curly quotes" or "book quotes"

or techincally called "reversed" or "double prime" quotes.

 

In some cases, an editor (html, or possibly MS Word), when using a specific
font,

may convert them as to indicate an "opening" and "closing" quote.

 

Nevertheless, while some programming languages utilize them, VBA does not.

 

So, as you indicated, if the code was entered into one of these editors
which

converted the symbol, it would have to be corrected before VBA would
recognize it.


 

Paul

-
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-

 

 

  _  

From: Rajan_Verma 
To: excel-macros@googlegroups.com
Sent: Tue, October 23, 2012 10:24:20 AM
Subject: RE: $$Excel-Macros$$ MsgBox Query

It seems that you copy it from somewhere, Just remove the inverted commas
and put them again

 

Private Sub CommandButton2_Click()

 

contents = Worksheets("Sheet1").Range("A1").Value

MsgBox contents

 

' I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX

 

End Sub

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SAJID MEMON
Sent: 23 October 2012 10:41
To: Sundarvelan Natarajan
Subject: $$Excel-Macros$$ MsgBox Query

 


 

 

Dears,
Find enclosed above attachemnt 
I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX

Awiting...
 
Sajid Memon

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, goo

Re: $$Excel-Macros$$ MsgBox Query

2012-10-23 Thread Paul Schreiner

hmm... just to be clear, your statement:
"Just remove the inverted commas"
is not entirely accurate.

Those are quotes (") not commas(,)
and, "inverted" means up-side-down.

The quotes that were used is what is called "curly quotes" or "book quotes"
or techincally called "reversed" or "double prime" quotes.

In some cases, an editor (html, or possibly MS Word), when using a specific 
font,
may convert them as to indicate an "opening" and "closing" quote.


Nevertheless, while some programming languages utilize them, VBA does not.

So, as you indicated, if the code was entered into one of these editors which
converted the symbol, it would have to be corrected before VBA would recognize 
it.

 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Rajan_Verma 
To: excel-macros@googlegroups.com
Sent: Tue, October 23, 2012 10:24:20 AM
Subject: RE: $$Excel-Macros$$ MsgBox Query


It seems that you copy it from somewhere, Just remove the inverted commas and 
put them again
 
Private Sub CommandButton2_Click()
 
contents = Worksheets("Sheet1").Range("A1").Value
MsgBox contents
 
' I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX
 
End Sub
 
 
 
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
 
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of SAJID MEMON
Sent: 23 October 2012 10:41
To: Sundarvelan Natarajan
Subject: $$Excel-Macros$$ MsgBox Query
 

 
 
Dears,
Find enclosed above attachemnt 
I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX

Awiting...
 
Sajid Memon
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 -- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and

RE: $$Excel-Macros$$ Excel Graph Problem

2012-10-23 Thread Rajan_Verma

You will get desired here..

http://www.excelfox.com/forum/f13/excel-dynamic-waterfall-chart-317/

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of prkhan56
Sent: 20 October 2012 10:03
To: excel-macros@googlegroups.com
Cc: sushil.sha...@smalution.com
Subject: Re: $$Excel-Macros$$ Excel Graph Problem

 

Reposting - any help on this please?

Regards


On Wednesday, October 17, 2012 10:20:15 PM UTC+4, prkhan56 wrote:

Hello there,

Thanks for the reply

Can you guide me how to setup my data please?

Regards

Rashid Khan
On Tuesday, October 16, 2012 9:31:53 PM UTC+4, Sushil Kumar wrote:

Hi Rashid,
Your graph not correct
and graph looks the image of waterfall chat so you need to setup the cross
of x-axes and y-axes bar
then according to data your chart move up and down or cross the axes



On Tue, Oct 16, 2012 at 10:57 PM, Rashid Khan  wrote:

Hello All,

Is it possible to create the graph shown on the attached file as per the
data shown?

 

Regards

Rashid Khan

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-...@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros...@googlegroups.com.
 
 




-- 

Sushil Sharma   / CEO / Smart Solutions

_

Mobile: +919029029072 
102, B-20, Sector-1, Mira Road, Mumbai, India
email: sushil.sha...@smalution.com 

skype:smalution
web: http://www.smalution.com 

http://www.linkedin.com/pub/sushil-sharma/30/98b/578

 

 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Re:Data Validation

2012-10-23 Thread Rajan_Verma

So what is the issue??

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Umar Abeer
Sent: 23 October 2012 1:54
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re:Data Validation

 

Hi Guys

 

I have a workbook with lots of sheets culminating in a P&L. I wish to put a
sort of validation that if my final net profit number changes because of any
reason, excel throws a validation error? 

 

Many Thanks

Dino

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Re: Text need in different collume

2012-10-23 Thread Rajan_Verma

 

 

You can extract number only form a string without vba,

 

Anyway ,here is a VBA code to extract NUMBER,TEXT,SPECIAL CHR from a string

 

= RemoveContents(StringToReplace, 1)   ' To Remove Text

= RemoveContents(StringToReplace, 2)  ' To Remove Number

= RemoveContents(StringToReplace, 3)  ' To Remove Special Characters

 

 

 

Function RemoveContents(StringToReplace, WhatRemove As Long) As String

 

Dim RegEx As Object

Set RegEx = CreateObject("VBScript.RegExp")

 

With RegEx

.Global = True

Select Case WhatRemove

Case 1

.Pattern = "[a-z]"

Case 2

.Pattern = "\d"

Case 3

.Pattern = "[\;+\.+\#+\!+\'+\*+\,+\+\^+\&+\*+\@+\(+\)]"

End Select

End With

RemoveContents = RegEx.Replace(StringToReplace, "")

End Function

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of  ??  
Sent: 23 October 2012 12:14
To: excel-macros@googlegroups.com; manoj.11...@gmail.com
Subject: Re: $$Excel-Macros$$ Re: Text need in different collume

 

Dear Manoj,

Pl find enclosed the attachment.

 

Regards,



 

On Tue, Oct 23, 2012 at 11:18 AM, Manoj Kumar  wrote:

Dear Expert,

 

I have data witch has Text and Number i want to do saperate text and number
in next collume.

 


man25oj


kuma112r


ro444ha25n


25s26on7

 

 

 

Regard

Manoj

 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
 .
 
 




-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ MsgBox Query

2012-10-23 Thread Rajan_Verma

It seems that you copy it from somewhere, Just remove the inverted commas
and put them again

 

Private Sub CommandButton2_Click()

 

contents = Worksheets("Sheet1").Range("A1").Value

MsgBox contents

 

' I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX

 

End Sub

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SAJID MEMON
Sent: 23 October 2012 10:41
To: Sundarvelan Natarajan
Subject: $$Excel-Macros$$ MsgBox Query

 


 

 

Dears,
Find enclosed above attachemnt 
I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX

Awiting...
 
Sajid Memon

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Adding OR in between numbers using macro

2012-10-23 Thread Rajan_Verma

Use this 

 

Function AddOr(rngRange As Range) As String



If rngRange.Columns.Count > 1 And rngRange.Rows.Count > 1 Then

AddOr = "Invalid Input"

Exit Function

End If

If rngRange.Rows.Count > 1 Then

AddOr = Join(Application.Transpose(rngRange), " Or ")

ElseIf rngRange.Columns.Count > 1 Then

AddOr = Join(Application.Transpose(Application.Transpose(rngRange)),
" Or ")

End If



End Function

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vignesh S R
Sent: 22 October 2012 8:10
To: excel-macros
Subject: $$Excel-Macros$$ Adding OR in between numbers using macro

 

hi,
I have to add one variable "OR" in between numbers
I have attached the excel sheet.
Kindly do the needful.

Input : 1231 , 1234 , 12345 , 4342
Output 1231 OR 1234 OR 12345 OR 4342

-- 
Vignesh .S.R

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Trouble in 2007

2012-10-23 Thread Rajan_Verma

Can you share something like this ??

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of KAUSHIK SAVLA
Sent: 22 October 2012 2:37
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Trouble in 2007

 

On Oct 21, 2012 5:31 PM, "SAJID MEMON"  wrote:

Dear experts,
 
I have done a small project in excel 2003 with some command buttons. when i
open my project in excel 2007 then command buttons are not press or working.
Why this problem come in 2007? please give me settings or any suggesstion. I
have checked micro to enabled and desabled but same promblems is constant.
 
Awaiting your positive responce
Regards
Sajid Memon

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
 .
 
 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ MsgBox Query

2012-10-23 Thread Paul Schreiner

your macro is basically correct:

contents = Worksheets(“Sheet1”).Range(“A1”).Value
however, the 'quotes' in your line are incorrect.
(“) and (”) are improper delimeters.

It should read:

contents = Worksheets("Sheet1").Range("A1").Value
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: SAJID MEMON 
To: Sundarvelan Natarajan 
Sent: Tue, October 23, 2012 1:11:02 AM
Subject: $$Excel-Macros$$ MsgBox Query



 



Dears,
Find enclosed above attachemnt 
I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX

Awiting...
 
Sajid Memon
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Fwd: Dengue Fever - Useful Info.

2012-10-23 Thread Paul Schreiner

First of all, this is not the forum for this type of distribution.
Secondly, the information is a "hoax"
and has been passed around since 2005 with different plants as remedies.

http://www.joewein.net/hoax/hoax-papaya-juice-dengue-fever-cure.htm

Please refrain from posting "chain mail" messages in this forum.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-










 
  
>Dengue Fever Remedy
>> 
>>  
>>  
>>I would like to share this interesting discovery from a classmate's son who 
>>has 
>>just recovered from dengue fever. Apparently, his son was in the critical 
>>stage 
>>at the ICU when his blood platelet count drops to 15 after 15 liters of blood 
>>transfusion.
>>
>>His father was so worried that he seeks another friend's recommendation and 
>>his 
>>son was saved. He confessed to me that he gave his son raw juice of the 
>>papaya 
>>leaves. From a platelet count of 45 after 20 liters of blood transfusion, and 
>>after drinking the raw papaya leaf juice, his platelet count jumps instantly 
>>to 
>>135. Even the doctors and nurses were surprised. After the second day he was 
>>discharged. So he asked me to pass this good news around.
>>
>>Accordingly it is raw papaya leaves, 2pcs just cleaned and pound and squeeze 
>>with filter cloth. You will only get one tablespoon per leaf.. So two 
>>tablespoon 
>>per serving once a day. Do not boil or cook or rinse with hot water, it will 
>>loose its strength. Only the leafy part and no stem or sap. It is very bitter 
>>and you have to swallow it like "Won Low Kat". But it works.
>>
>>*Papaya Juice - Cure for Dengue*
>>
>>You may have heard this elsewhere but if not I am glad to inform you that 
>>papaya 
>>juice is a natural cure for dengue fever. As dengue fever is rampant now, I 
>>think it's good to share this with all.
>>
>>A friend of mine had dengue last year.. It was a very serious situation for 
>>her 
>>as her platelet count had dropped to 28,000 after 3 days in hospital and 
>>water 
>>has started to fill up her lung. She had difficulty in breathing. She was 
>>only 
>>32-year old. Doctor says there's no cure for dengue. We just have to wait for 
>>her body immune system to build up resistance against dengue and fight its 
>>own 
>>battle. She already had 2 blood transfusion and all of us were praying very 
>>hard 
>>as her platelet continued to drop since the first day she was admitted.
>>
>>Fortunately her mother-in-law heard that papaya juice would help to reduce 
>>the 
>>fever and got some papaya leaves, pounded them and squeeze the juice out for 
>>her. The next day, her platelet count started to increase, her fever subside. 
>>We 
>>continued to feed her with papaya juice and she recovered after 3 days!!!
>>
>>Amazing but it's true. It's believed one's body would be overheated when one 
>>is 
>>down with dengue and that also caused the patient to have fever papaya juice 
>>has 
>>cooling effect. Thus, it helps to reduce the level of heat in one's body, 
>>thus 
>>the fever will go away. I found that it's also good when one is having sore 
>>throat or suffering from heat.
>>
>>Please spread the news about this as lately there are many dengue cases. It's 
>>great if such natural cure could help to ease the sufferings of dengue 
>>patients.
>>
>>Furthermore it's so easily available.
>>Blend them and squeeze the juice! It's simple and miraculously effective!!
>> 
>> 
>>PASS THIS  INFORMATION TO AS MANY AS YOU CAN, IT MAY SAVE LIVES.   
>> 
>>  
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups

Re: $$Excel-Macros$$ countif in hidden rows

2012-10-23 Thread NOORAIN ANSARI

Dear Danial,

For Count of Hidden row, you can use..

*=COUNTA(B1:B7)-SUBTOTAL(103,B1:B7)*

On Mon, Oct 22, 2012 at 7:20 PM, danial mansoor wrote:

>  Dear Experts,
>
> kindly provide me countif formula for hidden rows, i triend to use
> subtotal but could fine the way,kindly provide me formula.
>
>
>
>
>
> --
> From: aamirshahza...@gmail.com
> Date: Mon, 22 Oct 2012 17:11:03 +0500
> Subject: Re: $$Excel-Macros$$ Formula Needed !
> To: excel-macros@googlegroups.com
>
> use below formula for get desired sum
>
> =SUMIF($B$2:$B$663,E3,$C$2:$C$663)
>
> On Mon, Oct 22, 2012 at 5:06 PM, Amresh Maurya 
> wrote:
>
> PFA File
>
> On Mon, Oct 22, 2012 at 5:27 PM, Shaikh Iqbal 
> wrote:
> > Thx Abhi
> >
> >
> >
> >
> > Regards,
> >
> > Iqbal S
> >
> >
> > On 22 October 2012 17:24, abhishek agarwal  >
> > wrote:
> >>
> >>
> >>
> >> Dear Shaikh Iqbal
> >>
> >>
> >>
> >>
> >> Please find the attachment for the same
> >>
> >>
> >>
> >>
> >> On Mon, Oct 22, 2012 at 5:18 PM, Shaikh Iqbal 
> >> wrote:
> >>>
> >>> Dear Exports,
> >>>
> >>> Need help in attached file.
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> Shaikh Iqbal
> >>>
> >>> --
> >>> Join official facebook page of this forum @
> >>> https://www.facebook.com/discussexcel
> >>>
> >>> FORUM RULES (1120+ members already BANNED for violation)
> >>>
> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will
> >>> not get quick attention or may not be answered.
> >>>
> >>> 2) Don't post a question in the thread of another member.
> >>>
> >>> 3) Don't post questions regarding breaking or bypassing any security
> >>> measure.
> >>>
> >>> 4) Acknowledge the responses you receive, good or bad.
> >>>
> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in
> >>> signatures are prohibited.
> >>>
> >>> 6) Jobs posting is not allowed.
> >>>
> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
> allowed.
> >>>
> >>> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum
> >>> owners and members are not responsible for any loss.
> >>> ---
> >>> You received this message because you are subscribed to the Google
> Groups
> >>> "MS EXCEL AND VBA MACROS" group.
> >>> To post to this group, send email to excel-macros@googlegroups.com.
> >>> To unsubscribe from this group, send email to
> >>> excel-macros+unsubscr...@googlegroups.com.
> >>>
> >>>
> >>
> >>
> >> --
> >> Join official facebook page of this forum @
> >> https://www.facebook.com/discussexcel
> >>
> >> FORUM RULES (1120+ members already BANNED for violation)
> >>
> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> >> not get quick attention or may not be answered.
> >>
> >> 2) Don't post a question in the thread of another member.
> >>
> >> 3) Don't post questions regarding breaking or bypassing any security
> >> measure.
> >>
> >> 4) Acknowledge the responses you receive, good or bad.
> >>
> >> 5) Cross-promotion of, or links to, forums competitive to this forum in
> >> signatures are prohibited.
> >>
> >> 6) Jobs posting is not allowed.
> >>
> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
> >>
> >> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum
> >> owners and members are not responsible for any loss.
> >> ---
> >> You received this message because you are subscribed to the Google
> Groups
> >> "MS EXCEL AND VBA MACROS" group.
> >> To post to this group, send email to excel-macros@googlegroups.com.
> >> To unsubscribe from this group, send email to
> >> excel-macros+unsubscr...@googlegroups.com.
> >>
> >>
> >
> >
> > --
> > Join official facebook page of this forum @
> > https://www.facebook.com/discussexcel
> >
> > FORUM RULES (1120+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5) Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > 6) Jobs posting is not allowed.
> >
> > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
> > ---
> > You received this message because you are subscribed to the Google Groups
> > "MS EXCEL AND VBA MACROS" group.
> > To po

Re: $$Excel-Macros$$ Arrow Symbol Solution in Excel

2012-10-23 Thread amar takale

hi satendra
can you solve in excel then i will better clarification


On Tue, Oct 23, 2012 at 3:59 PM, Satendra kumar
wrote:

> Hi Amar,
>
> *go to conditional formatting and set icons*
>
>
> On Tue, Oct 23, 2012 at 3:51 PM, amar takale  wrote:
>
>> Hi Experts,
>> Pls Solved Problem in Attached Excel
>>
>> Regards
>> Amar
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> Thanks & Regards
> Satendra Kumar
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Arrow Symbol Solution in Excel

2012-10-23 Thread Satendra kumar

Hi Amar,

*go to conditional formatting and set icons*

On Tue, Oct 23, 2012 at 3:51 PM, amar takale  wrote:

> Hi Experts,
> Pls Solved Problem in Attached Excel
>
> Regards
> Amar
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Thanks & Regards
Satendra Kumar

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Arrow Symbol Solution in Excel

2012-10-23 Thread amar takale

Hi Experts,
Pls Solved Problem in Attached Excel

Regards
Amar

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Arrow Symbol Solution.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Text need in different collume

2012-10-23 Thread Prince

Hi 
Please try it

=SUM(MID(0&A1,LARGE(ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))*ROW(INDIRECT("1:"&LEN(A1))),ROW(INDIRECT("1:"&LEN(A1+1,1)*
10^ROW(INDIRECT("1:"&LEN(A1)))/10)

regards
prince

On Tuesday, October 23, 2012 11:19:06 AM UTC+5:30, Manoj Kumar wrote:
>
> Dear Expert,
>
>>
>> I have data witch has Text and Number i want to do saperate text and 
>> number in next collume.
>>
>>  man25oj  kuma112r  ro444ha25n  25s26on7 
>>
>>
>>
>> Regard
>> Manoj
>>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Re:Data Validation

2012-10-23 Thread Umar Abeer

Hi Guys

I have a workbook with lots of sheets culminating in a P&L. I wish to put a
sort of validation that if my final net profit number changes because of
any reason, excel throws a validation error?

Many Thanks
Dino

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread Amit Desai (MERU)

Thanks a lot.

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of NOORAIN ANSARI
Sent: 23 October 2012 13:19
To: excel-macros@googlegroups.com
Cc: gawlianil8...@gmail.com
Subject: Re: $$Excel-Macros$$ Vlookup with total

Dear Amit,

Please try,

=SUMPRODUCT(($A$3:$A$8=$E5)*($B$3:$B$8))

see attached sheet for more clarity

On Tue, Oct 23, 2012 at 1:06 PM, Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>> wrote:
Please find attached sample data file... I need Vlookup solution & not the 
Pivoting pls...

Best Regards,
Amit

From: अनिल नारायण गवली 
[mailto:gawlianil8...@gmail.com]
Sent: 23 October 2012 12:59
To: excel-macros@googlegroups.com; Amit 
Desai (MERU)
Subject: Re: $$Excel-Macros$$ Vlookup with total

kindly share a sample file with groups,,
Regards,
Gawli Anil
On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>> wrote:
Dear All,

I have an excel file for which, there is Incentive worked out based on 2-3 
parameters for the same Technician.

I want to do a vlookup with the total amount (of 2-3 amounts) against that 
person. Please help me with a formula.

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to 
excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.





--
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowle

Re: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread NOORAIN ANSARI

Dear Amit,

Please try,

=SUMPRODUCT(($A$3:$A$8=$E5)*($B$3:$B$8))

see attached sheet for more clarity


On Tue, Oct 23, 2012 at 1:06 PM, Amit Desai (MERU)
wrote:

>  Please find attached sample data file... I need Vlookup solution & not
> the Pivoting pls...
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> *From:* अनिल नारायण गवली [mailto:gawlianil8...@gmail.com]
> *Sent:* 23 October 2012 12:59
> *To:* excel-macros@googlegroups.com; Amit Desai (MERU)
> *Subject:* Re: $$Excel-Macros$$ Vlookup with total
>
> ** **
>
> kindly share a sample file with groups,,
>
> Regards,
>
> Gawli Anil
>
> On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) <
> amit.de...@merucabs.com> wrote:
>
> Dear All,
>
>  
>
> I have an excel file for which, there is Incentive worked out based on 2-3
> parameters for the same Technician.
>
>  
>
> I want to do a vlookup with the total amount (of 2-3 amounts) against that
> person. Please help me with a formula.
>
>  
>
> Best Regards,
>
> Amit
>
>  
>
> ** **
>  --
>
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibite

Re: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread Aamir Shahzad

 for sumproduct solution

=SUMPRODUCT(($A$3:$A$8=E5)*($B$3:$B$8))

On Tue, Oct 23, 2012 at 12:46 PM, Amit Desai (MERU)  wrote:

>  Pls share sum-product formula...
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* 23 October 2012 13:07
> *To:* excel-macros@googlegroups.com
>
> *Subject:* Re: $$Excel-Macros$$ Vlookup with total
>
> ** **
>
> Dear Amit,
>
> I think SUMPRODUCT will better than Vlookup.
> Pls share sample sheet for better clarity 
>
> On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) <
> amit.de...@merucabs.com> wrote:
>
> Dear All,
>
>  
>
> I have an excel file for which, there is Incentive worked out based on 2-3
> parameters for the same Technician.
>
>  
>
> I want to do a vlookup with the total amount (of 2-3 amounts) against that
> person. Please help me with a formula.
>
>  
>
> Best Regards,
>
> Amit
>
>  
>
> ** **
>  --
>
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
> 
>
> ** **
>
> ** **
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized

RE: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread Amit Desai (MERU)

Pls share sum-product formula...

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of NOORAIN ANSARI
Sent: 23 October 2012 13:07
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup with total

Dear Amit,

I think SUMPRODUCT will better than Vlookup.
Pls share sample sheet for better clarity
On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>> wrote:
Dear All,

I have an excel file for which, there is Incentive worked out based on 2-3 
parameters for the same Technician.

I want to do a vlookup with the total amount (of 2-3 amounts) against that 
person. Please help me with a formula.

Best Regards,
Amit

Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to 
excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

--
With Regards,
Noorain Ansari
http://noorainansari.com
http://excelvbaclinic.com

--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to 
excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any conte

Re: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread Aamir Shahzad

 use below formula

=SUMIF($A$3:$A$8,E5,$B$3:$B$8)

On Tue, Oct 23, 2012 at 12:36 PM, Amit Desai (MERU)  wrote:

>  Please find attached sample data file... I need Vlookup solution & not
> the Pivoting pls...
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> *From:* अनिल नारायण गवली [mailto:gawlianil8...@gmail.com]
> *Sent:* 23 October 2012 12:59
> *To:* excel-macros@googlegroups.com; Amit Desai (MERU)
> *Subject:* Re: $$Excel-Macros$$ Vlookup with total
>
> ** **
>
> kindly share a sample file with groups,,
>
> Regards,
>
> Gawli Anil
>
> On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) <
> amit.de...@merucabs.com> wrote:
>
> Dear All,
>
>  
>
> I have an excel file for which, there is Incentive worked out based on 2-3
> parameters for the same Technician.
>
>  
>
> I want to do a vlookup with the total amount (of 2-3 amounts) against that
> person. Please help me with a formula.
>
>  
>
> Best Regards,
>
> Amit
>
>  
>
> ** **
>  --
>
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Shari

RE: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread Amit Desai (MERU)

Please find attached sample data file... I need Vlookup solution & not the 
Pivoting pls...

Best Regards,
Amit

From: अनिल नारायण गवली [mailto:gawlianil8...@gmail.com]
Sent: 23 October 2012 12:59
To: excel-macros@googlegroups.com; Amit Desai (MERU)
Subject: Re: $$Excel-Macros$$ Vlookup with total

kindly share a sample file with groups,,
Regards,
Gawli Anil
On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>> wrote:
Dear All,

I have an excel file for which, there is Incentive worked out based on 2-3 
parameters for the same Technician.

I want to do a vlookup with the total amount (of 2-3 amounts) against that 
person. Please help me with a formula.

Best Regards,
Amit

Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to 
excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

--
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macro

Re: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread NOORAIN ANSARI

Dear Amit,

I think SUMPRODUCT will better than Vlookup.
Pls share sample sheet for better clarity

On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU)  wrote:

>  Dear All,
>
> ** **
>
> I have an excel file for which, there is Incentive worked out based on 2-3
> parameters for the same Technician.
>
> ** **
>
> I want to do a vlookup with the total amount (of 2-3 amounts) against that
> person. Please help me with a formula.
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread अनिल नारायण गवली

kindly share a sample file with groups,,
Regards,
Gawli Anil

On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU)  wrote:

>  Dear All,
>
> ** **
>
> I have an excel file for which, there is Incentive worked out based on 2-3
> parameters for the same Technician.
>
> ** **
>
> I want to do a vlookup with the total amount (of 2-3 amounts) against that
> person. Please help me with a formula.
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Vlookup with total

2012-10-23 Thread Amit Desai (MERU)

Dear All,

I have an excel file for which, there is Incentive worked out based on 2-3 
parameters for the same Technician.

I want to do a vlookup with the total amount (of 2-3 amounts) against that 
person. Please help me with a formula.

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Re: Text need in different collume

2012-10-23 Thread Manoj Kumar

Please confirm it is possible without macro

Regard
Manoj

On Tue, Oct 23, 2012 at 12:17 PM, Vabz  wrote:

>
> Hi
>
> PFA Att
>
> It contains various methods..
>
>
> Chherz//Vabz
>
> On Tuesday, October 23, 2012 11:19:06 AM UTC+5:30, Manoj Kumar wrote:
>>
>> Dear Expert,
>>
>>>
>>> I have data witch has Text and Number i want to do saperate text and
>>> number in next collume.
>>>
>>>  man25oj  kuma112r  ro444ha25n  25s26on7
>>>
>>>
>>>
>>> Regard
>>> Manoj
>>>
>>
>>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Re:Data Validation

Re: $$Excel-Macros$$ Macro Not working in shared Work Book

$$Excel-Macros$$ Macro Not working in shared Work Book

Re: $$Excel-Macros$$ Need your advise - MS Access 2007 drop down list Macro

$$Excel-Macros$$ Re: Vlookup with total

RE: $$Excel-Macros$$ MsgBox Query

Re: $$Excel-Macros$$ MsgBox Query

RE: $$Excel-Macros$$ Excel Graph Problem

RE: $$Excel-Macros$$ Re:Data Validation

RE: $$Excel-Macros$$ Re: Text need in different collume

RE: $$Excel-Macros$$ MsgBox Query

RE: $$Excel-Macros$$ Adding OR in between numbers using macro

RE: $$Excel-Macros$$ Trouble in 2007

Re: $$Excel-Macros$$ MsgBox Query

Re: $$Excel-Macros$$ Fwd: Dengue Fever - Useful Info.

Re: $$Excel-Macros$$ countif in hidden rows

Re: $$Excel-Macros$$ Arrow Symbol Solution in Excel

Re: $$Excel-Macros$$ Arrow Symbol Solution in Excel

$$Excel-Macros$$ Arrow Symbol Solution in Excel

$$Excel-Macros$$ Re: Text need in different collume

$$Excel-Macros$$ Re:Data Validation

RE: $$Excel-Macros$$ Vlookup with total

Re: $$Excel-Macros$$ Vlookup with total

Re: $$Excel-Macros$$ Vlookup with total

RE: $$Excel-Macros$$ Vlookup with total

Re: $$Excel-Macros$$ Vlookup with total

RE: $$Excel-Macros$$ Vlookup with total

Re: $$Excel-Macros$$ Vlookup with total

Re: $$Excel-Macros$$ Vlookup with total

$$Excel-Macros$$ Vlookup with total

Re: $$Excel-Macros$$ Re: Text need in different collume

31 matches

Site Navigation

Mail list logo

Footer information