Re: $$Excel-Macros$$ Format control percentage value

[amar takale]

One more question ask you what changes if 3D shading box clock & remove
click

On Sat, Sep 1, 2012 at 10:36 AM, amar takale  wrote:

> Dear Noorin,
> Thanks very much but i will ask you there are cell D6 & E6 depend on B6 &
> C6.Can there direct option to D6 & E6 in percentage bcos there are extra
> two cell B6 & C6 increased in numbers format it is compulsory to set in
> numbers format cell.I have may rows so every head like sales,ebit, pat to
> add two rows.
> If possible suggest any idea
> Regards
>
> Amar
>
>
> On Fri, Aug 31, 2012 at 6:32 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Amar,
>>
>> Please see attached sheet, Hope it will help to you.
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com
>>
>>
>> On Fri, Aug 31, 2012 at 5:18 PM, amar takale wrote:
>>
>>>
>>>  --
>>> 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$$ Format control percentage value

[amar takale]

Dear Noorin,
Thanks very much but i will ask you there are cell D6 & E6 depend on B6 &
C6.Can there direct option to D6 & E6 in percentage bcos there are extra
two cell B6 & C6 increased in numbers format it is compulsory to set in
numbers format cell.I have may rows so every head like sales,ebit, pat to
add two rows.
If possible suggest any idea
Regards

Amar

On Fri, Aug 31, 2012 at 6:32 PM, NOORAIN ANSARI wrote:

> Dear Amar,
>
> Please see attached sheet, Hope it will help to you.
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
> On Fri, Aug 31, 2012 at 5:18 PM, amar takale  wrote:
>
>>
>>  --
>> 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$$ Help on Formula

[Rajan_Verma]

=INDIRECT("'" & E2 & "'!B2")

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: 01 September 2012 10:35
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help on Formula

 


Dear All

 

Can anyone help me to write a formula.

 

Please find attached sheet.

 

Thanks in advance.
-- 
Shrini

-- 
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$$ Help on Formula

[Shrinivas Shevde]

Dear All

Can anyone help me to write a formula.

Please find attached sheet.

Thanks in advance.
-- 
Shrini

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




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

RE: $$Excel-Macros$$ Change Column Size

[Rajan_Verma]

Try to zoom your worksheet

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of mburkett
Sent: 31 August 2012 11:41
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Change Column Size

 

I am using a list with data validation in cells c64:c74. The choices are
very long text strings. Does anyone have code that will expand the column
width when I select any of the cells and return to original (or specific)
size once deselected? 

-- 
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$$ Need update on the attached Macro

[Selva]

Hi Mohan,

 

Thanks for your update. I couldn't find  where to insert your code.

Could you please insert your code 'If Target.Column <> Range("N1").Column
Then Exit Sub' in my below code. so as I could run thru' quickly.

Code:-

 Sub sendEmail()

Dim objOL As Object

Dim objMail As Object

Dim sEmail As String

Dim sEmailColumn As String

Dim sSubject As String

Dim sBody As String

Dim lDataRow As Long

Dim cl As Range

'Set column with email address

sEmailColumn = "Z"

 For Each cl In Selection.Resize(, 1)



lDataRow = cl.Row



If cl.Parent.Range("N" & lDataRow).Value = "Failure" Then

With cl.Parent

sEmail = .Range(sEmailColumn & lDataRow)

sSubject = Range("B" & lDataRow)

sBody = "URL/Test Condition: " & .Range("G" & lDataRow) &
vbNewLine & "Step A" 

End With



On Error GoTo Cleanup



Set objOL = CreateObject("Outlook.Application")



Set objMail = objOL.CreateItem(0)

With objMail

.To = sEmail

.Subject = sSubject

.Body = sBody

.Display

End With

End If

Next cl

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ?> lal?? ?sa??
Sent: 31 August 2012 21:55
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need update on the attached Macro

 

Just use this line of code before calling sendmail procedure

If Target.Column <> Range("N1").Column Then Exit Sub

Hope it helps you

Regards,
Lalit Mohan



On Fri, Aug 31, 2012 at 5:50 PM, Selva  wrote:

Hi All,

 

Need an update on the attached macro file. Based on this file, whenever the
Column N  drop down is selected for 'Failure', an outlook mail generates and
ready to be sent. If 'Success' is selected no mails will be sent. But my
issue is whenever I select for 'Failure' in Column O. Two mails are being
generated for Column N and for Column O. But I want to restrict it to one
mail for that cell which I have selected only. Can any one help me on this?

 

Code:-

 

Sub sendEmail()

 

Dim objOL As Object

Dim objMail As Object

Dim sEmail As String

Dim sEmailColumn As String

Dim sSubject As String

Dim sBody As String

Dim lDataRow As Long

Dim cl As Range

'Set column with email address

sEmailColumn = "Z"

 For Each cl In Selection.Resize(, 1)



lDataRow = cl.Row



If cl.Parent.Range("N" & lDataRow).Value = "Failure" Then

With cl.Parent

sEmail = .Range(sEmailColumn & lDataRow)

sSubject = Range("B" & lDataRow)

sBody = "URL/Test Condition: " & .Range("G" & lDataRow) &
vbNewLine & "Step A" 

End With



On Error GoTo Cleanup



Set objOL = CreateObject("Outlook.Application")



Set objMail = objOL.CreateItem(0)

With objMail

.To = sEmail

.Subject = sSubject

.Body = sBody

.Display

End With

End If

Next cl

For Each cl In Selection.Resize(, 1)



lDataRow = cl.Row



If cl.Parent.Range("O" & lDataRow).Value = "Failure" Then

With cl.Parent

sEmail = .Range(sEmailColumn & lDataRow)

sSubject = Range("B" & lDataRow)

sBody = "URL/Test Condition: " & .Range("G" & lDataRow) &
vbNewLine & "STEP B" & vbNewLine & ""

End With



On Error GoTo Cleanup



Set objOL = CreateObject("Outlook.Application")



Set objMail = objOL.CreateItem(0)

With objMail

.To = sEmail

.Subject = sSubject

.Body = sBody

.Display

End With

End If

Next cl

For Each cl In Selection.Resize(, 1)



lDataRow = cl.Row



If cl.Parent.Range("P" & lDataRow).Value = "Failure" Then

With cl.Parent

sEmail = .Range(sEmailColumn & lDataRow)

sSubject = Range("B" & lDataRow)

sBody = "URL/Test Condition: " & .Range("G" & lDataRow) &
vbNewLine & "STEP C" & vbNewLine & ""

End With



On Error GoTo Cleanup



Set objOL = CreateObject("Outlook.Application")



Set objMail = objOL.CreateItem(0)

With objMail

.To = sEmail

.Subject = sSubject

.Body = sBody

.Display

End With

End If

Next cl

For Each cl In Selection.Resize(, 1)



lDataRow = cl.Row

$$Excel-Macros$$ Gathering info from MySQL Bugzilla DB into Excel using VBA (is this even possible?)

[Marcus Polk]

If these questions have been answered elsewhere, the post is too long or 
you basically do not feel like reading it, please feel free to tell me so. 
I am typing it out, in hopes it helps someone. :-)

In all seriousness though, let me say that learning MySQL, SQL Server, 
Perl, Apache, Bugzilla, what ODBC is and Excel programming all at the same 
time, while in the long run will serve me well, is daunting right now. I am 
learning on my own, but thank God this support list is here, otherwise it 
would take me forever.

I am attempting to gather data into Excel (for charting or simple 
spreadsheets) from our MySQL Bugzilla database. The Bugzilla database is 
located on a newtwork server (installation and DB) and is basically farmed 
out, although my company (read "ME") has to manage it.

In order to be able to speak to the server, I had to create and ODBC 
connection, using MySQL connector (don't get me started on trying to 
understand the difference between User DSN, System DSN, ODB files, etc.). 
When attempting to create this connection, I had to connect to the actual 
server as is is not a localhost. I finally figured out that I had to 
designate the name of the server and then got an error that I could not 
conect.

Originally, I thought I could do something like the following;

GRANT USAGE ON *.* TO 'root'@'%' IDENTIFIED BY 'password!';

However, this did not work. I now believe it is because all of the 
privledges were set as "N". I then created a ROOT user with the same MySQL 
statement, using the IP address of my system (instead of %) and manually 
granted all the permissions, using MySQL Workbench queries. That worked. 
Now, I have 3 ROOT users. The one for "localhost", the one I created with 
"%" and the one I created with "my IP address".

I then attempted to use the Query Wizard in Excel 2010 to bring over what 
info I wanted to see in my spreadsheet. I now have the following questions 
about what I have done.

1. Does anyone know of a link to completely explain what a Pivot Table is?
2. If I switch all of the privledges for the ROOT user I created with "%", 
will I then be able to access the database through Excel, from any system, 
provided that system had the ODBC connection?
a. Basically, I need someone to be able to click a link and have the data 
they want, spit out into Excel. I won't be running these queries every time.
3. How do I delete all of the extra ROOT users I created, without deleting 
the main ROOT?
a. Is there a way to simply modify the existing ROOT account to work off of 
any other IP address?
b. Regarding the above, I am assuming it would be more secure, for me to 
create a user other than ROOT and grant that user the permissions needed to 
run the Excel queries.
4. If I want to run queries and dump the data into Excel, is it easier to 
run through the Query Wizard,, use VB code, use Excel code or a combination 
of all 3?
5. When I did connect to the database and attempted to get the data I 
wanted into Excel, I noticed that some of the data (assigned_to, 
product_id, component_id, etc.) are numbers. Is that because they need to 
be referenced by that number in another table? If so, how do I associate 
that data without the Excel query complaning that they aren't? How do I get 
the names of the items into my spreadsheet, instead of numbers?

I apologize this is long and I don't know if it will even get read, 
answered or even deleted. If anyone can only answer a part of it though, I 
would appreciate any info I could get. Thanks.

-- 
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$$ Change Column Size

[Paul Schreiner]

>From his description, I think he's looking for something like 
>a SelectionChange 
Event.
Where, when he selects the cell with the pull-down, it automatically changes 
the 
width of the column to ##.
Then, when a different cell is selected, the column returns to it's original 
width.
 
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: NOORAIN ANSARI 
To: excel-macros@googlegroups.com
Sent: Fri, August 31, 2012 2:33:54 PM
Subject: Re: $$Excel-Macros$$ Change Column Size

Without VBa Code
you can use..

Alt+O+C+A


On Fri, Aug 31, 2012 at 11:44 PM, NOORAIN ANSARI  
wrote:

