Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

[Vijayendra Rao]

You can use the below formula

=INDEX($H$2:$J$7,MATCH($B2,$H$2:$H$7,1),2)
=INDEX($H$2:$J$7,MATCH($B2,$H$2:$H$7,1),3)

Attached is the excel file for your reference.

Regards,
Vijayendra


2012/2/4 chandra sekaran 

> Hi Sanjib
> simple  Vlookup forumula   to solve your Query
>
> Regards
> chandru
> chennai
>
>
>
>
> On Fri, Feb 3, 2012 at 4:28 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Thank you for your help
>>
>> ragards,
>>
>> sanjib
>>
>>
>> On Fri, Feb 3, 2012 at 4:02 PM, The Viper  wrote:
>>
>>> please find the attached
>>>
>>>
>>>
>>> On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee <
>>> chatterjee.kolk...@gmail.com> wrote:
>>>

 Dear Experts,

 Please See the attachment and Help me regarding VLOOKUP FUNCTION

 Thanking you in Advance

 Sanjib









 --
 -

 --
 FORUM RULES (986+ 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.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


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

>>>
>>>
>>>
>>> --
>>> *Great day,*
>>> *viper*
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> -
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧

Regards,
Vijayendra
94491 67631

-- 
FORUM RULES (986+ 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

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

[chandra sekaran]

Hi Sanjib
simple  Vlookup forumula   to solve your Query

Regards
chandru
chennai




On Fri, Feb 3, 2012 at 4:28 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:

> Thank you for your help
>
> ragards,
>
> sanjib
>
>
> On Fri, Feb 3, 2012 at 4:02 PM, The Viper  wrote:
>
>> please find the attached
>>
>>
>>
>> On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee <
>> chatterjee.kolk...@gmail.com> wrote:
>>
>>>
>>> Dear Experts,
>>>
>>> Please See the attachment and Help me regarding VLOOKUP FUNCTION
>>>
>>> Thanking you in Advance
>>>
>>> Sanjib
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> -
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> *Great day,*
>> *viper*
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> -
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


VLOOKUP_FUNCTION(1).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ plz, check the attachment it clearly tells u what I need in actually.

[Venkat CV]

Hi Muneer,

Can u Explain some more about query...

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *

On Sat, Feb 4, 2012 at 10:59 AM, Mohammed Muneer  wrote:

> **
>
>
>
>
>
> Regards,
> Muneer,
> CC...
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*
*
*
*
*
*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

$$Excel-Macros$$ plz, check the attachment it clearly tells u what I need in actually.

[Mohammed Muneer]

 
 
 
 
 
Regards,
Muneer,
CC...

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Book1.xls
Description: Book1.xls

Re: $$Excel-Macros$$ formula in rate column

[The Viper]

hi

check the attachment



On Sat, Feb 4, 2012 at 12:02 AM, raghu gr  wrote:

> Hi experts,
>
> I have a invoice file and summary file, i want the formula in rate column,
> which has to pick from rate sheet.
> please help me in this regard
>
> Attached sample file
>
> Thank you
>
> with regards
> Raghu
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*Great day,*
*viper*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


SAMPLEINVOICE.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

[Venkat CV]

Congrats...

Noorain & Everyone...

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *


On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain  wrote:

> Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Jan'12
> He has posted 175 posts in Jan'12 and helped many people through his
> expertise. He has been consistent contributor to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
> , Priyanka, Lokesh and other folks for helping excel enthusiasts
> voluntarily !! Keep it up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*
*
*
*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

[Venkat CV]

Hi Sanjib,

Look Attached...

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *


On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:

>
> Dear Experts,
>
> Please See the attachment and Help me regarding VLOOKUP FUNCTION
>
> Thanking you in Advance
>
> Sanjib
>
>
>
>
>
>
>
>
>
> --
> -
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*
*
*
*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


VLOOKUP_FUNCTION Venkat.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$

[Mohammed Muneer]

Dear Sir,

 

I am using Bathtext function in excel sheet, by this I want to write the
value (1,234), in words (One Thousand Two hundred & Thirty four).

But it is showing in the Thailandi text.

 

Pls, suggest how to apply this function properly.

 

 

Regards,

Muneer,

CC...

 

 

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Urgent Help

[PRAVESH KUMAR]

Hi Noorain,


Thanks a lot of...

On 2/3/12, NOORAIN ANSARI  wrote:
> Dear Pravesh,
>
> See attached sheet..
>
> =SUMPRODUCT(($D$5:$D$18=K7)*($F$5:$F$18=2)*($E$5:$E$18))
>
> On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko
> wrote:
>
>> This should work
>>
>> =INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18<>OFFSET($D$5:$D$18,1,0),ROW(INDIRECT("1:"&ROWS($D$5:$D$18))),""),COUNTA($I$4:I4)))
>> Regards,
>>
>> Sam Mathai Chacko
>> On Fri, Feb 3, 2012 at 11:06 PM, PRAVESH KUMAR
>> wrote:
>>
>>> Hi,
>>>
>>>
>>> please help ASAP.
>>>
>>> please find attached sheet.
>>>
>>>
>>> Thanks
>>>
>>> Pravesh Kumar
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE  : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>>  --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/* 
>
> --
> FORUM RULES (986+ 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.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

RE: $$Excel-Macros$$ paste special problem

[Asa Rossoff]

Hi Danial,

If you are not done with your task, you may want to consider this variation on 
Don's approach.   It's not thoroughly tested, but some of the changes should 
improve reliability.

 

The principle differences:

(1) Processes Areas (distinct ranges) containing formulas in each worksheet one 
at a time, rather than all at once.  Excel can corrupt your data (change it) in 
some cases without this change;

(2) Uses the Value2 property of formula ranges instead of the Value property.  
The Value property rounds off currency and date/time values to VBA Date and VBA 
Currency datatype limits, changing your underlying data.  Value2 is also faster;

(3) Only processes sheets in the Worksheets collection, skipping chart and 
legacy macro sheets;

(4) Loops through all open workbooks, prompting to process them (skipping 
hidden workbooks, but processing hidden sheets in workbooks with a visible 
window);

(5) If errors occur during processing you have the opportunity to continue 
processing anyway.

 

Sub ConvertToValues()

Dim wb As Workbook, ws As Worksheet, a As Range

Dim e As String, abort As Boolean

Const ProcTitle = "Convert to Values"

On Error Resume Next

Debug.Print vbCrLf & ProcTitle & " Start."

For Each wb In Application.Workbooks

If wb.Windows(1).Visible Then ' quick check to skip hidden workbooks 
(personal.xls*, addins,...)

If MsgBox("Process " & wb.Name & "?", _

  vbQuestion + vbYesNo + vbDefaultButton2, _

  ProcTitle) = vbYes Then

Debug.Print "Processing " & wb.FullName

abort = False

For Each ws In wb.Worksheets

Debug.Print , ws.Name

For Each a In 
ws.Cells.SpecialCells(xlCellTypeFormulas).Areas

ConvertValues:

If Not a Is Nothing Then

Debug.Print , , a.AddressLocal & " (" & 
a.Cells.Count & " cells)"

a.Value2 = a.Value2

If Err.Number <> 0 Then

e = "ERROR " & Err.Number & " - " & 
Err.Description

Err.Clear

Debug.Print e

Select Case _

  MsgBox(e & vbCrLf & vbCrLf & _

  "For processing of this workbook...", _

  vbQuestion + vbAbortRetryIgnore + 
vbDefaultButton3, _

  ProcTitle & " - [" & wb.Name & "]" & ws.Name 
& "!" & a.AddressLocal)

Case vbRetry

Debug.Print "User retry."

GoTo ConvertValues

Case vbAbort

Debug.Print "User abort."

abort = True

Exit For

End Select

End If

End If

Next a

If abort Then Exit For

Next ws

Else

Debug.Print "User skipped " & wb.FullName

End If

Else

Debug.Print "Skipping hidden workbook " & wb.FullName

End If

   Next wb

Debug.Print vbCrLf & ProcTitle & " Finish."

Cleanup:

Set a = Nothing

Set ws = Nothing

Set wb = Nothing

End Sub

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of dguillett1
Sent: Friday, February 03, 2012 8:12 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ paste special problem

 

Probably the most efficient to do only those with formulas

 

option explicit

Sub dovalues()

dim ws as worksheet

For Each ws In ActiveWorkbook.Sheets

With ws.Cells.SpecialCells(xlCellTypeFormulas)

  .value = .Value

End With

Next ws

End Sub

 

Don Guillett
SalesAid Software
dguille...@gmail.com

 

From: danial mansoor   

Sent: Friday, February 03, 2012 9:38 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ paste special problem

 

i have a big file with many sheets i want to convert formula in values,if i do 
individually it will take lotes of time can any one tell me the macro which 
will work?

Note:macro should work fine in huge file i have a macro which is working fine 
with small file but not in huge file urgent help will be appreciated.




 

  _  

Date: Thu, 2 Feb 2012 09:21:22 +0530
Subject: Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Index & Match Formula
From: vijayendrar...@gmail.com
To: excel-macros@googlegroups.com

Hi Sam,

 

Your formulas resolves my problem and thanks a lot for the same. Can you please 
let me know the logic behind of this formula.

 

Rohan,

I wanted to pick the employees name from the same project and Sa

$$Excel-Macros$$ Re: Copy of excel files to 1 excel file -need vba code

[Veeru TOC]

>
>> Dear Group
>>>
>>>
>>>
>>>
>>  one folder of excel files copy to 1 excel file -plz need help

>
>>>
>>> *Thanks&Regards*
>>>
>>> **
>>>
>>> ***Veerendra.Vanam*
>>>
>>> *TOC TEAM*
>>> ***Bhagyanagar Electrical & Contractors**
>>> H.No-5-9-286/65,Plot No-65
>>> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>>> Hyderabad-500072,-Andhra Pradesh
>>> 91-9177-444-840**,*
>>>
>>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Need help

[Venkat CV]

Dear Sriram,

Look attached...as required...





On Thu, Feb 2, 2012 at 6:38 PM, sriram ji  wrote:

> Dear Excel Guru,
>
> Kindly provide the solution for the attached file.
>
> Thanks & Regards,
> Sriram G
> Chennai
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *
*
*
*
*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Sriram Need Help---Resolved.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ paste special problem

[dguillett1]

Show me.


Don Guillett
SalesAid Software
dguille...@gmail.com

From: danial mansoor 
Sent: Friday, February 03, 2012 3:07 PM
To: excel-macros@googlegroups.com 
Subject: RE: $$Excel-Macros$$ paste special problem


thanx,your work fine with with little changes.






From: dguille...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ paste special problem
Date: Fri, 3 Feb 2012 14:33:36 -0600


Run mine


Don Guillett
SalesAid Software
dguille...@gmail.com

From: danial mansoor 
Sent: Friday, February 03, 2012 2:09 PM
To: excel-macros@googlegroups.com 
Subject: RE: $$Excel-Macros$$ paste special problem

in this i have t select each sheet is there a way i run macro and every sheet 
get updated with values and no formula shown?bt plz consider huge file







Date: Fri, 3 Feb 2012 23:47:03 +0530
Subject: Re: $$Excel-Macros$$ paste special problem
From: vijayajith...@gmail.com
To: excel-macros@googlegroups.com

Hi mansoor, 

sub tex()
selection.value = selection.value
end sub



On Fri, Feb 3, 2012 at 9:08 PM, danial mansoor  wrote:

  i have a big file with many sheets i want to convert formula in values,if i 
do individually it will take lotes of time can any one tell me the macro which 
will work?

  Note:macro should work fine in huge file i have a macro which is working fine 
with small file but not in huge file urgent help will be appreciated.








--
  Date: Thu, 2 Feb 2012 09:21:22 +0530
  Subject: Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Index & Match Formula
  From: vijayendrar...@gmail.com
  To: excel-macros@googlegroups.com


  Hi Sam,

  Your formulas resolves my problem and thanks a lot for the same. Can you 
please let me know the logic behind of this formula.

  Rohan,
  I wanted to pick the employees name from the same project and Sam done it in 
right way.

  Regards,
  Vijayendra


  2012/2/1 Sam Mathai Chacko 

Here's the result.

I have also sorted the list based on project. Please confirm if that is 
what you are looking for.

Regards,
Sam Mathai Chacko 



On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao  
wrote:

  Dear All,

  I want to put index & match formula (or any other formula) in attached 
file, can you please help me to put the formula.

  Excel file is attached along with email.

  Regards,
  Vijayendra
  94491 67631

  -- 
  FORUM RULES (986+ 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. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com





-- 
Sam Mathai Chacko 


-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 

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




  -- 

  ಧನ್ಯವಾದಗಳು,
  ವಿಜಯೇಂದ್ರ,
  ೯೪೪೯೧ ೬೭೬೩೧

  Regards,
  Vijayendra
  94491 67631


  -- 
  FORUM RULES (986+ 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 bre

RE: $$Excel-Macros$$ paste special problem

[danial mansoor]

thanx,your work fine with with little changes.


From: dguille...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ paste special problem
Date: Fri, 3 Feb 2012 14:33:36 -0600









Run mine
 
 
Don 
Guillett
SalesAid Software
dguille...@gmail.com


 

From: danial mansoor 
Sent: Friday, February 03, 2012 2:09 PM
To: excel-macros@googlegroups.com 

Subject: RE: $$Excel-Macros$$ paste special 
problem
 

in this i have t select each sheet is there a way i run macro and 
every sheet get updated with values and no formula shown?bt plz consider huge 
file








Date: Fri, 3 Feb 2012 23:47:03 +0530
Subject: Re: $$Excel-Macros$$ paste 
special problem
From: vijayajith...@gmail.com
To: 
excel-macros@googlegroups.com

Hi mansoor, 
 
sub tex()
selection.value = selection.value
end sub



On Fri, Feb 3, 2012 at 9:08 PM, danial mansoor  
wrote:


  
  i have a big file with many sheets i want to convert formula in 
  values,if i do individually it will take lotes of time can any one tell me 
the 
  macro which will work?

Note:macro should work fine in huge file i have 
  a macro which is working fine with small file but not in huge file urgent 
help 
  will be appreciated.




  


  
  
  
  Date: Thu, 2 Feb 2012 09:21:22 +0530
Subject: Re: $$Excel-Macros$$ 
  $$Excel-Ma​cros$$ Index & Match Formula
From: vijayendrar...@gmail.com
To: excel-macros@googlegroups.com


  Hi Sam,
   
  Your formulas resolves my problem and thanks a lot for the same. Can you 
  please let me know the logic behind of this formula.
   
  Rohan,
  I wanted to pick the employees name from the same project and Sam done it 
  in right way.
   
  Regards,
  Vijayendra


  2012/2/1 Sam Mathai Chacko 

  Here's the result.

I have also 
sorted the list based on project. Please confirm if that is what you are 
looking for.

Regards,
Sam Mathai Chacko 





On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao  
wrote:


  Dear All,
   
  I want to put index & match formula (or any other formula) in 
  attached file, can you please help me to put the formula.
   
  Excel file is attached along with email.
   
  Regards,
Vijayendra
94491 67631
-- 
FORUM RULES 
  (986+ 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. 
 
NOTE : Don't ever post personal 
  or confidential data in a workbook. Forum owners and members are not 
  responsible for any 
  loss.
 
--
To 
  post to this group, send email to excel-macros@googlegroups.com


-- 
Sam Mathai 
Chacko 




-- 
FORUM RULES (986+ 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. 
 
NOTE : 
Don't ever post personal or confidential data in a workbook. Forum owners 
and members are not responsible for any 
loss.
 
--
To 
post to this group, send email to excel-macros@googlegroups.com


-- 

  ಧನ್ಯವಾದಗಳು,
  ವಿಜಯೇಂದ್ರ,
  ೯೪೪೯೧ ೬೭೬೩೧
   
  Regards,
Vijayendra
94491 67631

-- 
FORUM RULES 
  (986+ 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. 
  
 
NOTE : Don't ever post personal or confidential data in a 
  workbook. Forum owners and members are not responsible for any 
  loss.
 
-

Re: $$Excel-Macros$$ paste special problem

[dguillett1]

Run mine


Don Guillett
SalesAid Software
dguille...@gmail.com

From: danial mansoor 
Sent: Friday, February 03, 2012 2:09 PM
To: excel-macros@googlegroups.com 
Subject: RE: $$Excel-Macros$$ paste special problem

in this i have t select each sheet is there a way i run macro and every sheet 
get updated with values and no formula shown?bt plz consider huge file







Date: Fri, 3 Feb 2012 23:47:03 +0530
Subject: Re: $$Excel-Macros$$ paste special problem
From: vijayajith...@gmail.com
To: excel-macros@googlegroups.com

Hi mansoor, 

sub tex()
selection.value = selection.value
end sub



On Fri, Feb 3, 2012 at 9:08 PM, danial mansoor  wrote:

  i have a big file with many sheets i want to convert formula in values,if i 
do individually it will take lotes of time can any one tell me the macro which 
will work?

  Note:macro should work fine in huge file i have a macro which is working fine 
with small file but not in huge file urgent help will be appreciated.








--
  Date: Thu, 2 Feb 2012 09:21:22 +0530
  Subject: Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Index & Match Formula
  From: vijayendrar...@gmail.com
  To: excel-macros@googlegroups.com


  Hi Sam,

  Your formulas resolves my problem and thanks a lot for the same. Can you 
please let me know the logic behind of this formula.

  Rohan,
  I wanted to pick the employees name from the same project and Sam done it in 
right way.

  Regards,
  Vijayendra


  2012/2/1 Sam Mathai Chacko 

Here's the result.

I have also sorted the list based on project. Please confirm if that is 
what you are looking for.

Regards,
Sam Mathai Chacko 



On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao  
wrote:

  Dear All,

  I want to put index & match formula (or any other formula) in attached 
file, can you please help me to put the formula.

  Excel file is attached along with email.

  Regards,
  Vijayendra
  94491 67631

  -- 
  FORUM RULES (986+ 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. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com





-- 
Sam Mathai Chacko 


-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 

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




  -- 

  ಧನ್ಯವಾದಗಳು,
  ವಿಜಯೇಂದ್ರ,
  ೯೪೪೯೧ ೬೭೬೩೧

  Regards,
  Vijayendra
  94491 67631


  -- 
  FORUM RULES (986+ 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. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-ma

RE: $$Excel-Macros$$ paste special problem

[danial mansoor]

in this i have t select each sheet is there a way i run macro and every sheet 
get updated with values and no formula shown?bt plz consider huge file



Date: Fri, 3 Feb 2012 23:47:03 +0530
Subject: Re: $$Excel-Macros$$ paste special problem
From: vijayajith...@gmail.com
To: excel-macros@googlegroups.com

Hi mansoor,
sub tex()selection.value = selection.valueend sub

On Fri, Feb 3, 2012 at 9:08 PM, danial mansoor  wrote:





i have a big file with many sheets i want to convert formula in values,if i do 
individually it will take lotes of time can any one tell me the macro which 
will work?

Note:macro should work fine in huge file i have a macro which is working fine 
with small file but not in huge file urgent help will be appreciated.






Date: Thu, 2 Feb 2012 09:21:22 +0530
Subject: Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Index & Match Formula
From: vijayendrar...@gmail.com

To: excel-macros@googlegroups.com

Hi Sam,
 
Your formulas resolves my problem and thanks a lot for the same. Can you please 
let me know the logic behind of this formula.
 
Rohan,
I wanted to pick the employees name from the same project and Sam done it in 
right way.
 
Regards,
Vijayendra


2012/2/1 Sam Mathai Chacko 

Here's the result.

I have also sorted the list based on project. Please confirm if that is what 
you are looking for.


Regards,
Sam Mathai Chacko 





On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao  wrote:


Dear All,
 
I want to put index & match formula (or any other formula) in attached file, 
can you please help me to put the formula.
 
Excel file is attached along with email.
 
Regards,
Vijayendra
94491 67631

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


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




-- 
Sam Mathai Chacko 





-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


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




-- 

ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧
 
Regards,
Vijayendra
94491 67631





-- 

FORUM RULES (986+ 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. 

 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

 

--

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




-- 

FORUM RULES (986+ 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. 

 

NO

Re: $$Excel-Macros$$ Urgent Help

[dguillett1]

OK. Here is another way AFTER sorting the source table

INDEX(E:E,MATCH(I6,D:D))

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Friday, February 03, 2012 12:00 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Urgent Help

This should work 

=INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18<>OFFSET($D$5:$D$18,1,0),ROW(INDIRECT("1:"&ROWS($D$5:$D$18))),""),COUNTA($I$4:I4)))

Regards,

Sam Mathai Chacko
On Fri, Feb 3, 2012 at 11:06 PM, PRAVESH KUMAR  wrote:

  Hi,


  please help ASAP.

  please find attached sheet.


  Thanks

  Pravesh Kumar

  --
  FORUM RULES (986+ 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.

  NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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




-- 
Sam Mathai Chacko
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

$$Excel-Macros$$ formula in rate column

[raghu gr]

Hi experts,

I have a invoice file and summary file, i want the formula in rate column,
which has to pick from rate sheet.
please help me in this regard

Attached sample file

Thank you

with regards
Raghu

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


SAMPLEINVOICE.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ paste special problem

[vijayajith VA]

Hi mansoor,

sub tex()
selection.value = selection.value
end sub


On Fri, Feb 3, 2012 at 9:08 PM, danial mansoor wrote:

>  i have a big file with many sheets i want to convert formula in values,if
> i do individually it will take lotes of time can any one tell me the macro
> which will work?
>
> Note:macro should work fine in huge file i have a macro which is working
> fine with small file but not in huge file urgent help will be appreciated.
>
>
>
>
>
> --
> Date: Thu, 2 Feb 2012 09:21:22 +0530
> Subject: Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Index & Match Formula
> From: vijayendrar...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Sam,
>
> Your formulas resolves my problem and thanks a lot for the same. Can you
> please let me know the logic behind of this formula.
>
> Rohan,
> I wanted to pick the employees name from the same project and Sam done it
> in right way.
>
> Regards,
> Vijayendra
>
> 2012/2/1 Sam Mathai Chacko 
>
> Here's the result.
>
> I have also sorted the list based on project. Please confirm if that is
> what you are looking for.
>
> Regards,
> Sam Mathai Chacko
>
>
> On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao 
> wrote:
>
> Dear All,
>
> I want to put index & match formula (or any other formula) in attached
> file, can you please help me to put the formula.
>
> Excel file is attached along with email.
>
> Regards,
> Vijayendra
> 94491 67631
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
>
> --
> Sam Mathai Chacko
>
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
>
> --
> ಧನ್ಯವಾದಗಳು,
> ವಿಜಯೇಂದ್ರ,
> ೯೪೪೯೧ ೬೭೬೩೧
>
> Regards,
> Vijayendra
> 94491 67631
>
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ---

Re: $$Excel-Macros$$ Urgent Help

[NOORAIN ANSARI]

Dear Pravesh,

See attached sheet..

=SUMPRODUCT(($D$5:$D$18=K7)*($F$5:$F$18=2)*($E$5:$E$18))

On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko wrote:

> This should work
>
> =INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18<>OFFSET($D$5:$D$18,1,0),ROW(INDIRECT("1:"&ROWS($D$5:$D$18))),""),COUNTA($I$4:I4)))
> Regards,
>
> Sam Mathai Chacko
> On Fri, Feb 3, 2012 at 11:06 PM, PRAVESH KUMAR 
> wrote:
>
>> Hi,
>>
>>
>> please help ASAP.
>>
>> please find attached sheet.
>>
>>
>> Thanks
>>
>> Pravesh Kumar
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Copy of Question(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Urgent Help

[Sam Mathai Chacko]

I second Don. please keep in mind that the volunteers here 'lend' their
time to the forum to help. So it would be best to give that extra bit of
information in a clear and concise manner, so that it is easy for the
volunteers.

Sam

On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko wrote:

> This should work
>
> =INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18<>OFFSET($D$5:$D$18,1,0),ROW(INDIRECT("1:"&ROWS($D$5:$D$18))),""),COUNTA($I$4:I4)))
> Regards,
>
> Sam Mathai Chacko
> On Fri, Feb 3, 2012 at 11:06 PM, PRAVESH KUMAR 
> wrote:
>
>> Hi,
>>
>>
>> please help ASAP.
>>
>> please find attached sheet.
>>
>>
>> Thanks
>>
>> Pravesh Kumar
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Urgent Help

[Sam Mathai Chacko]

This should work
=INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18<>OFFSET($D$5:$D$18,1,0),ROW(INDIRECT("1:"&ROWS($D$5:$D$18))),""),COUNTA($I$4:I4)))
Regards,

Sam Mathai Chacko
On Fri, Feb 3, 2012 at 11:06 PM, PRAVESH KUMAR wrote:

> Hi,
>
>
> please help ASAP.
>
> please find attached sheet.
>
>
> Thanks
>
> Pravesh Kumar
>
> --
> FORUM RULES (986+ 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.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


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

Re: $$Excel-Macros$$ Urgent Help

[dguillett1]

It is nice to ask in the body of the email what you want. Always, tell us 
what you want and give examples. And, speaking for myself, the word URGENT 
only tends to make me NOT want to help, at least for free




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

Sent: Friday, February 03, 2012 11:36 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help

Hi,


please help ASAP.

please find attached sheet.


Thanks

Pravesh Kumar

--
FORUM RULES (986+ 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.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


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


--
FORUM RULES (986+ 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. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

$$Excel-Macros$$ Urgent Help

[PRAVESH KUMAR]

Hi,


please help ASAP.

please find attached sheet.


Thanks

Pravesh Kumar

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


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

Re: $$Excel-Macros$$ help

[vijayajith VA]

Thanks noorain;

On Fri, Feb 3, 2012 at 11:00 PM, NOORAIN ANSARI wrote:

> Dear Vijay,
>
> Please try through this UDF..
>
> Function Extract_number(rng As String)
> For i = 1 To Len(rng)
> If Mid(rng, i, 1) = "(" Then
> Extract_number = Extract_number & " " & Mid(rng, i + 1, 3)
> Extract_number = Application.WorksheetFunction.Trim(Extract_number)
> End If
> Next i
> End Function
>
> or
>
> Function extract_words(x As String)
> Dim z
> Dim rs As String
> z = Split(x, "(")
> For i = LBound(z) + 1 To UBound(z)
> rs = rs & Left(z(i), InStr(z(i), ")") - 1) & " "
> Next i
> extract_words = Application.WorksheetFunction.Trim(rs)
> End Function
>
>
> See attached sheet
>
>
> On Fri, Feb 3, 2012 at 10:34 PM, vijayajith VA wrote:
>
>> Hi Noorain,
>>
>> Please find the attached sheet.
>>
>> Thanks
>>
>>
>> On Fri, Feb 3, 2012 at 10:30 PM, vijayajith VA 
>> wrote:
>>
>>> Hi Noorain ansari,
>>>
>>> Data will be  floo see r eree s seer(A23),seruo serereserrser seeess
>>> kke(A89 ) =I need ans answer as A23,A89
>>>
>>> but if i use your formula i am getting A23 only .i need both A23,A89
>>>
>>>
>>>
>>> On Thu, Dec 29, 2011 at 11:33 AM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear  Vijay,

 You can  also try...

 =MID(A1,FIND("(",A1)+1,FIND(")",A1,1)-FIND("(",A1)-1)

 See attached sheet..



 --
 Thanks & regards,
 Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
 *http://noorain-ansari.blogspot.com/*
 -- Forwarded message --
 From: vijayajith VA 
 Date: Sun, Dec 25, 2011 at 3:01 PM
 Subject: $$Excel-Macros$$ help
 To: excel-macros@googlegroups.com


 Hi ,

 i have some data like 1) floo see r eree s seer(A23),seruo
 serereserrser seeess kke(A89)
 2) folow re e ser se ser(S89)

 I want to extract only nos inside the bracket


 please suggest me for some formula or code

 Thanks

 --
 FORUM RULES (934+ 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.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


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



  --
 FORUM RULES (934+ 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.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


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

>>>
>>>
>>  --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain

Re: $$Excel-Macros$$ help

[vijayajith VA]

Hi Noorain,

Please find the attached sheet.

Thanks

On Fri, Feb 3, 2012 at 10:30 PM, vijayajith VA wrote:

> Hi Noorain ansari,
>
> Data will be  floo see r eree s seer(A23),seruo serereserrser seeess
> kke(A89 ) =I need ans answer as A23,A89
>
> but if i use your formula i am getting A23 only .i need both A23,A89
>
>
>
> On Thu, Dec 29, 2011 at 11:33 AM, NOORAIN ANSARI  > wrote:
>
>> Dear  Vijay,
>>
>> You can  also try...
>>
>> =MID(A1,FIND("(",A1)+1,FIND(")",A1,1)-FIND("(",A1)-1)
>>
>> See attached sheet..
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>> -- Forwarded message --
>> From: vijayajith VA 
>> Date: Sun, Dec 25, 2011 at 3:01 PM
>> Subject: $$Excel-Macros$$ help
>> To: excel-macros@googlegroups.com
>>
>>
>> Hi ,
>>
>> i have some data like 1) floo see r eree s seer(A23),seruo serereserrser
>> seeess kke(A89)
>> 2) folow re e ser se ser(S89)
>>
>> I want to extract only nos inside the bracket
>>
>>
>> please suggest me for some formula or code
>>
>> Thanks
>>
>> --
>> FORUM RULES (934+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>>
>>
>>  --
>> FORUM RULES (934+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


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

Re: $$Excel-Macros$$ help

[vijayajith VA]

Hi Noorain ansari,

Data will be  floo see r eree s seer(A23),seruo serereserrser seeess kke(A89 )
=I need ans answer as A23,A89

but if i use your formula i am getting A23 only .i need both A23,A89



On Thu, Dec 29, 2011 at 11:33 AM, NOORAIN ANSARI
wrote:

> Dear  Vijay,
>
> You can  also try...
>
> =MID(A1,FIND("(",A1)+1,FIND(")",A1,1)-FIND("(",A1)-1)
>
> See attached sheet..
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> -- Forwarded message --
> From: vijayajith VA 
> Date: Sun, Dec 25, 2011 at 3:01 PM
> Subject: $$Excel-Macros$$ help
> To: excel-macros@googlegroups.com
>
>
> Hi ,
>
> i have some data like 1) floo see r eree s seer(A23),seruo serereserrser
> seeess kke(A89)
> 2) folow re e ser se ser(S89)
>
> I want to extract only nos inside the bracket
>
>
> please suggest me for some formula or code
>
> Thanks
>
> --
> FORUM RULES (934+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
>  --
> FORUM RULES (934+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ To excel macro team

[NOORAIN ANSARI]

Dear Pascal,

Check below link..

http://www.discussexcel.com/contact-me

On Thu, Feb 2, 2012 at 3:18 AM, Pascal Baro  wrote:

> Hi,
> I'm not receiving mail summary from group posting anymore. Is there any
> reasons?
> Regards,
> Pascal
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ paste special problem

[dguillett1]

Probably the most efficient to do only those with formulas

option explicit
Sub dovalues()
dim ws as worksheet
For Each ws In ActiveWorkbook.Sheets
With ws.Cells.SpecialCells(xlCellTypeFormulas)
  .value = .Value
End With
Next ws
End Sub

Don Guillett
SalesAid Software
dguille...@gmail.com

From: danial mansoor 
Sent: Friday, February 03, 2012 9:38 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ paste special problem

i have a big file with many sheets i want to convert formula in values,if i do 
individually it will take lotes of time can any one tell me the macro which 
will work?

Note:macro should work fine in huge file i have a macro which is working fine 
with small file but not in huge file urgent help will be appreciated.









Date: Thu, 2 Feb 2012 09:21:22 +0530
Subject: Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Index & Match Formula
From: vijayendrar...@gmail.com
To: excel-macros@googlegroups.com


Hi Sam,

Your formulas resolves my problem and thanks a lot for the same. Can you please 
let me know the logic behind of this formula.

Rohan,
I wanted to pick the employees name from the same project and Sam done it in 
right way.

Regards,
Vijayendra


2012/2/1 Sam Mathai Chacko 

  Here's the result.

  I have also sorted the list based on project. Please confirm if that is what 
you are looking for.

  Regards,
  Sam Mathai Chacko 



  On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao  
wrote:

Dear All,

I want to put index & match formula (or any other formula) in attached 
file, can you please help me to put the formula.

Excel file is attached along with email.

Regards,
Vijayendra
94491 67631

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 

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





  -- 
  Sam Mathai Chacko 


  -- 
  FORUM RULES (986+ 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. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com




-- 

ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧

Regards,
Vijayendra
94491 67631


-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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 r

$$Excel-Macros$$ paste special problem

[danial mansoor]

i have a big file with many sheets i want to convert formula in values,if i do 
individually it will take lotes of time can any one tell me the macro which 
will work?

Note:macro should work fine in huge file i have a macro which is working fine 
with small file but not in huge file urgent help will be appreciated.





Date: Thu, 2 Feb 2012 09:21:22 +0530
Subject: Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Index & Match Formula
From: vijayendrar...@gmail.com
To: excel-macros@googlegroups.com

Hi Sam,
 
Your formulas resolves my problem and thanks a lot for the same. Can you please 
let me know the logic behind of this formula.
 
Rohan,
I wanted to pick the employees name from the same project and Sam done it in 
right way.
 
Regards,
Vijayendra


2012/2/1 Sam Mathai Chacko 

Here's the result.

I have also sorted the list based on project. Please confirm if that is what 
you are looking for.


Regards,
Sam Mathai Chacko 





On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao  wrote:


Dear All,
 
I want to put index & match formula (or any other formula) in attached file, 
can you please help me to put the formula.
 
Excel file is attached along with email.
 
Regards,
Vijayendra
94491 67631
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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



-- 
Sam Mathai Chacko 




-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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



-- 

ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧
 
Regards,
Vijayendra
94491 67631




-- 

FORUM RULES (986+ 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. 

 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

 

--

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

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

[Darwin Chan]

Sorry for the late reply, Rajan could you explain your code for pivot
table? where can i find / download the BU list.xlsx?

2012/1/23 rekha siri 

> Rajan i could able to find out the root cause.
>
> i deleted sub delete module below and call delete function line
> now its working fine
>
> Thanks,
> Rekha
>
>
> On Sun, Jan 22, 2012 at 11:10 PM, rekha siri wrote:
>
>> rajan i dint remove summary sheet and raw data sheet but still its not
>> executing.
>>
>> only rest of sheets were deleted bt its opening bu list and stopping there
>>
>>
>> On Sun, Jan 22, 2012 at 6:10 PM, Rajan_Verma wrote:
>>
>>> Hi rekha.
>>>
>>> I clearly mention that don’t delete the summarySheet..
>>>
>>> Rajan.
>>>
>>> ** **
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
>>> *Sent:* Jan/Sun/2012 04:47
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot using
>>> vba
>>>
>>> ** **
>>>
>>> Rajan,
>>>
>>> ** **
>>>
>>> i Tried removing the sheets and tried executing this macro bt it is not
>>> executing.
>>>
>>> ** **
>>>
>>> Please fix this...
>>>
>>> ** **
>>>
>>> Thanks alot for your help in this concern.
>>>
>>> On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma 
>>> wrote:
>>>
>>> Hi Rekha
>>>
>>> See the attached sheet..
>>>
>>> Don’t delete SUmmarySheet
>>>
>>>  
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
>>> *Sent:* Jan/Sat/2012 08:51
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba**
>>> **
>>>
>>>  
>>>
>>> can any one kindly help on this please.
>>>
>>> -- Forwarded message --
>>> From: *rekha siri* 
>>> Date: Wed, Jan 18, 2012 at 9:59 PM
>>> Subject: Need help in building pivot using vba
>>> To: excel-macros@googlegroups.com
>>>
>>>
>>> hi experts,
>>>
>>>  
>>>
>>> Please provide the code to build pivot using vba
>>>
>>>  
>>>
>>> this macro is provided to me in past by rajan really  thank full for the
>>> concern. 
>>>
>>>  
>>>
>>> adding to that i need to prepare pivot for  west bu  from attached macro
>>> raw data sheet.
>>>
>>>  
>>>
>>> pivot format is also attached it should be as per West december2011
>>> file's pivot manner.
>>>
>>>  
>>>
>>> attached are macro and west december workbooks which contain pivot ..***
>>> *
>>>
>>>  
>>>
>>>  
>>>
>>>  
>>>
>>> kindly help in this concern thanks.
>>>
>>>  
>>>
>>> Rekha
>>>
>>>  
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> ** **
>>>
>>> --
>>> FORUM RULES (986+ 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.

Re: $$Excel-Macros$$ Pivot Table from two separate sheets

[NOORAIN ANSARI]

If you are using excel 2007+ then install this add-in

On Fri, Feb 3, 2012 at 6:18 PM, B Sharma  wrote:

> Hello Friends.
> I have two sheets For E.g.
> 1. Opening Balances and purchases of goods
> 2. Consumption of goods
>
> Both the sheets will contain many colours like.
> purchase date,consumption date,  inv. no. party name., item, qty. ,
> values, etc.
>
>
>
> Now I need to create a Pivot table, in which it will look like
> this
>
> Month  -  Op. Bal. - Purchase - Consumption - Cl.Bal.
>
> I need to import the data from two separate sheets here and show
> report in one report.
>
> Thanks & Regards,
> BS
>
> --
> FORUM RULES (986+ 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.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Excel2003_Style_Menu.xlam
Description: Binary data

Re: $$Excel-Macros$$ Re: Syntax request: the array that holds grouped tabs

[DaveO]

That's what I'm looking for, thanks Kris and Don!

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Re: Syntax request: the array that holds grouped tabs

[dguillett1]

Or

Sub selectedsheetsnames()
dim sh as worksheet
For Each sh In ActiveWorkbook.Windows(1).SelectedSheets
   MsgBox sh.Name
Next sh
End Sub

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Kris 
Sent: Friday, February 03, 2012 3:50 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Re: Syntax request: the array that holds grouped tabs

Hi

Sub kTest()

Dim i   As Long, c  As Long, ShtAs String

With ActiveWindow
c = .SelectedSheets.Count
If c Then
For i = 1 To c
Sht = Sht & vbLf & .SelectedSheets(i).Name
Next
MsgBox "The following Sheet(s) are selected" & vbLf & Sht
End If
End With

End Sub

Kris

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Match in Rows

[dguillett1]

Look in the help index for MATCH



Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: qcan

Sent: Thursday, February 02, 2012 11:00 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Match in Rows

Hi,

Not sure how to do this.

Looking for a formula (preferably) or a macro to find a number in a
row. Kind of like a "loto checker".

In this case.

- There are 20 columns per row. (A1 to T1)
- Numbers are not neccesarily sorted.
- There could possibly be the same number showing up multiple times
within the 20 columns being checked.
- Would like to be able to enter the number to be checked in cell
AA1.
- Would like the counter to be returned in cell AB1 if/when a match
has been encountered.
- Leave blank (not zero) if number is not found.

Many Thanks.

--
FORUM RULES (986+ 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.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


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


--
FORUM RULES (986+ 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. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Pivot Table from two separate sheets

[Shaik Waheed]

Hi, can u send a sample data sheet

On Fri, Feb 3, 2012 at 6:18 PM, B Sharma  wrote:

> Hello Friends.
> I have two sheets For E.g.
> 1. Opening Balances and purchases of goods
> 2. Consumption of goods
>
> Both the sheets will contain many colours like.
> purchase date,consumption date,  inv. no. party name., item, qty. ,
> values, etc.
>
>
>
> Now I need to create a Pivot table, in which it will look like
> this
>
> Month  -  Op. Bal. - Purchase - Consumption - Cl.Bal.
>
> I need to import the data from two separate sheets here and show
> report in one report.
>
> Thanks & Regards,
> BS
>
> --
> FORUM RULES (986+ 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.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

$$Excel-Macros$$ Pivot Table from two separate sheets

[B Sharma]

Hello Friends.
I have two sheets For E.g.
1. Opening Balances and purchases of goods
2. Consumption of goods

Both the sheets will contain many colours like.
purchase date,consumption date,  inv. no. party name., item, qty. ,
values, etc.



Now I need to create a Pivot table, in which it will look like
this

Month  -  Op. Bal. - Purchase - Consumption - Cl.Bal.

I need to import the data from two separate sheets here and show
report in one report.

Thanks & Regards,
BS

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Formula need

[chandra sekaran]

Thanks Noorin,



On Fri, Feb 3, 2012 at 3:21 PM, NOORAIN ANSARI wrote:

> Dear Chandra,
>
> Please use..
>
> =VLOOKUP(C3,$C$9:$H$13,MATCH($C$1,$C$7:$H$7,0),0)
> or
> =SUMPRODUCT((PROD=C3)*($D$7:$H$7=C1)*($D$9:$H$13))
> or
> =INDEX($D$9:$H$13,MATCH(C3,PROD,0),MATCH(C1,$D$7:$H$7,0))
>
> See attached Sheet.
>
>
> On Fri, Feb 3, 2012 at 3:13 PM, chandra sekaran wrote:
>
>> Hi Noorin
>>
>> Excell Sheet attached
>>
>> Chandru
>>
>>
>>
>>
>> On Fri, Feb 3, 2012 at 3:02 PM, NOORAIN ANSARI 
>> wrote:
>>
>>> Dear Chandra,
>>>
>>> Please share sample sheet
>>>
>>>   On Fri, Feb 3, 2012 at 2:37 PM, chandra sekaran <
>>> duraichan...@gmail.com> wrote:
>>>
 Dear all,

 Sheet 1  having below data  Month wise  product details  sheet 2   if
 i select  Jan -12 then  Product  A  selection   qty will come  100what
 is the formula  any one help me


  Jan-12 Feb-12 Mar-12 Apr-12 May-12   * * * *
   * * PRODUCT A 100   * * PRODUCT B * * PRODUCT
 C * * PRODUCT D * * PRODUCT F * *

 SHEET1


  MONTH Jan-12   QTY PRODUCT A 100
  SHEET2


  Regards
 chandru












 --
 FORUM RULES (986+ 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.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


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

>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>  
>>> *http://excelmacroworld.blogspot.com/*
>>> *http://noorain-ansari.blogspot.com/*
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> --
> FORUM RULES (986+ 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 receiv

Re: $$Excel-Macros$$ Re: Copy of excel files to 1 excel file with excel file name -Solve Problem

[Veeru TOC]

>
>
>>
>>
>>> Dear Group
>>>
>>>   One folder of some excel file is there ,every excel file has Time
>>>
>>>  i nedd total folder excel file data copy 1 excel file but In start A
>>> column i need Excel name how is it possible
>>> plz find attachment of folder of excel files & Req data 
>>>
>>>
>>>
>>>
>>>
>>> *Thanks&Regards*
>>>
>>> **
>>>
>>> ***Veerendra.Vanam*
>>>
>>> *TOC TEAM*
>>> ***Bhagyanagar Electrical & Contractors**
>>> H.No-5-9-286/65,Plot No-65
>>> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>>> Hyderabad-500072,-Andhra Pradesh
>>> 91-9177-444-840**,*
>>> On
>>>



 --
 FORUM RULES (986+ 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.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


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

>>>
>>>
>>>
>>> --
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>> --
>>
>>
>>
>>
>>
>> * *
>>
>>
>>
>>
>> --
>>
>>
>>
>>
>>
>> *Thanks&Regards*
>>
>> * *
>>
>> *   **Veerendra.Vanam*
>>
>>   *TOC TEAM*
>> * *  *Bhagyanagar Electrical & Contractors**
>> ****H.No-5-9-286/65,Plot No-65
>> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>>   Hyderabad-500072,-Andhra Pradesh
>> **   **91-9177-444-840**,*
>>
>>
>>
>
>
> --
>
>
>
>
>
> *Thanks&Regards*
>
> * *
>
> *   **Veerendra.Vanam*
>
>   *TOC TEAM*
> * *  *Bhagyanagar Electrical & Contractors**
> ****H.No-5-9-286/65,Plot No-65
> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>   Hyderabad-500072,-Andhra Pradesh
> **   **91-9177-444-840**,*
>
>
>


-- 





*Thanks&Regards*

* *

*   **Veerendra.Vanam*

  *TOC TEAM*
* *  *Bhagyanagar Electrical & Contractors**
****H.No-5-9-286/65,Plot No-65
Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
  Hyderabad-500072,-Andhra Pradesh
**   **91-9177-444-840**,*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

[The Viper]

please find the attached



On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:

>
> Dear Experts,
>
> Please See the attachment and Help me regarding VLOOKUP FUNCTION
>
> Thanking you in Advance
>
> Sanjib
>
>
>
>
>
>
>
>
>
> --
> -
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*Great day,*
*viper*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


VLOOKUP_FUNCTION.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

[Kal xcel]

Brother (I always called Noorain by this),

Heartiest congratulation to you.you are not only an expert in
excel...There are few nice people in this world..YOU ARE ONE OF
THEM.

I am really happy for your achievement.keep it up.

Congratulation once again.
-- 
*Kalyan Chattopadhyay*

*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Values before "_"

[Kris]

Hi
 
=LEFT(A2,FIND("_",A2&"_")-1)
 
Kris
 

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

$$Excel-Macros$$ Re: Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

[Kris]

Hi,
 
Arrange your table like this.
 
   Mark Grade Ramarks 1 e Poor 41 d Average 51 c Good 61 b Very Good 71 a 

Excelient

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Formula need

[NOORAIN ANSARI]

Dear Chandra,

Please use..

=VLOOKUP(C3,$C$9:$H$13,MATCH($C$1,$C$7:$H$7,0),0)
or
=SUMPRODUCT((PROD=C3)*($D$7:$H$7=C1)*($D$9:$H$13))
or
=INDEX($D$9:$H$13,MATCH(C3,PROD,0),MATCH(C1,$D$7:$H$7,0))

See attached Sheet.


On Fri, Feb 3, 2012 at 3:13 PM, chandra sekaran wrote:

> Hi Noorin
>
> Excell Sheet attached
>
> Chandru
>
>
>
>
> On Fri, Feb 3, 2012 at 3:02 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Chandra,
>>
>> Please share sample sheet
>>
>>   On Fri, Feb 3, 2012 at 2:37 PM, chandra sekaran > > wrote:
>>
>>> Dear all,
>>>
>>> Sheet 1  having below data  Month wise  product details  sheet 2   if
>>> i select  Jan -12 then  Product  A  selection   qty will come  100what
>>> is the formula  any one help me
>>>
>>>
>>>  Jan-12 Feb-12 Mar-12 Apr-12 May-12   * * * *
>>>   * * PRODUCT A 100   * * PRODUCT B * * PRODUCT
>>> C * * PRODUCT D * * PRODUCT F * *
>>>
>>> SHEET1
>>>
>>>
>>>  MONTH Jan-12   QTY PRODUCT A 100
>>>  SHEET2
>>>
>>>
>>>  Regards
>>> chandru
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

-

$$Excel-Macros$$ Re: Syntax request: the array that holds grouped tabs

[Kris]

Hi
 
Sub kTest()

Dim i   As Long, c  As Long, ShtAs String

With ActiveWindow
c = .SelectedSheets.Count
If c Then
For i = 1 To c
Sht = Sht & vbLf & .SelectedSheets(i).Name
Next
MsgBox "The following Sheet(s) are selected" & vbLf & Sht
End If
End With

End Sub
 
Kris
 

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Formula need

[chandra sekaran]

Hi Noorin

Excell Sheet attached

Chandru




On Fri, Feb 3, 2012 at 3:02 PM, NOORAIN ANSARI wrote:

> Dear Chandra,
>
> Please share sample sheet
>
>   On Fri, Feb 3, 2012 at 2:37 PM, chandra sekaran 
> wrote:
>
>> Dear all,
>>
>> Sheet 1  having below data  Month wise  product details  sheet 2   if   i
>> select  Jan -12 then  Product  A  selection   qty will come  100what is
>> the formula  any one help me
>>
>>
>>  Jan-12 Feb-12 Mar-12 Apr-12 May-12   * * * *
>> * * PRODUCT A 100   * * PRODUCT B * * PRODUCT
>> C * * PRODUCT D * * PRODUCT F * *
>>
>> SHEET1
>>
>>
>>  MONTH Jan-12   QTY PRODUCT A 100
>>  SHEET2
>>
>>
>>  Regards
>> chandru
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


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

Re: $$Excel-Macros$$ Formula need

[NOORAIN ANSARI]

Dear Chandra,

Please share sample sheet

On Fri, Feb 3, 2012 at 2:37 PM, chandra sekaran wrote:

> Dear all,
>
> Sheet 1  having below data  Month wise  product details  sheet 2   if   i
> select  Jan -12 then  Product  A  selection   qty will come  100what is
> the formula  any one help me
>
>
>  Jan-12 Feb-12 Mar-12 Apr-12 May-12   * * * *
> * * PRODUCT A 100   * * PRODUCT B * * PRODUCT
> C * * PRODUCT D * * PRODUCT F * *
>
> SHEET1
>
>
>  MONTH Jan-12   QTY PRODUCT A 100
>  SHEET2
>
>
>  Regards
> chandru
>
>
>
>
>
>
>
>
>
>
>
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

$$Excel-Macros$$ Formula need

[chandra sekaran]

Dear all,

Sheet 1  having below data  Month wise  product details  sheet 2   if   i
select  Jan -12 then  Product  A  selection   qty will come  100what is
the formula  any one help me


 Jan-12 Feb-12 Mar-12 Apr-12 May-12   * * * *
  * * PRODUCT A 100   * * PRODUCT B * * PRODUCT C
  * * PRODUCT D * * PRODUCT F * *

SHEET1


 MONTH Jan-12   QTY PRODUCT A 100
 SHEET2


 Regards
chandru

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ sheet reference from cell

[hemal shah]

Thanks for your kind support and solutions.

flower to you all,, made by me



-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ sheet reference from cell

[NOORAIN ANSARI]

Dear Hemal,

I think Krish solution is perfect for your query..

On Fri, Feb 3, 2012 at 2:29 PM, NOORAIN ANSARI wrote:

> Dear Hemal,
>
> Please try it..
>
>
> =VLOOKUP(MAX(INDIRECT("'"&A1&"'!$D$2:$D$11")),INDIRECT("'"&A1&"'!$D$1:$G$11"),4,0)
>
> See attached sheet..
>
>  On Fri, Feb 3, 2012 at 1:34 PM, hemal shah  wrote:
>
>>
>>
>> Now in this attachment,
>> First sheet is "Summary of Raw Material"
>> First Column contains list of sheets .
>> In Cell B2, I have used following formula
>>
>>   "=VLOOKUP(MAX('*EN8 BRIGHT  DIA 28*'!$D$2:$D$11),'*EN8 BRIGHT  DIA 28*
>> '!$D$1:$G$11,4)"
>>
>> Now in this formula, I want to use sheet reference ("'*EN8 BRIGHT  DIA
>> 28") *, which is column *A*.
>>
>> I think , this will clear my idea .
>>
>> Thanking You
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>  --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

[NOORAIN ANSARI]

Thank you very much to all of you.

On Fri, Feb 3, 2012 at 2:01 PM, Ankit Agrawal wrote:

> HI Ayush,
>
> I think, Mr. Noorain has already achieved this. I do not sure about the
> month but indeed, he has achieved it
>
>  On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote:
>
>>  Hello Everyone,
>>
>> Noorain Ansari has been selected as 'Most Helpful Member' for the month
>> of Jan'12
>> He has posted 175 posts in Jan'12 and helped many people through his
>> expertise. He has been consistent contributor to this excel forum but has
>> acheived this recognition for first time.
>>
>> *About Noorain Ansari :*
>> [image: noorain.jpg]
>>
>> Noorain is a great poet and keep sharing his thoughts on different topics
>> throgh cool poems. Professionally, he is a Excel aficionado and presently
>> working as senior business analyst in One97 Communication Ltd. He is a MS
>> excel - vba expert and keep sharing his thoughts with this forum. You can
>> follow his blogs for Excel knowledge and cool poems :
>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>
>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>
>> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
>> , Priyanka, Lokesh and other folks for helping excel enthusiasts
>> voluntarily !! Keep it up !!
>> **
>> *Keep posting.
>>
>> Regards
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

[Ankit Agrawal]

HI Ayush,

I think, Mr. Noorain has already achieved this. I do not sure about the
month but indeed, he has achieved it

On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain  wrote:

> Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Jan'12
> He has posted 175 posts in Jan'12 and helped many people through his
> expertise. He has been consistent contributor to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
> , Priyanka, Lokesh and other folks for helping excel enthusiasts
> voluntarily !! Keep it up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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