Dear Mburket,
>
>You can use..
>
>
>Sub column_fit()
>Cells.Columns.AutoFit
>End Sub 
>
>
>
>On Fri, Aug 31, 2012 at 11:41 PM, mburkett  wrote:
>
>I am using a list with data validation in cells c64:c74. The choices are very 
>long text strings. Does anyone have code that will expand the column width 
>when 
>I select any of the cells and return to original (or specific) size once 
>deselected? -- 
>
>>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 
>
>
>
>


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

-- 
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$$ please help me to solve this question it's very urgent

[dguillett1]

The "team" will be happier to help if you use a meaningful subject line and 
lose the URGENT!!!




Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: PRAVESH KUMAR

Sent: Friday, August 31, 2012 1:09 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ please help me to solve this question it's 
very urgent


Hi team,


Thanks so much for help me and give best to best Suggestions

Thanks
Pravesh Kumar


On 8/30/12, Kuldeep Singh  wrote:

Dear Preavesh,

04 solutions of you. for any query please see attachment.

=LOOKUP(H3,$C$3:$D$9)
=VLOOKUP(H3:H6,$C$3:$D$9,2,0)
=VLOOKUP(H3,$C$3:$D$9,2,0)
=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))

Regards,
Kuldeep Singh

On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya
wrote:


Hi Pravesh,

Find the attached solved file.

=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))

Reagrds
Amresh

On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
vaishpriyanka2...@gmail.com> wrote:


Hi Pravesh,

  =VLOOKUP($H3,$C$3:$D$9,2,0)

I think this formula would solve your question.

On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
 wrote:


Hi Team,

please help me to solve this question it's very urgent


waiting your response



--

Thanks & Regards

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





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

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

[PRAVESH KUMAR]

Hi amresh,

Thanks! for help me


On 8/30/12, Amresh Maurya  wrote:
> Hi Pravesh,
>
> Find the attached solved file.
>
> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>
> Reagrds
> Amresh
>
> On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
> vaishpriyanka2...@gmail.com> wrote:
>
>> Hi Pravesh,
>>
>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
>>
>> I think this formula would solve your question.
>>
>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
>> wrote:
>>
>>> Hi Team,
>>>
>>> please help me to solve this question it's very urgent
>>>
>>>
>>> waiting your response
>>>
>>>
>>>
>>> --
>>>
>>> Thanks & Regards
>>>
>>> Pravesh 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.
>>
>>
>>
>
> --
> 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

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

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] please help me to solve this question it's very urgent

[PRAVESH KUMAR]

Hi Noorain,

Thanks a lot of !

search best to best solution.


Thanks
Pravesh


On 8/30/12, NOORAIN ANSARI  wrote:
> Dear Pravesh,
>
> See attached sheet for more clarity.
>
>
> --
> With Regards,
> Noorain Ansari
> http://
> noorainansari.com
> http://
> excelvbaclinic.com
>
>
>
> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
> wrote:
>
>> Hi Team,
>>
>> please help me to solve this question it's very urgent
>>
>>
>> waiting your response
>>
>>
>>
>> --
>>
>> Thanks & Regards
>>
>> Pravesh 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.
>
>
>


-- 

Thanks & Regards

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

Re: $$Excel-Macros$$ Change Column Size

[Paul Schreiner]

Have you looked at a SelectionChange event?
You'd have to test to see if the target range is the cell you're trying to 
adjust.
 
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: mburkett 
To: excel-macros@googlegroups.com
Sent: Fri, August 31, 2012 2:25:31 PM
Subject: Re: $$Excel-Macros$$ Change Column Size

I need it to expand automatically when I select the cell and then return to 
original width after the cell is not selected.

On Friday, August 31, 2012 2:15:08 PM UTC-4, NOORAIN ANSARI wrote: 
Dear Mburket,
>
>You can use..
>
>
>Sub column_fit()
>Cells.Columns.AutoFit
>End Sub
>
>
>On Fri, Aug 31, 2012 at 11:41 PM, mburkett  wrote:
>
>I am using a list with data validation in cells c64:c74. The choices are very 
>long text strings. Does anyone have code that will expand the column width 
>when 
>I select any of the cells and return to original (or specific) size once 
>deselected? -- 
>
>>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.
>> 
>> 
>>
>
>
>-- 
>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.

-- 
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$$ Change Column Size

[mburkett]

I need it to expand automatically when I select the cell and then return to 
original width after the cell is not selected.

On Friday, August 31, 2012 2:15:08 PM UTC-4, NOORAIN ANSARI wrote:
>
> Dear Mburket,
>
> You can use..
>
>
> Sub column_fit()
> Cells.Columns.AutoFit
> End Sub
>
> On Fri, Aug 31, 2012 at 11:41 PM, mburkett 
> > wrote:
>
>> I am using a list with data validation in cells c64:c74. The choices are 
>> very long text strings. Does anyone have code that will expand the column 
>> width when I select any of the cells and return to original (or specific) 
>> size once deselected? 
>>
>> -- 
>> 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 .
>>  
>>  
>>
>
>
>
> -- 
> 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$$ Change Column Size

[Kuldeep Singh]

Hi Mburket,

Shortcut key: Alt+H+O+I use only Excel 2007, 2010, 2013 Preview.

Regards,
Kuldeep Singh

On Fri, Aug 31, 2012 at 11:48 PM, NOORAIN ANSARI
wrote:

> Without VBa Code
> you can use..
>
> Alt+O+C+A
>
>
> On Fri, Aug 31, 2012 at 11:44 PM, NOORAIN ANSARI  > wrote:
>
>> Dear Mburket,
>>
>> You can use..
>>
>>
>> Sub column_fit()
>> Cells.Columns.AutoFit
>> End Sub
>>
>>
>> On Fri, Aug 31, 2012 at 11:41 PM, mburkett wrote:
>>
>>> I am using a list with data validation in cells c64:c74. The choices are
>>> very long text strings. Does anyone have code that will expand the column
>>> width when I select any of the cells and return to original (or specific)
>>> size once deselected?
>>>
>>> --
>>> 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
>>
>>
>>
>
>
> --
> 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.
>

-- 
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$$ Change Column Size

[NOORAIN ANSARI]

Without VBa Code
you can use..

Alt+O+C+A

On Fri, Aug 31, 2012 at 11:44 PM, NOORAIN ANSARI
wrote:

> Dear Mburket,
>
> You can use..
>
>
> Sub column_fit()
> Cells.Columns.AutoFit
> End Sub
>
>
> On Fri, Aug 31, 2012 at 11:41 PM, mburkett wrote:
>
>> I am using a list with data validation in cells c64:c74. The choices are
>> very long text strings. Does anyone have code that will expand the column
>> width when I select any of the cells and return to original (or specific)
>> size once deselected?
>>
>> --
>> 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
>
>
>


-- 
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$$ Change Column Size

[NOORAIN ANSARI]

Dear Mburket,

You can use..


Sub column_fit()
Cells.Columns.AutoFit
End Sub

On Fri, Aug 31, 2012 at 11:41 PM, mburkett  wrote:

> I am using a list with data validation in cells c64:c74. The choices are
> very long text strings. Does anyone have code that will expand the column
> width when I select any of the cells and return to original (or specific)
> size once deselected?
>
> --
> 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$$ please help me to solve this question it's very urgent

[Kuldeep Singh]

Dear Pravesh,

Your most welcome.

Regards,
Kuldeep Singh

On Fri, Aug 31, 2012 at 11:39 PM, PRAVESH KUMAR wrote:

> Hi team,
>
>
> Thanks so much for help me and give best to best Suggestions
>
> Thanks
> Pravesh Kumar
>
>
> On 8/30/12, Kuldeep Singh  wrote:
> > Dear Preavesh,
> >
> > 04 solutions of you. for any query please see attachment.
> >
> > =LOOKUP(H3,$C$3:$D$9)
> > =VLOOKUP(H3:H6,$C$3:$D$9,2,0)
> > =VLOOKUP(H3,$C$3:$D$9,2,0)
> > =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
> >
> > Regards,
> > Kuldeep Singh
> >
> > On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya
> > wrote:
> >
> >> Hi Pravesh,
> >>
> >> Find the attached solved file.
> >>
> >> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
> >>
> >> Reagrds
> >> Amresh
> >>
> >> On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
> >> vaishpriyanka2...@gmail.com> wrote:
> >>
> >>> Hi Pravesh,
> >>>
> >>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
> >>>
> >>> I think this formula would solve your question.
> >>>
> >>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
> >>>  >>> > wrote:
> >>>
>  Hi Team,
> 
>  please help me to solve this question it's very urgent
> 
> 
>  waiting your response
> 
> 
> 
>  --
> 
>  Thanks & Regards
> 
>  Pravesh 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.
> >>>
> >>>
> >>>
> >>
> >>  --
> >> 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
> >> o

$$Excel-Macros$$ Change Column Size

[mburkett]

I am using a list with data validation in cells c64:c74. The choices are 
very long text strings. Does anyone have code that will expand the column 
width when I select any of the cells and return to original (or specific) 
size once deselected?

-- 
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$$ please help me to solve this question it's very urgent

[PRAVESH KUMAR]

Hi team,


Thanks so much for help me and give best to best Suggestions

Thanks
Pravesh Kumar


On 8/30/12, Kuldeep Singh  wrote:
> Dear Preavesh,
>
> 04 solutions of you. for any query please see attachment.
>
> =LOOKUP(H3,$C$3:$D$9)
> =VLOOKUP(H3:H6,$C$3:$D$9,2,0)
> =VLOOKUP(H3,$C$3:$D$9,2,0)
> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>
> Regards,
> Kuldeep Singh
>
> On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya
> wrote:
>
>> Hi Pravesh,
>>
>> Find the attached solved file.
>>
>> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>>
>> Reagrds
>> Amresh
>>
>> On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
>> vaishpriyanka2...@gmail.com> wrote:
>>
>>> Hi Pravesh,
>>>
>>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
>>>
>>> I think this formula would solve your question.
>>>
>>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
>>> >> > wrote:
>>>
 Hi Team,

 please help me to solve this question it's very urgent


 waiting your response



 --

 Thanks & Regards

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

$$Excel-Macros$$ Re: Transpose (Arr) problem with Dates

[RLM]

Thanks for the help

On Thursday, August 30, 2012 6:57:37 PM UTC+1, RLM wrote:
>
> First post guys!
>
> I am trying to convert dates stored as text into proper formatted UK dates 
> DD/MM/.  A sample spreadsheet is attached.   The dates as text are 
> copied into a variant array, converted to a real date using DateSerial then 
> copied to a new range using the WorksheetFunction.Transpose.   The dates 
> look formatted ok whilst viewing the locals in the RealDate array, but but 
> when copied back to the new range 05/04/2012 becomes 04/05/2012.
>
> I want to avoid looping through each individual cell so grateful if 
> someone could provide a solution.
>
> Many thanks
>
>
>
>
>
>

-- 
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: Combining variables with Excel Formulas

[mburkett]

Perfect! Thank you for your help.

On Friday, August 31, 2012 12:09:50 PM UTC-4, mburkett wrote:
>
> I have some code that is not working as I expected. I set a variable from 
> a value in a cell within the worksheet and add a countif formula. The 
> result I get in the cell is the variable along with the formula as written 
> (as opposed to the result of the formula). Ideas?
>
> 'set variable
> indname = Selection.Value
> ActiveCell.FormulaR1C1 = indname & "+=COUNTIF(Stocks!C[-2]:C,Main!RC[-2])"
> 'Here is the result in the cell: LC Consumer Staples Sector 
> +=COUNTIF(Stocks!C[-2]:C,Main!RC[-2])
>

-- 
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: Error in 2010

[Lalit Mohan Pandey]

This is the message by microsoft just to inform to that your file contain 
macros. so either use .xls or .xlsm or .xlsb to save the file without 
message or just press yes to make it macro enable workbook.

Regards,
Lalit Mohan

On Friday, 31 August 2012 13:28:23 UTC+2, Chidurala, Shrinivas wrote:
>
> Dear All,
>
>  
>
> I am face the attached Error in 2010 while saving active workbook on 
> recording macro.
>
>  
>
>  
>
> Regards,
>
> Shrinivas
>
>  
>
>  
>

-- 
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$$ Combining variables with Excel Formulas

[Ojemeni Uzoma]

Ojemeni Uzoma | Call 08060700717

-Original Message-
From: Paul Schreiner 
Sender: excel-macros@googlegroups.com
Date: Fri, 31 Aug 2012 10:04:52 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Combining variables with Excel Formulas

Your result is exactly what you told Excel to do.
when you put something in quotes ("), you're telling Excel to "take this string 
LITERALLY"
and do not "evaluate" the string.
So you basically said to set the cell value to the value of 'indname' and 
append a string.

You might as well say:
activecell.value = indname & " Excel is Fun!"

So, the problem is with the syntax.

What I would suggest that you do is manually enter the countif into a cell.

Something like:
=COUNTIF(Data!B2:B100,A4)
(using the appropriate ranges)

Then, "prefix" the cell formula with something like: "Test_Title:"
="Test_Title:" & COUNTIF(Data!B2:B100,A4)

Next,  Fire up the Macro Recorder.
Simply click inside the formula and hit "enter".
(You don't really need to change anything)
Stop Recording and look at the macro.

You'll see a formula that looks something like:

ActiveCell.FormulaR1C1 = _
    "=""Test_Title:"" & COUNTIF(Data!R[-3]C[-36]:R[96]C[-36],RC[-37])"

(your values will vary)

Now, replace "Test_Title" with your  variable "indname"

Now, the problem here is that you want VBA to substitute the VALUE of "indname"
But you need the quotes (") in Excel.
So you'll actually have to add a couple of quotes.

Note:  "=" means to add a literal string EQUAL SIGN
But how do you add a double-quote? (")
The trick here is that "special" characters like this are represented by using 
them twice:
"" will represent a single (").
But """ doesn't work, because VBA interprets it as an OPEN delimiter, then 
a quote string, and no closing delimiter.
So, actually to enter a double-quote, it takes (4) of them ()
this is (open delimiter)"(close delimiter)
if you want to include an equal sign (=) then it's: (open delimiter)="(close 
delimiter)
or "="""

so your resulting macro code looks like:

    ActiveCell.FormulaR1C1 = _
    "=""" & indname & """ & COUNTIF(Data!R[-3]C[-36]:R[96]C[-36],RC[-37])"

in your example, it would probably be:

ActiveCell.FormulaR1C1 = "=""" & indname & """ & 
COUNTIF(Stocks!C[-2]:C,Main!RC[-2])"

although I cannot test it.
--
OK, I COULD have simply given you the syntax correction, but how can you learn 
anything from 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: mburkett 
To: excel-macros@googlegroups.com
Sent: Fri, August 31, 2012 12:38:20 PM
Subject: $$Excel-Macros$$ Combining variables with Excel Formulas

I have some code that is not working as I expected. I set a variable from a 
value in a cell within the worksheet and add a countif formula. The result I 
get 
in the cell is the variable along with the formula as written (as opposed to 
the 
result of the formula). Ideas?


'set variable
indname = Selection.Value

ActiveCell.FormulaR1C1 = indname & "+=COUNTIF(Stocks!C[-2]:C,Main!RC[-2])"

'Here is the result in the cell: LC Consumer Staples Sector 
+=COUNTIF(Stocks!C[-2]:C,Main!RC[-2])-- 

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

$$Excel-Macros$$ Re: Combining variables with Excel Formulas

[mburkett]

I wish I could but it has proprietary data. Here is a little clarification
The variable indname is set by going to a specific cell that has some text 
(exable below)

Range("A1").Select
indname = Selection.Value

This sets the variable indname which is some text

>From there I goto another cell where I need to combine the name of the 
variable (indname) and a number generated from a countif formula


On Friday, August 31, 2012 12:30:07 PM UTC-4, Lalit Mohan Pandey wrote:
>
> can you please attach file in which you want to do this to make it more 
> understandable
>
> Regards,
> Lalit Mohan
>
> On Friday, 31 August 2012 18:09:50 UTC+2, mburkett wrote:
>>
>> I have some code that is not working as I expected. I set a variable from 
>> a value in a cell within the worksheet and add a countif formula. The 
>> result I get in the cell is the variable along with the formula as written 
>> (as opposed to the result of the formula). Ideas?
>>
>> 'set variable
>> indname = Selection.Value
>> ActiveCell.FormulaR1C1 = indname & "+=COUNTIF(Stocks!C[-2]:C,Main!RC[-2])"
>> 'Here is the result in the cell: LC Consumer Staples Sector 
>> +=COUNTIF(Stocks!C[-2]:C,Main!RC[-2])
>>
>

-- 
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$$ Combining variables with Excel Formulas

[Paul Schreiner]

Your result is exactly what you told Excel to do.
when you put something in quotes ("), you're telling Excel to "take this string 
LITERALLY"
and do not "evaluate" the string.
So you basically said to set the cell value to the value of 'indname' and 
append a string.

You might as well say:
activecell.value = indname & " Excel is Fun!"

So, the problem is with the syntax.

What I would suggest that you do is manually enter the countif into a cell.

Something like:
=COUNTIF(Data!B2:B100,A4)
(using the appropriate ranges)

Then, "prefix" the cell formula with something like: "Test_Title:"
="Test_Title:" & COUNTIF(Data!B2:B100,A4)

Next,  Fire up the Macro Recorder.
Simply click inside the formula and hit "enter".
(You don't really need to change anything)
Stop Recording and look at the macro.

You'll see a formula that looks something like:

ActiveCell.FormulaR1C1 = _
    "=""Test_Title:"" & COUNTIF(Data!R[-3]C[-36]:R[96]C[-36],RC[-37])"

(your values will vary)

Now, replace "Test_Title" with your  variable "indname"

Now, the problem here is that you want VBA to substitute the VALUE of "indname"
But you need the quotes (") in Excel.
So you'll actually have to add a couple of quotes.

Note:  "=" means to add a literal string EQUAL SIGN
But how do you add a double-quote? (")
The trick here is that "special" characters like this are represented by using 
them twice:
"" will represent a single (").
But """ doesn't work, because VBA interprets it as an OPEN delimiter, then 
a quote string, and no closing delimiter.
So, actually to enter a double-quote, it takes (4) of them ()
this is (open delimiter)"(close delimiter)
if you want to include an equal sign (=) then it's: (open delimiter)="(close 
delimiter)
or "="""

so your resulting macro code looks like:

    ActiveCell.FormulaR1C1 = _
    "=""" & indname & """ & COUNTIF(Data!R[-3]C[-36]:R[96]C[-36],RC[-37])"

in your example, it would probably be:

ActiveCell.FormulaR1C1 = "=""" & indname & """ & 
COUNTIF(Stocks!C[-2]:C,Main!RC[-2])"

although I cannot test it.
--
OK, I COULD have simply given you the syntax correction, but how can you learn 
anything from 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: mburkett 
To: excel-macros@googlegroups.com
Sent: Fri, August 31, 2012 12:38:20 PM
Subject: $$Excel-Macros$$ Combining variables with Excel Formulas

I have some code that is not working as I expected. I set a variable from a 
value in a cell within the worksheet and add a countif formula. The result I 
get 
in the cell is the variable along with the formula as written (as opposed to 
the 
result of the formula). Ideas?


'set variable
indname = Selection.Value

ActiveCell.FormulaR1C1 = indname & "+=COUNTIF(Stocks!C[-2]:C,Main!RC[-2])"

'Here is the result in the cell: LC Consumer Staples Sector 
+=COUNTIF(Stocks!C[-2]:C,Main!RC[-2])-- 

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

$$Excel-Macros$$ Re: Need update on the attached Macro

[Lalit Mohan Pandey]

Not in SendMail procedure just paste this line in worksheet_change event 
procedure from where you calling sendmail procedure

Regards,
Lalit Mohan

On Friday, 31 August 2012 18:02:02 UTC+2, selva wrote:
>
>  Hi All,
>
>  
>
> Need an update on the attached macro file. Based on this file, whenever 
> the Column N  drop down is selected for ‘Failure’, an outlook mail 
> generates and ready to be sent. If ‘Success’ is selected no mails will be 
> sent. But my issue is whenever I select for ‘Failure’ in Column O. Two 
> mails are being generated for Column N and for Column O. But I want to 
> restrict it to one mail for that cell which I have selected only. Can any 
> one help me on this?
>
>  
>
> Code:-
>
>  
>
> Sub sendEmail()
>
>  
>
> Dim objOL As Object
>
> Dim objMail As Object
>
> Dim sEmail As String
>
> Dim sEmailColumn As String
>
> Dim sSubject As String
>
> Dim sBody As String
>
> Dim lDataRow As Long
>
> Dim cl As Range
>
> 'Set column with email address
>
> sEmailColumn = "Z"
>
>  For Each cl In Selection.Resize(, 1)
>
> 
>
> lDataRow = cl.Row
>
> 
>
> If cl.Parent.Range("N" & lDataRow).Value = "Failure" Then
>
> With cl.Parent
>
> sEmail = .Range(sEmailColumn & lDataRow)
>
> sSubject = Range("B" & lDataRow)
>
> sBody = "URL/Test Condition: " & .Range("G" & lDataRow) & 
> vbNewLine & "Step A" 
>
> End With
>
> 
>
> On Error GoTo Cleanup
>
> 
>
> Set objOL = CreateObject("Outlook.Application")
>
> 
>
> Set objMail = objOL.CreateItem(0)
>
> With objMail
>
> .To = sEmail
>
> .Subject = sSubject
>
> .Body = sBody
>
> .Display
>
> End With
>
> End If
>
> Next cl
>
> For Each cl In Selection.Resize(, 1)
>
> 
>
> lDataRow = cl.Row
>
> 
>
> If cl.Parent.Range("O" & lDataRow).Value = "Failure" Then
>
> With cl.Parent
>
> sEmail = .Range(sEmailColumn & lDataRow)
>
> sSubject = Range("B" & lDataRow)
>
> sBody = "URL/Test Condition: " & .Range("G" & lDataRow) & 
> vbNewLine & "STEP B" & vbNewLine & ""
>
> End With
>
> 
>
> On Error GoTo Cleanup
>
> 
>
> Set objOL = CreateObject("Outlook.Application")
>
> 
>
> Set objMail = objOL.CreateItem(0)
>
> With objMail
>
> .To = sEmail
>
> .Subject = sSubject
>
> .Body = sBody
>
> .Display
>
> End With
>
> End If
>
> Next cl
>
> For Each cl In Selection.Resize(, 1)
>
> 
>
> lDataRow = cl.Row
>
> 
>
> If cl.Parent.Range("P" & lDataRow).Value = "Failure" Then
>
> With cl.Parent
>
> sEmail = .Range(sEmailColumn & lDataRow)
>
> sSubject = Range("B" & lDataRow)
>
> sBody = "URL/Test Condition: " & .Range("G" & lDataRow) & 
> vbNewLine & "STEP C" & vbNewLine & ""
>
> End With
>
> 
>
> On Error GoTo Cleanup
>
> 
>
> Set objOL = CreateObject("Outlook.Application")
>
> 
>
> Set objMail = objOL.CreateItem(0)
>
> With objMail
>
> .To = sEmail
>
> .Subject = sSubject
>
> .Body = sBody
>
> .Display
>
> End With
>
> End If
>
> Next cl
>
> For Each cl In Selection.Resize(, 1)
>
> 
>
> lDataRow = cl.Row
>
> 
>
> If cl.Parent.Range("Q" & lDataRow).Value = "Failure" Then
>
> With cl.Parent
>
> sEmail = .Range(sEmailColumn & lDataRow)
>
> sSubject = Range("B" & lDataRow)
>
> sBody = "URL/Test Condition: " & .Range("G" & lDataRow) & 
> vbNewLine & "STEP D" & vbNewLine & ""
>
> End With
>
> 
>
> On Error GoTo Cleanup
>
> 
>
> Set objOL = CreateObject("Outlook.Application")
>
> 
>
> Set objMail = objOL.CreateItem(0)
>
> With objMail
>
> .To = sEmail
>
> .Subject = sSubject
>
> .Body = sBody
>
> .Display
>
> End With
>
> End If
>
> Next cl
>
>  
>
> Regards,**
>
> Selva Jayapal**
>
> Accenture - IDC, Chennai
>
> PMO - Operations
>
> Desk - +91 44 426 70619
>
> Mobile - +91 7708658033
>
> Office Communicator : selva.jaya...@accenture.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,

RE: $$Excel-Macros$$ Need update on the attached Macro

[Selva]

Hi Mohan,

 

Thanks for your update. I couldn’t find  where to insert your code.

Could you insert your code ‘If Target.Column <> Range("N1").Column Then Exit 
Sub’ in my below code. so as I could run thru quickly.

Code:-

 Sub sendEmail()

Dim objOL As Object

Dim objMail As Object

Dim sEmail As String

Dim sEmailColumn As String

Dim sSubject As String

Dim sBody As String

Dim lDataRow As Long

Dim cl As Range

'Set column with email address

sEmailColumn = "Z"

 For Each cl In Selection.Resize(, 1)



lDataRow = cl.Row



If cl.Parent.Range("N" & lDataRow).Value = "Failure" Then

With cl.Parent

sEmail = .Range(sEmailColumn & lDataRow)

sSubject = Range("B" & lDataRow)

sBody = "URL/Test Condition: " & .Range("G" & lDataRow) & 
vbNewLine & "Step A" 

End With



On Error GoTo Cleanup



Set objOL = CreateObject("Outlook.Application")



Set objMail = objOL.CreateItem(0)

With objMail

.To = sEmail

.Subject = sSubject

.Body = sBody

.Display

End With

End If

Next cl

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of ?» lal?? ?sa??
Sent: 31 August 2012 21:55
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need update on the attached Macro

 

Just use this line of code before calling sendmail procedure

If Target.Column <> Range("N1").Column Then Exit Sub

Hope it helps you

Regards,
Lalit Mohan



On Fri, Aug 31, 2012 at 5:50 PM, Selva  wrote:

Hi All,

 

Need an update on the attached macro file. Based on this file, whenever the 
Column N  drop down is selected for ‘Failure’, an outlook mail generates and 
ready to be sent. If ‘Success’ is selected no mails will be sent. But my issue 
is whenever I select for ‘Failure’ in Column O. Two mails are being generated 
for Column N and for Column O. But I want to restrict it to one mail for that 
cell which I have selected only. Can any one help me on this?

 

Code:-

 

Sub sendEmail()

 

Dim objOL As Object

Dim objMail As Object

Dim sEmail As String

Dim sEmailColumn As String

Dim sSubject As String

Dim sBody As String

Dim lDataRow As Long

Dim cl As Range

'Set column with email address

sEmailColumn = "Z"

 For Each cl In Selection.Resize(, 1)



lDataRow = cl.Row



If cl.Parent.Range("N" & lDataRow).Value = "Failure" Then

With cl.Parent

sEmail = .Range(sEmailColumn & lDataRow)

sSubject = Range("B" & lDataRow)

sBody = "URL/Test Condition: " & .Range("G" & lDataRow) & 
vbNewLine & "Step A" 

End With



On Error GoTo Cleanup



Set objOL = CreateObject("Outlook.Application")



Set objMail = objOL.CreateItem(0)

With objMail

.To = sEmail

.Subject = sSubject

.Body = sBody

.Display

End With

End If

Next cl

For Each cl In Selection.Resize(, 1)



lDataRow = cl.Row



If cl.Parent.Range("O" & lDataRow).Value = "Failure" Then

With cl.Parent

sEmail = .Range(sEmailColumn & lDataRow)

sSubject = Range("B" & lDataRow)

sBody = "URL/Test Condition: " & .Range("G" & lDataRow) & 
vbNewLine & "STEP B" & vbNewLine & ""

End With



On Error GoTo Cleanup



Set objOL = CreateObject("Outlook.Application")



Set objMail = objOL.CreateItem(0)

With objMail

.To = sEmail

.Subject = sSubject

.Body = sBody

.Display

End With

End If

Next cl

For Each cl In Selection.Resize(, 1)



lDataRow = cl.Row



If cl.Parent.Range("P" & lDataRow).Value = "Failure" Then

With cl.Parent

sEmail = .Range(sEmailColumn & lDataRow)

sSubject = Range("B" & lDataRow)

sBody = "URL/Test Condition: " & .Range("G" & lDataRow) & 
vbNewLine & "STEP C" & vbNewLine & ""

End With



On Error GoTo Cleanup



Set objOL = CreateObject("Outlook.Application")



Set objMail = objOL.CreateItem(0)

With objMail

.To = sEmail

.Subject = sSubject

.Body = sBody

.Display

End With

End If

Next cl

For Each cl In Selection.Resize(, 1)



lDataRow = cl.Row

$$Excel-Macros$$ Re: Combining variables with Excel Formulas

[Lalit_Mohan]

can you please attach file in which you want to do this to make it more 
understandable

Regards,
Lalit Mohan

On Friday, 31 August 2012 18:09:50 UTC+2, mburkett wrote:
>
> I have some code that is not working as I expected. I set a variable from 
> a value in a cell within the worksheet and add a countif formula. The 
> result I get in the cell is the variable along with the formula as written 
> (as opposed to the result of the formula). Ideas?
>
> 'set variable
> indname = Selection.Value
> ActiveCell.FormulaR1C1 = indname & "+=COUNTIF(Stocks!C[-2]:C,Main!RC[-2])"
> 'Here is the result in the cell: LC Consumer Staples Sector 
> +=COUNTIF(Stocks!C[-2]:C,Main!RC[-2])
>

-- 
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 update on the attached Macro

[╰» ℓαℓιт мσαнη]

Just use this line of code before calling sendmail procedure

If Target.Column <> Range("N1").Column Then Exit Sub

Hope it helps you

Regards,
Lalit Mohan


On Fri, Aug 31, 2012 at 5:50 PM, Selva  wrote:

>  Hi All,
>
> ** **
>
> Need an update on the attached macro file. Based on this file, whenever
> the Column N  drop down is selected for ‘Failure’, an outlook mail
> generates and ready to be sent. If ‘Success’ is selected no mails will be
> sent. But my issue is whenever I select for ‘Failure’ in Column O. Two
> mails are being generated for Column N and for Column O. But I want to
> restrict it to one mail for that cell which I have selected only. Can any
> one help me on this?
>
> ** **
>
> Code:-
>
> ** **
>
> Sub sendEmail()
>
> ** **
>
> Dim objOL As Object
>
> Dim objMail As Object
>
> Dim sEmail As String
>
> Dim sEmailColumn As String
>
> Dim sSubject As String
>
> Dim sBody As String
>
> Dim lDataRow As Long
>
> Dim cl As Range
>
> 'Set column with email address
>
> sEmailColumn = "Z"
>
>  For Each cl In Selection.Resize(, 1)
>
> 
>
> lDataRow = cl.Row
>
> 
>
> If cl.Parent.Range("N" & lDataRow).Value = "Failure" Then
>
> With cl.Parent
>
> sEmail = .Range(sEmailColumn & lDataRow)
>
> sSubject = Range("B" & lDataRow)
>
> sBody = "URL/Test Condition: " & .Range("G" & lDataRow) &
> vbNewLine & "Step A" 
>
> End With
>
> 
>
> On Error GoTo Cleanup
>
> 
>
> Set objOL = CreateObject("Outlook.Application")
>
> 
>
> Set objMail = objOL.CreateItem(0)
>
> With objMail
>
> .To = sEmail
>
> .Subject = sSubject
>
> .Body = sBody
>
> .Display
>
> End With
>
> End If
>
> Next cl
>
> For Each cl In Selection.Resize(, 1)
>
> 
>
> lDataRow = cl.Row
>
> 
>
> If cl.Parent.Range("O" & lDataRow).Value = "Failure" Then
>
> With cl.Parent
>
> sEmail = .Range(sEmailColumn & lDataRow)
>
> sSubject = Range("B" & lDataRow)
>
> sBody = "URL/Test Condition: " & .Range("G" & lDataRow) &
> vbNewLine & "STEP B" & vbNewLine & ""
>
> End With
>
> 
>
> On Error GoTo Cleanup
>
> 
>
> Set objOL = CreateObject("Outlook.Application")
>
> 
>
> Set objMail = objOL.CreateItem(0)
>
> With objMail
>
> .To = sEmail
>
> .Subject = sSubject
>
> .Body = sBody
>
> .Display
>
> End With
>
> End If
>
> Next cl
>
> For Each cl In Selection.Resize(, 1)
>
> 
>
> lDataRow = cl.Row
>
> 
>
> If cl.Parent.Range("P" & lDataRow).Value = "Failure" Then
>
> With cl.Parent
>
> sEmail = .Range(sEmailColumn & lDataRow)
>
> sSubject = Range("B" & lDataRow)
>
> sBody = "URL/Test Condition: " & .Range("G" & lDataRow) &
> vbNewLine & "STEP C" & vbNewLine & ""
>
> End With
>
> 
>
> On Error GoTo Cleanup
>
> 
>
> Set objOL = CreateObject("Outlook.Application")
>
> 
>
> Set objMail = objOL.CreateItem(0)
>
> With objMail
>
> .To = sEmail
>
> .Subject = sSubject
>
> .Body = sBody
>
> .Display
>
> End With
>
> End If
>
> Next cl
>
> For Each cl In Selection.Resize(, 1)
>
> 
>
> lDataRow = cl.Row
>
> 
>
> If cl.Parent.Range("Q" & lDataRow).Value = "Failure" Then
>
> With cl.Parent
>
> sEmail = .Range(sEmailColumn & lDataRow)
>
> sSubject = Range("B" & lDataRow)
>
> sBody = "URL/Test Condition: " & .Range("G" & lDataRow) &
> vbNewLine & "STEP D" & vbNewLine & ""
>
> End With
>
> 
>
> On Error GoTo Cleanup
>
> 
>
> Set objOL = CreateObject("Outlook.Application")
>
> 
>
> Set objMail = objOL.CreateItem(0)
>
> With objMail
>
> .To = sEmail
>
> .Subject = sSubject
>
> .Body = sBody
>
> .Display
>
> End With
>
> End If
>
> Next cl
>
> 

$$Excel-Macros$$ Combining variables with Excel Formulas

[mburkett]

I have some code that is not working as I expected. I set a variable from a 
value in a cell within the worksheet and add a countif formula. The result 
I get in the cell is the variable along with the formula as written (as 
opposed to the result of the formula). Ideas?

'set variable
indname = Selection.Value
ActiveCell.FormulaR1C1 = indname & "+=COUNTIF(Stocks!C[-2]:C,Main!RC[-2])"
'Here is the result in the cell: LC Consumer Staples Sector 
+=COUNTIF(Stocks!C[-2]:C,Main!RC[-2])

-- 
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$$ Number into hr:mm;ss

[Paul Schreiner]

We don't really have enough information.

hh:mm:ss is actually a TIME OF DAY display format.

As you probably already know, Excel stores date and time as a number.
the date is the number of days from 1/1/1900
(so 31-Aug-2012 is 41152)
"time" is actually the fractional part of a day.
at 6:00AM, 1/4 of the day is complete, so the "time" is .5
at 10:12:40 am, .4254662037 of the day has passed.

So, if the total number of hours between two date/time(s) is less than 1 day
(say from 30-Aug-2012 12:12:40 PM to 31-Aug-2012 10:12:00 AM)
then you can simply subtract the two numbers   = 0.916203703709471
Changing the display format to hh:mm:ss will show you 21:59:20

however, it's important to note that what you're REALLY doing is displaying
the date 01-Jan-1900 9:59:20 PM
it just LOOKS like what you expect.

But if the difference is MORE than 24 hours, it will only show you the decimal 
portion of the result
(the fractional part of the day).
because, after all, there's no such thing as 26 o'clock!

So.. what you're going to have to do is mathematically calculate the number of 
hours
by taking int(timeval) * 24  to get the number of hours.
=INT($A$3*24)
To get the number of minutes,
you need to get the total minutes by multiplying the time interval by 24 to get 
hours, then 60 to get minutes.
then, if you use mod() to basically divide it by the number of minutes in the 
hours of full hours (from above)
and return the minutes that were less than 60:
=INT(MOD($A$3*24*60,INT($A$3*24)))

Using the same technique, you calculate the total seconds, then use MOD() to 
remove the seconds from full minutes:
=INT(MOD($A$3*24*60*60,INT($A$3*24*60)))

So.. you can put this all into a cell like:
=INT($A$3*24) & " hrs, "
& INT(MOD($A$3*24*60,INT($A$3*24))) & " mins, "
& INT(MOD($A$3*24*60*60,INT($A$3*24*60))) & " secs"

or, if you really want it in hh:mm:ss
=INT($A$3*24) & ":"
& INT(MOD($A$3*24*60,INT($A$3*24))) & ":"
& INT(MOD($A$3*24*60*60,INT($A$3*24*60)))

actually, that's h:m:s

If you really want leading 0's, you'll have to use a =TEXT() function, like:
=TEXT(INT($A$3*24),"00") & ":"
& TEXT(INT(MOD($A$3*24*60,INT($A$3*24))),"00") & ":"
& TEXT(INT(MOD($A$3*24*60*60,INT($A$3*24*60))),"00")




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: Chandra Shekar 
To: excel-macros@googlegroups.com
Sent: Fri, August 31, 2012 7:59:43 AM
Subject: $$Excel-Macros$$ Number into hr:mm;ss


Hello,

How to convert numbers into day hh:mm:ss Format based on any two dates.

Thanks in advance.

Regards,

Chandru

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

Re: $$Excel-Macros$$ Error in 2010

[Paul Schreiner]

New to Excel 2010?
There are new file formats for Excel files:
.xlsx
.xlsm
.xlsb
 
.xlsx does not allow macros.
The theory is that it is less likely to share an Excel macro-virus.
So.. if you RECEIVE a file in .xlsx format, you can be assured that it is
Missing Malicious Macros.

.xlsm and .xlsb both allow macros, but .xlsm is a format that allows  XML 
add-ins.
(the main advantage that I can see here is the ability to design custom tool 
bars that look like Excel toolbars)

.xlsb is a "binary" format.
from what I've seen, .xlsb files are 50%-75% SMALLER than .xlsm files,
and also smaller than .xlsx files.
They also seem to run faster 
(when dealing with macros with long run-times, a 10% difference is significant.
if your macros typically run in 5-10 seconds, you'll not notice a difference)
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: "Chidurala, Shrinivas" 
To: "excel-macros@googlegroups.com" 
Sent: Fri, August 31, 2012 7:28:24 AM
Subject: $$Excel-Macros$$ Error in 2010


Dear All,
 
I am face the attached Error in 2010 while saving active workbook on recording 
macro.
 
 
Regards,
Shrinivas
 
 -- 
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$$ Required Revenue started from Date..

[NOORAIN ANSARI]

Don Sir, Nice Solution with excellent logic..

Kuldeep, you can also use vba version as UDF

Function Get_RevenueDate(Rng As Excel.Range)
Dim Cell As Range
For Each Cell In Rng.Cells
If Cell.Value > 0 Then
Get_RevenueDate = Cells(1, Cell.Column).Value
Exit Function
End If
Next
End Function


On Fri, Aug 31, 2012 at 6:12 PM, NOORAIN ANSARI wrote:

> Dear Kuldeep,
>
> Please try it..
>
> =INDEX($1:$1,0,SMALL(IF(D2:S2>0,COLUMN($D$1:$S$1),""),COLUMN($A$1)))
>
> with ctrl+shift+enter
>
> See attached sheet for more clarity.
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
> On Fri, Aug 31, 2012 at 6:05 PM, Kuldeep Singh wrote:
>
>>
>> Hi Experts,
>>
>> I want to required Revenue started from Date.
>>
>>
>> Regards,
>> Kuldeep Singh
>> Phone.: +91-120-4763789, Extn.: 789
>> naukrikuld...@gmail.com || www.naukri.com
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>
>>  --
>> 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$$ Required Revenue started from Date..

[dguillett1]

This is an array formula that must be entered using ctrl+shift+enter
=INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV2>0,0))


Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Kuldeep Singh 
Sent: Friday, August 31, 2012 7:35 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Required Revenue started from Date..


Hi Experts, 

I want to required Revenue started from Date.



Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
Please Consider the environment. Please don't print this e-mail unless you 
really need to.


-- 
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$$ Pivot Table Vba Help needed

[KAUSHIK SAVLA]

Hi All,

*Need your help to perform the attached task.*
*
*
*What I am doing is as below:=*
*
*
*1. I am having the data in the Data tab of the file*
*2. I want to create the Pivot table based on the Data tab with Criteria as
Row Labels: Supplier and Values: Sum of Amount.*
*3. Then I want to extract the details of each supplier in different tab so
as to create an invoice for the individual supplier showing them the
transactions during the amount. The extracted data should automatically
extract data from pivot for as many supplier available. In the attached
file as instance there are 4 suppliers namely A,B,C,D.*
*4. The extracted data should automatically rename the worksheet tab
containing the name of supplier.*
*
*
*Looking forward for your prompt response.*
*
*
*Regards,*
*Kaushik Savla*

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




Sirish.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Required Revenue started from Date..

[NOORAIN ANSARI]

Dear Kuldeep,

Please try it..

=INDEX($1:$1,0,SMALL(IF(D2:S2>0,COLUMN($D$1:$S$1),""),COLUMN($A$1)))

with ctrl+shift+enter

See attached sheet for more clarity.


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


On Fri, Aug 31, 2012 at 6:05 PM, Kuldeep Singh wrote:

>
> Hi Experts,
>
> I want to required Revenue started from Date.
>
>
> Regards,
> Kuldeep Singh
> Phone.: +91-120-4763789, Extn.: 789
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
>  --
> 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.




Question(Kuldeep).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Number into hr:mm;ss

[Chandra Shekar]

Hello,

How to convert numbers into *day hh:mm:ss* Format based on any two dates.

Thanks in advance.

Regards,

Chandru

-- 
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$$ Error in 2010

[NOORAIN ANSARI]

Dear Shrinivas,

You are trying to save macro file in .xlsx extension.
Please use extension
.xlsm
.xlsb
or
.xls

On Fri, Aug 31, 2012 at 4:58 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:

> Dear All,
>
> ** **
>
> I am face the attached Error in 2010 while saving active workbook on
> recording macro.
>
> ** **
>
> 
>
> ** **
>
> Regards,
>
> Shrinivas
>
> ** **
>
> ** **
>
> --
> 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$$ Need help

[NOORAIN ANSARI]

Dear Sriram,

As we know in Excel 2003 Total rows are 65536 and total columns are 256 but
in Excel 2007+ total rows are
1048576 and total columns are 16384.

You need to take table array  range A65536 and Column range 256, then
vlookup function will working fine.

Feel free to ask if you get any issue..

On Fri, Aug 31, 2012 at 5:03 PM, sriram ji  wrote:

> Dear Noorain.ansari,
>
> Thanks for your reply Noorain.ansarii have two excel files. one is
> 2003 excel file format and another one is 2007
> excel file..when i did a vlookup 2007 excel file format to 2003 excel file
> format the error is came. Anyone can help
> me to resolve this problem...
>
> [image: Inline image 2]
>
> Thanks & Regards,
> Sriram G (Chennai)
>
>
> On Fri, Aug 31, 2012 at 12:26 PM, NOORAIN ANSARI  > wrote:
>
>> Dear Sriram,
>>
>> Please explain your query,if possible pls share a sample workbook with
>> group.
>>
>> On Fri, Aug 31, 2012 at 12:22 PM, sriram ji  wrote:
>>
>>> Dear Excel Guru,
>>>
>>> May I know how to vlookup 2003 Excel to 2007 excel...
>>>
>>> Thanks & Regards,
>>> Sriram G (chennai)
>>>
>>> --
>>> 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.
>>
>>
>>
>
>  --
> 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.co

Re: $$Excel-Macros$$

[Chandra Shekar]

Hi all, Thank you very much

Regards,

Chandra Shekar B

On Fri, Aug 31, 2012 at 11:47 AM, NOORAIN ANSARI
wrote:

> Dear Chandra,
>
> Networkingdays is good solution for your query, but it doesn't work in
> excel 2003.
>
> For excel 2003 you can use..
>
> *=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(TODAY()&":"&B2)),2)<6))*
>
> if you want to exclude only sun then use..
>
> *=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(TODAY()&":"&B2)),2)<7))
>
>
> *see attached sheet for more clarity.
>
>
>
>
>
>  On Fri, Aug 31, 2012 at 1:39 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>> I need a formula for dates which excludes Saturday, Sunday & Holidays(in
>> sheet2). Could you please help with the formulas.
>>
>> Thanks in advance.
>>
>> Regards,
>>
>> Chandra Shekar B
>>
>> --
>> 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.
>
>
>

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

[sriram ji]

Dear Noorain.ansari,

Thanks for your reply Noorain.ansarii have two excel files. one is 2003
excel file format and another one is 2007
excel file..when i did a vlookup 2007 excel file format to 2003 excel file
format the error is came. Anyone can help
me to resolve this problem...

[image: Inline image 2]

Thanks & Regards,
Sriram G (Chennai)


On Fri, Aug 31, 2012 at 12:26 PM, NOORAIN ANSARI
wrote:

> Dear Sriram,
>
> Please explain your query,if possible pls share a sample workbook with
> group.
>
> On Fri, Aug 31, 2012 at 12:22 PM, sriram ji  wrote:
>
>> Dear Excel Guru,
>>
>> May I know how to vlookup 2003 Excel to 2007 excel...
>>
>> Thanks & Regards,
>> Sriram G (chennai)
>>
>> --
>> 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.
>
>
>

-- 
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$$ Error in 2010

[Chidurala, Shrinivas]

Dear All,

I am face the attached Error in 2010 while saving active workbook on recording 
macro.

[cid:image001.png@01CD8799.C70A4EE0]

Regards,
Shrinivas


-- 
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$$ Outlook to excel VBA

[amar takale]

Dear Noorin
All VBA Experts,
This is very Challenging work for me also you & Our other Excel users in
group.I required VBA code when our research report  published on outlook
(Outlook 2003) then that report automatic save on give folder Path
(H:\Published Reports\India Reports).
So anyone put this challenge.
All VBA experts request to suggest that type of code.I dont know this is
possible or impossible.If possible then pls send me & explain how to use
it.I believe everything is possible excel, outlook, word.only guys to works
hurtly.So again I request to all experts suggest this code or any other way
to solve.
Pls Pls Pls...

Best Regards
Amar


On Fri, Aug 31, 2012 at 4:13 PM, NOORAIN ANSARI wrote:

> Dear Moose,
>
> Please check below link, Hope it will help to you.
>
> http://www.jpsoftwaretech.com/working-with-the-outlook
> -recipients-collection-in-vba/
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
> On Thu, Aug 30, 2012 at 10:22 AM, Moose  wrote:
>
>> Hi,
>>
>> I would like to import the timestamp from outlook with specific subject
>> lines into excel. All mails reside in the inbox folder. The idea is to know
>> by what time a specific task has been completed every day (against an SLA)
>> . and this is understood by the specific subject line on the email.
>> Can you guide me on how to do this?
>>
>> Thanks,
>> Moose
>>
>> --
>> 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 

Re: $$Excel-Macros$$

[NOORAIN ANSARI]

Dear Chandra,


In VBA Version you can also use..

Function GetWorkDays(ByVal StartDate As Long, ByVal EndDate As Long)
Dim d As Long, dCount As Long
For d = StartDate To EndDate
If Weekday(d, vbMonday) < 6 Then
dCount = dCount + 1
End If
Next d

GetWorkDays = dCount

End Function




On Fri, Aug 31, 2012 at 3:17 PM, NOORAIN ANSARI wrote:

> Dear Chandra,
>
> Networkingdays is good solution for your query, but it doesn't work in
> excel 2003.
>
> For excel 2003 you can use..
>
> *=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(TODAY()&":"&B2)),2)<6))*
>
> if you want to exclude only sun then use..
>
> *=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(TODAY()&":"&B2)),2)<7))
>
>
> *see attached sheet for more clarity.
>
>
>
>
>
> On Fri, Aug 31, 2012 at 1:39 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>> I need a formula for dates which excludes Saturday, Sunday & Holidays(in
>> sheet2). Could you please help with the formulas.
>>
>> Thanks in advance.
>>
>> Regards,
>>
>> Chandra Shekar B
>>
>> --
>> 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
>
>
>


-- 
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$$ Outlook to excel VBA

[NOORAIN ANSARI]

Dear Moose,

Please check below link, Hope it will help to you.

http://www.jpsoftwaretech.com/working-with-the-outlook
-recipients-collection-in-vba/

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


On Thu, Aug 30, 2012 at 10:22 AM, Moose  wrote:

> Hi,
>
> I would like to import the timestamp from outlook with specific subject
> lines into excel. All mails reside in the inbox folder. The idea is to know
> by what time a specific task has been completed every day (against an SLA)
> . and this is understood by the specific subject line on the email.
> Can you guide me on how to do this?
>
> Thanks,
> Moose
>
> --
> 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$$

[NOORAIN ANSARI]

Dear Chandra,

Networkingdays is good solution for your query, but it doesn't work in
excel 2003.

For excel 2003 you can use..

*=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(TODAY()&":"&B2)),2)<6))*

if you want to exclude only sun then use..

*=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(TODAY()&":"&B2)),2)<7))


*see attached sheet for more clarity.





On Fri, Aug 31, 2012 at 1:39 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hello,
> I need a formula for dates which excludes Saturday, Sunday & Holidays(in
> sheet2). Could you please help with the formulas.
>
> Thanks in advance.
>
> Regards,
>
> Chandra Shekar B
>
> --
> 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.




Date&Time_Exclusing Holidays(Solved).xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ Need help

[Amit Desai (MERU)]

Reverse Vlookup,

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of vijayajith VA
Sent: 31 August 2012 13:24
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help

Hi Noorain,

Isna(vlookup)
On Fri, Aug 31, 2012 at 1:16 PM, NOORAIN ANSARI 
mailto:noorain.ans...@gmail.com>> wrote:
Dear Group,

If any have more example except it please share, we have to make it for 50 
types.

Please share if any one have examples...


On Fri, Aug 31, 2012 at 1:07 PM, NOORAIN ANSARI 
mailto:noorain.ans...@gmail.com>> wrote:
Dear Sriram,

I have created a Ebook of Vlookup (Magic of Vlookup), There are 35 types of 
vlookup in it.
i will share shortly with group,this is because some design part is still 
pending.

See a Snap shot
Sr.No

Types of Vlookup

Status

1

Simple Vlookup

Yes

2

Vlookup+Match

Yes

3

Vlookup+Column

Yes

4

Vlookup+if condition

Yes

5

Vlookup+Max/Min

Yes

6

Vlookup with Sorting

Yes

7

Vlookup+Exact

Yes

8

Vlookup+Choose

Yes

9

Vlookup+Array

Yes

10

Vlookup+Large/Small

Yes

11

Vlookup+Wild Card

Yes

12

Vlookup+"?"

Yes

13

Vlookup+indirect

Yes

14

Vlookup+Row()

Yes

15

Vlookup+iferror(Global)

Yes

16

Vlookup+Sumproduct

Yes

17

Vlookup+offset

Yes

18

Vlookup+Index

Yes

19

Vlookup+substitute

Yes

20

Vlookup+Char

Yes

21

Vlookup+Value/Int

Yes

22

Vlookup+Trim/Clean

Yes

23

Vlookup+Multiple Lookup

Yes

24

Vlookup+Hyperlink

Yes

25

Vlookup+Concatenate

Yes

26

Vlookup+Left/right/Mid

Yes

27

Vlookup+N

Yes

28

Vlookup+Edate

Yes

29

Vlookup+EOMonth

Yes

30

Vlookup+Round/Mround

Yes

31

Vlookup+SQRT

Yes

32

Vlookup+Approximate value

Yes

33

Vlookup+""

Yes

34

Vlookup Multiple

Yes

35

Vlookup+Subtotal

Yes


==




































On Fri, Aug 31, 2012 at 12:22 PM, sriram ji 
mailto:sriramg...@gmail.com>> wrote:
Dear Excel Guru,

May I know how to vlookup 2003 Excel to 2007 excel...

Thanks & Regards,
Sriram G (chennai)
--
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





--
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$$ Need help

[Pravin Gunjal]

*Dear Sriram,*
*
*
*Please write a meaning full subjects for e-mails.*
*
*
*This will help us to search the mails anytime, based on the requirement.*
*
*
*Thanks.*
*Pravin*
*
*

On Fri, Aug 31, 2012 at 12:22 PM, sriram ji  wrote:

> Dear Excel Guru,
>
> May I know how to vlookup 2003 Excel to 2007 excel...
>
> Thanks & Regards,
> Sriram G (chennai)
>
> --
> 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$$

[अनिल नारायण गवली]

try =NETWORKDAYS formula

Thanks & Regards,
Gawli Anil

On Fri, Aug 31, 2012 at 1:41 PM, अनिल नारायण गवली
wrote:

> try =NETWORKDAYS formula
>
> Thanks & Regards,
> Gawli Anil
>
> On Fri, Aug 31, 2012 at 1:39 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>> I need a formula for dates which excludes Saturday, Sunday & Holidays(in
>> sheet2). Could you please help with the formulas.
>>
>> Thanks in advance.
>>
>> Regards,
>>
>> Chandra Shekar B
>>
>> --
>> 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
>



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

Re: $$Excel-Macros$$

[अनिल नारायण गवली]

try =NETWORKDAYS formula

Thanks & Regards,
Gawli Anil

On Fri, Aug 31, 2012 at 1:39 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hello,
> I need a formula for dates which excludes Saturday, Sunday & Holidays(in
> sheet2). Could you please help with the formulas.
>
> Thanks in advance.
>
> Regards,
>
> Chandra Shekar B
>
> --
> 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.

Re: $$Excel-Macros$$ Need help

[अनिल नारायण गवली]

It would be grt to our group..

KIU.

Thanks & Regards,
Gawli Anil

On Fri, Aug 31, 2012 at 1:24 PM, vijayajith VA wrote:

> Hi Noorain,
>
> Isna(vlookup)
>
>
> On Fri, Aug 31, 2012 at 1:16 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Group,
>>
>> If any have more example except it please share, we have to make it for
>> 50 types.
>>
>> Please share if any one have examples...
>>
>>
>>
>> On Fri, Aug 31, 2012 at 1:07 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Sriram,
>>>
>>> I have created a Ebook of Vlookup (*Magic of Vlookup*), There are 35
>>> types of vlookup in it.
>>> i will share shortly with group,this is because some design part is
>>> still pending.
>>>
>>> See a Snap shot
>>>
>>> *Sr.No* *Types of Vlookup* *Status* *1* *Simple Vlookup* *Yes* *
>>> 2* *Vlookup+Match* *Yes* *3* *Vlookup+Column* *Yes* *4* *Vlookup+if
>>> condition* *Yes* *5* *Vlookup+Max/Min* *Yes* *6* *Vlookup with Sorting*
>>> *Yes* *7* *Vlookup+Exact* *Yes* *8* *Vlookup+Choose* *Yes* *9* *
>>> Vlookup+Array * *Yes* *10* *Vlookup+Large/Small* *Yes* *11* *Vlookup+Wild
>>> Card* *Yes* *12* *Vlookup+"?"* *Yes* *13* *Vlookup+indirect* *Yes* *14*
>>> *Vlookup+Row()* *Yes* *15* *Vlookup+iferror(Global)* *Yes* *16* *
>>> Vlookup+Sumproduct* *Yes* *17* *Vlookup+offset* *Yes* *18* *
>>> Vlookup+Index* *Yes* *19* *Vlookup+substitute* *Yes* *20* *Vlookup+Char*
>>> *Yes* *21* *Vlookup+Value/Int* *Yes* *22* *Vlookup+Trim/Clean* *Yes* *23
>>> * *Vlookup+Multiple Lookup* *Yes* *24* *Vlookup+Hyperlink* *Yes* *25* *
>>> Vlookup+Concatenate* *Yes* *26* *Vlookup+Left/right/Mid* *Yes* *27* *
>>> Vlookup+N * *Yes* *28* *Vlookup+Edate* *Yes* *29* *Vlookup+EOMonth* *Yes
>>> * *30* *Vlookup+Round/Mround* *Yes* *31* *Vlookup+SQRT* *Yes* *32* 
>>> *Vlookup+Approximate
>>> value* *Yes* *33* *Vlookup+""* *Yes* *34* *Vlookup Multiple* *Yes* *35*
>>> *Vlookup+Subtotal* *Yes* *
>>> * *
>>> * *==
>>> * *
>>> * *
>>> * *
>>> * *
>>> * *
>>> * *
>>> * *
>>> * *
>>> *
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Fri, Aug 31, 2012 at 12:22 PM, sriram ji wrote:
>>>
 Dear Excel Guru,

 May I know how to vlookup 2003 Excel to 2007 excel...

 Thanks & Regards,
 Sriram G (chennai)

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

$$Excel-Macros$$

[Chandra Shekar]

Hello,
I need a formula for dates which excludes Saturday, Sunday & Holidays(in
sheet2). Could you please help with the formulas.

Thanks in advance.

Regards,

Chandra Shekar B

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




Date&Time_Exclusing Holidays.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need help

[vijayajith VA]

Hi Noorain,

Isna(vlookup)

On Fri, Aug 31, 2012 at 1:16 PM, NOORAIN ANSARI wrote:

> Dear Group,
>
> If any have more example except it please share, we have to make it for 50
> types.
>
> Please share if any one have examples...
>
>
>
> On Fri, Aug 31, 2012 at 1:07 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Sriram,
>>
>> I have created a Ebook of Vlookup (*Magic of Vlookup*), There are 35
>> types of vlookup in it.
>> i will share shortly with group,this is because some design part is still
>> pending.
>>
>> See a Snap shot
>>
>>  *Sr.No* *Types of Vlookup* *Status*  *1* *Simple Vlookup* *Yes*  *2*
>> *Vlookup+Match* *Yes*  *3* *Vlookup+Column* *Yes*  *4* *Vlookup+if
>> condition* *Yes*  *5* *Vlookup+Max/Min* *Yes*  *6* *Vlookup with Sorting*
>> *Yes*  *7* *Vlookup+Exact* *Yes*  *8* *Vlookup+Choose* *Yes*  *9* *
>> Vlookup+Array * *Yes*  *10* *Vlookup+Large/Small* *Yes*  *11* *Vlookup+Wild
>> Card* *Yes*  *12* *Vlookup+"?"* *Yes*  *13* *Vlookup+indirect* *Yes*  *14
>> * *Vlookup+Row()* *Yes*  *15* *Vlookup+iferror(Global)* *Yes*  *16* *
>> Vlookup+Sumproduct* *Yes*  *17* *Vlookup+offset* *Yes*  *18* *
>> Vlookup+Index* *Yes*  *19* *Vlookup+substitute* *Yes*  *20* *Vlookup+Char
>> * *Yes*  *21* *Vlookup+Value/Int* *Yes*  *22* *Vlookup+Trim/Clean* *Yes*
>> *23* *Vlookup+Multiple Lookup* *Yes*  *24* *Vlookup+Hyperlink* *Yes*  *25
>> * *Vlookup+Concatenate* *Yes*  *26* *Vlookup+Left/right/Mid* *Yes*  *27*
>> *Vlookup+N * *Yes*  *28* *Vlookup+Edate* *Yes*  *29* *Vlookup+EOMonth* *
>> Yes*  *30* *Vlookup+Round/Mround* *Yes*  *31* *Vlookup+SQRT* *Yes*  *32*
>> *Vlookup+Approximate value* *Yes*  *33* *Vlookup+""* *Yes*  *34* *Vlookup
>> Multiple* *Yes*  *35* *Vlookup+Subtotal* *Yes* *
>> **
>> * *==
>> **
>> **
>> **
>> **
>> * *
>> **
>> **
>> * *
>> *
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Fri, Aug 31, 2012 at 12:22 PM, sriram ji  wrote:
>>
>>> Dear Excel Guru,
>>>
>>> May I know how to vlookup 2003 Excel to 2007 excel...
>>>
>>> Thanks & Regards,
>>> Sriram G (chennai)
>>>
>>> --
>>> 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
>>
>>
>>
>
>
> --
> 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

Re: $$Excel-Macros$$ Need help

[NOORAIN ANSARI]

Dear Group,

If any have more example except it please share, we have to make it for 50
types.

Please share if any one have examples...


On Fri, Aug 31, 2012 at 1:07 PM, NOORAIN ANSARI wrote:

> Dear Sriram,
>
> I have created a Ebook of Vlookup (*Magic of Vlookup*), There are 35
> types of vlookup in it.
> i will share shortly with group,this is because some design part is still
> pending.
>
> See a Snap shot
>
>  *Sr.No* *Types of Vlookup* *Status*  *1* *Simple Vlookup* *Yes*  *2*
> *Vlookup+Match* *Yes*  *3* *Vlookup+Column* *Yes*  *4* *Vlookup+if
> condition* *Yes*  *5* *Vlookup+Max/Min* *Yes*  *6* *Vlookup with Sorting*
> *Yes*  *7* *Vlookup+Exact* *Yes*  *8* *Vlookup+Choose* *Yes*  *9* *
> Vlookup+Array * *Yes*  *10* *Vlookup+Large/Small* *Yes*  *11* *Vlookup+Wild
> Card* *Yes*  *12* *Vlookup+"?"* *Yes*  *13* *Vlookup+indirect* *Yes*  *14*
> *Vlookup+Row()* *Yes*  *15* *Vlookup+iferror(Global)* *Yes*  *16* *
> Vlookup+Sumproduct* *Yes*  *17* *Vlookup+offset* *Yes*  *18* *
> Vlookup+Index* *Yes*  *19* *Vlookup+substitute* *Yes*  *20* *Vlookup+Char*
> *Yes*  *21* *Vlookup+Value/Int* *Yes*  *22* *Vlookup+Trim/Clean* *Yes*  *
> 23* *Vlookup+Multiple Lookup* *Yes*  *24* *Vlookup+Hyperlink* *Yes*  *25*
> *Vlookup+Concatenate* *Yes*  *26* *Vlookup+Left/right/Mid* *Yes*  *27* *
> Vlookup+N * *Yes*  *28* *Vlookup+Edate* *Yes*  *29* *Vlookup+EOMonth* *Yes
> *  *30* *Vlookup+Round/Mround* *Yes*  *31* *Vlookup+SQRT* *Yes*  *32* 
> *Vlookup+Approximate
> value* *Yes*  *33* *Vlookup+""* *Yes*  *34* *Vlookup Multiple* *Yes*  *35*
> *Vlookup+Subtotal* *Yes* *
> **
> * *==
> **
> **
> **
> **
> * *
> **
> **
> * *
> *
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> On Fri, Aug 31, 2012 at 12:22 PM, sriram ji  wrote:
>
>> Dear Excel Guru,
>>
>> May I know how to vlookup 2003 Excel to 2007 excel...
>>
>> Thanks & Regards,
>> Sriram G (chennai)
>>
>> --
>> 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
>
>
>


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

RE: $$Excel-Macros$$ Need help

[Amit Desai (MERU)]

Do you or anyone else have such detailed ebook or PPT on excel functions? If 
yes, please share.

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of NOORAIN ANSARI
Sent: 31 August 2012 13:07
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help

Dear Sriram,

I have created a Ebook of Vlookup (Magic of Vlookup), There are 35 types of 
vlookup in it.
i will share shortly with group,this is because some design part is still 
pending.

See a Snap shot
Sr.No

Types of Vlookup

Status

1

Simple Vlookup

Yes

2

Vlookup+Match

Yes

3

Vlookup+Column

Yes

4

Vlookup+if condition

Yes

5

Vlookup+Max/Min

Yes

6

Vlookup with Sorting

Yes

7

Vlookup+Exact

Yes

8

Vlookup+Choose

Yes

9

Vlookup+Array

Yes

10

Vlookup+Large/Small

Yes

11

Vlookup+Wild Card

Yes

12

Vlookup+"?"

Yes

13

Vlookup+indirect

Yes

14

Vlookup+Row()

Yes

15

Vlookup+iferror(Global)

Yes

16

Vlookup+Sumproduct

Yes

17

Vlookup+offset

Yes

18

Vlookup+Index

Yes

19

Vlookup+substitute

Yes

20

Vlookup+Char

Yes

21

Vlookup+Value/Int

Yes

22

Vlookup+Trim/Clean

Yes

23

Vlookup+Multiple Lookup

Yes

24

Vlookup+Hyperlink

Yes

25

Vlookup+Concatenate

Yes

26

Vlookup+Left/right/Mid

Yes

27

Vlookup+N

Yes

28

Vlookup+Edate

Yes

29

Vlookup+EOMonth

Yes

30

Vlookup+Round/Mround

Yes

31

Vlookup+SQRT

Yes

32

Vlookup+Approximate value

Yes

33

Vlookup+""

Yes

34

Vlookup Multiple

Yes

35

Vlookup+Subtotal

Yes


==




































On Fri, Aug 31, 2012 at 12:22 PM, sriram ji 
mailto:sriramg...@gmail.com>> wrote:
Dear Excel Guru,

May I know how to vlookup 2003 Excel to 2007 excel...

Thanks & Regards,
Sriram G (chennai)
--
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 attachmen

RE: $$Excel-Macros$$ Need help

[Amit Desai (MERU)]

Wow.Noorain. This will be grt gift to this group members.

Thanks a lot in Advance.

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of NOORAIN ANSARI
Sent: 31 August 2012 13:07
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help

Dear Sriram,

I have created a Ebook of Vlookup (Magic of Vlookup), There are 35 types of 
vlookup in it.
i will share shortly with group,this is because some design part is still 
pending.

See a Snap shot
Sr.No

Types of Vlookup

Status

1

Simple Vlookup

Yes

2

Vlookup+Match

Yes

3

Vlookup+Column

Yes

4

Vlookup+if condition

Yes

5

Vlookup+Max/Min

Yes

6

Vlookup with Sorting

Yes

7

Vlookup+Exact

Yes

8

Vlookup+Choose

Yes

9

Vlookup+Array

Yes

10

Vlookup+Large/Small

Yes

11

Vlookup+Wild Card

Yes

12

Vlookup+"?"

Yes

13

Vlookup+indirect

Yes

14

Vlookup+Row()

Yes

15

Vlookup+iferror(Global)

Yes

16

Vlookup+Sumproduct

Yes

17

Vlookup+offset

Yes

18

Vlookup+Index

Yes

19

Vlookup+substitute

Yes

20

Vlookup+Char

Yes

21

Vlookup+Value/Int

Yes

22

Vlookup+Trim/Clean

Yes

23

Vlookup+Multiple Lookup

Yes

24

Vlookup+Hyperlink

Yes

25

Vlookup+Concatenate

Yes

26

Vlookup+Left/right/Mid

Yes

27

Vlookup+N

Yes

28

Vlookup+Edate

Yes

29

Vlookup+EOMonth

Yes

30

Vlookup+Round/Mround

Yes

31

Vlookup+SQRT

Yes

32

Vlookup+Approximate value

Yes

33

Vlookup+""

Yes

34

Vlookup Multiple

Yes

35

Vlookup+Subtotal

Yes


==




































On Fri, Aug 31, 2012 at 12:22 PM, sriram ji 
mailto:sriramg...@gmail.com>> wrote:
Dear Excel Guru,

May I know how to vlookup 2003 Excel to 2007 excel...

Thanks & Regards,
Sriram G (chennai)
--
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 a

Re: $$Excel-Macros$$ Need help

[deviprasad]

Awesome..

On Aug 31, 2012, at 1:07 PM, NOORAIN ANSARI wrote:

> Dear Sriram,
> 
> I have created a Ebook of Vlookup (Magic of Vlookup), There are 35 types of 
> vlookup in it.
> i will share shortly with group,this is because some design part is still 
> pending.
> 
> See a Snap shot
> 
> Sr.No Types of VlookupStatus
> 1 Simple Vlookup  Yes
> 2 Vlookup+Match   Yes
> 3 Vlookup+Column  Yes
> 4 Vlookup+if conditionYes
> 5 Vlookup+Max/Min Yes
> 6 Vlookup with SortingYes
> 7 Vlookup+Exact   Yes
> 8 Vlookup+Choose  Yes
> 9 Vlookup+Array   Yes
> 10Vlookup+Large/Small Yes
> 11Vlookup+Wild Card   Yes
> 12Vlookup+"?" Yes
> 13Vlookup+indirectYes
> 14Vlookup+Row()   Yes
> 15Vlookup+iferror(Global) Yes
> 16Vlookup+Sumproduct  Yes
> 17Vlookup+offset  Yes
> 18Vlookup+Index   Yes
> 19Vlookup+substitute  Yes
> 20Vlookup+CharYes
> 21Vlookup+Value/Int   Yes
> 22Vlookup+Trim/Clean  Yes
> 23Vlookup+Multiple Lookup Yes
> 24Vlookup+Hyperlink   Yes
> 25Vlookup+Concatenate Yes
> 26Vlookup+Left/right/Mid  Yes
> 27Vlookup+N   Yes
> 28Vlookup+Edate   Yes
> 29Vlookup+EOMonth Yes
> 30Vlookup+Round/MroundYes
> 31Vlookup+SQRTYes
> 32Vlookup+Approximate value   Yes
> 33Vlookup+""  Yes
> 34Vlookup MultipleYes
> 35Vlookup+SubtotalYes
> 
> 
> ==
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> On Fri, Aug 31, 2012 at 12:22 PM, sriram ji  wrote:
> Dear Excel Guru,
> 
> May I know how to vlookup 2003 Excel to 2007 excel...
> 
> Thanks & Regards,
> Sriram G (chennai)
> 
> -- 
> 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.
>  
>  

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

Re: $$Excel-Macros$$ Need help

[NOORAIN ANSARI]

Dear Sriram,

I have created a Ebook of Vlookup (*Magic of Vlookup*), There are 35 types
of vlookup in it.
i will share shortly with group,this is because some design part is still
pending.

See a Snap shot

 *Sr.No* *Types of Vlookup* *Status*  *1* *Simple Vlookup* *Yes*  *2* *
Vlookup+Match* *Yes*  *3* *Vlookup+Column* *Yes*  *4* *Vlookup+if condition*
*Yes*  *5* *Vlookup+Max/Min* *Yes*  *6* *Vlookup with Sorting* *Yes*  *7* *
Vlookup+Exact* *Yes*  *8* *Vlookup+Choose* *Yes*  *9* *Vlookup+Array * *Yes*
*10* *Vlookup+Large/Small* *Yes*  *11* *Vlookup+Wild Card* *Yes*  *12* *
Vlookup+"?"* *Yes*  *13* *Vlookup+indirect* *Yes*  *14* *Vlookup+Row()* *Yes
*  *15* *Vlookup+iferror(Global)* *Yes*  *16* *Vlookup+Sumproduct* *Yes*  *
17* *Vlookup+offset* *Yes*  *18* *Vlookup+Index* *Yes*  *19* *
Vlookup+substitute* *Yes*  *20* *Vlookup+Char* *Yes*  *21* *
Vlookup+Value/Int* *Yes*  *22* *Vlookup+Trim/Clean* *Yes*  *23*
*Vlookup+Multiple
Lookup* *Yes*  *24* *Vlookup+Hyperlink* *Yes*  *25* *Vlookup+Concatenate* *
Yes*  *26* *Vlookup+Left/right/Mid* *Yes*  *27* *Vlookup+N * *Yes*  *28* *
Vlookup+Edate* *Yes*  *29* *Vlookup+EOMonth* *Yes*  *30* *
Vlookup+Round/Mround* *Yes*  *31* *Vlookup+SQRT* *Yes*  *32*
*Vlookup+Approximate
value* *Yes*  *33* *Vlookup+""* *Yes*  *34* *Vlookup Multiple* *Yes*  *35* *
Vlookup+Subtotal* *Yes* *
**
**==
**
**
**
**
**
**
**
**
*

































































































On Fri, Aug 31, 2012 at 12:22 PM, sriram ji  wrote:

> Dear Excel Guru,
>
> May I know how to vlookup 2003 Excel to 2007 excel...
>
> Thanks & Regards,
> Sriram G (chennai)
>
> --
> 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$$ Need help

[Kuldeep Singh]

Hi,

More examples in below websites. for any query please share a worksheet
with Group.

http://chandoo.org/wp/2010/11/02/excel-vlookup-tips/

http://www.techonthenet.com/excel/formulas/vlookup.php

http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

Regards,
Kuldeep Singh

On Fri, Aug 31, 2012 at 12:26 PM, pankaj sangotra wrote:

> Hi Sriram,
>
> Vlookup is used to pick values from tables for lookup values...
>
> For more details use techonthenet.com.. This is an awesome website.. If
> face any challenge then let me know..
> On Aug 31, 2012 12:22 PM, "sriram ji"  wrote:
>
>> Dear Excel Guru,
>>
>> May I know how to vlookup 2003 Excel to 2007 excel...
>>
>> Thanks & Regards,
>> Sriram G (chennai)
>>
>> --
>> 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$$ Need help

[अनिल नारायण गवली]

Dear Sriram

Attached is the Eg of Vlookup furmulae


Thanks & Regards,
Gawli Anil

On Fri, Aug 31, 2012 at 12:26 PM, pankaj sangotra wrote:

> Hi Sriram,
>
> Vlookup is used to pick values from tables for lookup values...
>
> For more details use techonthenet.com.. This is an awesome website.. If
> face any challenge then let me know..
>  On Aug 31, 2012 12:22 PM, "sriram ji"  wrote:
>
>> Dear Excel Guru,
>>
>> May I know how to vlookup 2003 Excel to 2007 excel...
>>
>> Thanks & Regards,
>> Sriram G (chennai)
>>
>> --
>> 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.
>
>
>



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




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