$$Excel-Macros$$ Code in the userform for date validation not working properly

[santosh subudhi]

Hi All,

In the user form I have coded a date validation which should take data for
current date or the previous date only with the help of *calendar only*.

However, the code is not working properly.

Moreover in the textbox3 I want it to restrict it only for numbers and no
character should be allowed to be entered for which I need help.

-- 
Regards
Santosh
santoshkumar.subu...@gmail.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


Testing.xlsm
Description: Binary data

$$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

[Sanjib Chatterjee]

Dear Members,

Would you please help regarding How to open a excel file saved on 2007
format in 2003 format


Thanking you in Advance

Sanjib

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

Re: $$Excel-Macros$$ Help me with a macro

[son nguyen]

Hi Rajan,

Thank you very much but i like macro better because it is really fast.As
you known my sheet is large with lots of rows.

Hope that  your experience'll help everyone .

Regards
Son

2011/11/27 rajan verma 

>  Hi
> Please see the attached file.. Pivot table can be used for this ..
>
> Regards
> Rajan
>
>  On Sat, Nov 26, 2011 at 8:23 PM, son nguyen wrote:
>
>> Dear all,
>>
>>
>> I have problem of calculating sheet.Detail as sheet attached.
>> I want to have a macro to sum value within qty, and downtime column then
>> delete products are duplicated within each machine.
>>
>> I look foward to hear your help asap
>>
>>
>> Best Regards
>> Son
>>
>> --
>> 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
>>
>
>
>
> --
> Regards
> Rajan verma
> +91 9158998701
>
> --
> 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
>



-- 
Best Regards
Son

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

Re: $$Excel-Macros$$ Help me with a macro

[son nguyen]

Hi Mr Sam.
I wonder this code used for which office as 2003,2007,2010.Because my
office is 2003 and result  is not to like my desirement.

Hope that you can feed back more to me

Regards
son

2011/11/27 Sam Mathai Chacko 

> Here's a macro to get this done
>
> Sub Consolidator()
>
> Dim rngStart As Range
>
> Application.ScreenUpdating = 0
> Range("F1").CurrentRegion.Clear
> With Cells.Find(What:="Machine", Lookat:=xlWhole,
> searchDirection:=xlNext, After:=Cells(1))
> Set rngStart = Range(.Offset(1), .Offset(, 1).End(xlDown).Offset(, -1))
> End With
> On Error Resume Next
> rngStart.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=r[-1]c"
> Err.Clear: On Error GoTo -1: On Error GoTo 0
> With Range("F1")
> .Resize(rngStart.Rows.Count + 1, 2).Value =
> rngStart(0).Resize(rngStart.Rows.Count + 1, 2).Value
> .CurrentRegion.RemoveDuplicates Columns:=Array(1, 2), Header:=xlYes
> .Offset(, 2).Resize(1, 2).Value = rngStart(0).Offset(,
> 2).Resize(1, 2).Value
> With .Offset(1, 2).Resize(.CurrentRegion.Rows.Count - 1, 2)
> .Formula = "=SUMPRODUCT(--(" & rngStart.Address & "=$F2),--("
> & rngStart.Offset(, 1).Address & "=$G2)," & rngStart.Offset(, 2).Address(1,
> 0) & ")"
> .Value = .Value
> End With
> End With
> On Error Resume Next
> rngStart.SpecialCells(xlCellTypeFormulas).ClearContents
> Err.Clear: On Error GoTo -1: On Error GoTo 0
> Application.ScreenUpdating = 1
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Sun, Nov 27, 2011 at 6:40 PM, rajan verma wrote:
>
>>  Hi
>> Please see the attached file.. Pivot table can be used for this ..
>>
>> Regards
>> Rajan
>>
>>  On Sat, Nov 26, 2011 at 8:23 PM, son nguyen wrote:
>>
>>> Dear all,
>>>
>>>
>>> I have problem of calculating sheet.Detail as sheet attached.
>>> I want to have a macro to sum value within qty, and downtime column then
>>> delete products are duplicated within each machine.
>>>
>>> I look foward to hear your help asap
>>>
>>>
>>> Best Regards
>>> Son
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Regards
>> Rajan verma
>> +91 9158998701
>>
>> --
>> 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
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> 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
>



-- 
Best Regards
Son

-- 
FORUM RULES (934+ members already BANNED for violation)

Re: $$Excel-Macros$$ Almost all calculator in one sheet

[Amit Gandhi]

very useful sheet. thanks for sharing.

On Mon, Nov 28, 2011 at 12:20 PM, NOORAIN ANSARI
wrote:

> Thanks Ankit,
>
> Very useful sheet you have shared with Group.
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal <
> ankit.agrawal...@gmail.com> wrote:
>
>> Hello All,
>>
>> In our daily life we calculate so many thing & use different calculator.
>> Here is one excel file which contain almost all calculator.
>>
>>
>> Calculate & enjoy !!!
>>
>>
>> Regards,
>>
>> Ankit
>>
>> --
>> 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
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

Re: $$Excel-Macros$$ Help me with a macro

[Sam Mathai Chacko]

Son, the macro is written for 2007-10. Will send a modified version,
but before that, can you confirm the result is correct in 2007-10? If
not, what is the issue?

Sam

On 28/11/2011, son nguyen  wrote:
> Hi Mr Sam.
> I wonder this code used for which office as 2003,2007,2010.Because my
> office is 2003 and result  is not to like my desirement.
>
> Hope that you can feed back more to me
>
> Regards
> son
>
> 2011/11/27 Sam Mathai Chacko 
>
>> Here's a macro to get this done
>>
>> Sub Consolidator()
>>
>> Dim rngStart As Range
>>
>> Application.ScreenUpdating = 0
>> Range("F1").CurrentRegion.Clear
>> With Cells.Find(What:="Machine", Lookat:=xlWhole,
>> searchDirection:=xlNext, After:=Cells(1))
>> Set rngStart = Range(.Offset(1), .Offset(, 1).End(xlDown).Offset(,
>> -1))
>> End With
>> On Error Resume Next
>> rngStart.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=r[-1]c"
>> Err.Clear: On Error GoTo -1: On Error GoTo 0
>> With Range("F1")
>> .Resize(rngStart.Rows.Count + 1, 2).Value =
>> rngStart(0).Resize(rngStart.Rows.Count + 1, 2).Value
>> .CurrentRegion.RemoveDuplicates Columns:=Array(1, 2),
>> Header:=xlYes
>> .Offset(, 2).Resize(1, 2).Value = rngStart(0).Offset(,
>> 2).Resize(1, 2).Value
>> With .Offset(1, 2).Resize(.CurrentRegion.Rows.Count - 1, 2)
>> .Formula = "=SUMPRODUCT(--(" & rngStart.Address & "=$F2),--("
>> & rngStart.Offset(, 1).Address & "=$G2)," & rngStart.Offset(,
>> 2).Address(1,
>> 0) & ")"
>> .Value = .Value
>> End With
>> End With
>> On Error Resume Next
>> rngStart.SpecialCells(xlCellTypeFormulas).ClearContents
>> Err.Clear: On Error GoTo -1: On Error GoTo 0
>> Application.ScreenUpdating = 1
>>
>> End Sub
>>
>> Regards,
>>
>> Sam Mathai Chacko
>>
>>
>> On Sun, Nov 27, 2011 at 6:40 PM, rajan verma
>> wrote:
>>
>>>  Hi
>>> Please see the attached file.. Pivot table can be used for this ..
>>>
>>> Regards
>>> Rajan
>>>
>>>  On Sat, Nov 26, 2011 at 8:23 PM, son nguyen
>>> wrote:
>>>
 Dear all,


 I have problem of calculating sheet.Detail as sheet attached.
 I want to have a macro to sum value within qty, and downtime column then
 delete products are duplicated within each machine.

 I look foward to hear your help asap


 Best Regards
 Son

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

>>>
>>>
>>>
>>> --
>>> Regards
>>> Rajan verma
>>> +91 9158998701
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>> --
>> 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 e

Re: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

[Sam Mathai Chacko]

There is an office 2003 compatibility installation file that can be
downloaded from microsoft site. Just search for the installation
package, and install. even after installing that, you would still not
be able to view data in rows beyond 65536 or columns IV.

Regards
Sam Mathai Chacko

On 28/11/2011, Sanjib Chatterjee  wrote:
> Dear Members,
>
> Would you please help regarding How to open a excel file saved on 2007
> format in 2003 format
>
>
> Thanking you in Advance
>
> Sanjib
>
> --
> 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
>

-- 
Sent from my mobile device

Sam Mathai Chacko

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

Re: $$Excel-Macros$$ Thank You the Group----Other MS Office application group

[Sam Mathai Chacko]

http://www.excelfox.com/forum

This is a bulletin board. Not one like googlegroup, but have ppt, word
and outlook forums.

Sam Mathai Chacko

On 28/11/2011, Amit Desai (MERU)  wrote:
> Dear All,
>
> On part of Thanks Giving day...let me thank you from the depth of my
> heart... to all the masters & participant of the group because of whom we
> get to learn many things..because of which our task becomes easy..
>
> Just wondering if there any group similar to ours for MS Power point, word &
> Outlook?
>
> Regards,
> Amit Desai
>
>
> 
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> 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
>

-- 
Sent from my mobile device

Sam Mathai Chacko

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

Re: $$Excel-Macros$$ Combo box to have and auto populate worksheet names

[Yahya Muhammad]

Thanks Noorain and Ashish


On Mon, Nov 28, 2011 at 10:58 AM, NOORAIN ANSARI
wrote:

> Dear Yahya,
>
> Please check attached sheet with Userform.
>
>
> On Mon, Nov 28, 2011 at 12:47 PM, Yahya Muhammad wrote:
>
>> Thanks Ashish. It does the trick. Just one more question. Instead of
>> providing the combo box in a worksheet, If I want to keep the combo box in
>> a user form (which should open with the file) , how the code will look
>> like?.
>>
>>
>> On Mon, Nov 28, 2011 at 9:48 AM, ashish koul wrote:
>>
>>> use in
>>>
>>> Private Sub Worksheet_Activate()
>>> Sheet1.ComboBox1.Clear
>>> Dim sh As Worksheet
>>> For Each sh In Worksheets
>>> Sheet1.ComboBox1.AddItem (sh.Name)
>>> Next
>>> End Sub
>>>
>>> On Mon, Nov 28, 2011 at 11:09 AM, Yahya Muhammad wrote:
>>>

 Thanks Noorain. But the issue is the combo box is not dynamically
 updated. For eg: if I insert one more sheet in the sample sheet, say
 Sheet9, it will not appear in the combo box unless I close and reopen the
 file. Any solutions?



 On Mon, Nov 28, 2011 at 8:18 AM, NOORAIN ANSARI <
 noorain.ans...@gmail.com> wrote:

> Dear Yahya,
>
>
> Please try below code and see attached sheet..
>
> Private Sub ComboBox1_Change()
> Sheets(ComboBox1.Value).Activate
> End Sub
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> Dim sh As Worksheet
> For Each sh In Worksheets
> Sheet1.ComboBox1.AddItem (sh.Name)
> Next
> End Sub
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  
> *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Mon, Nov 28, 2011 at 1:26 AM, Yahya Muhammad wrote:
>
>> Hi experts
>>
>> I have a work book which has a lot of worksheets. I have a master
>> sheet in the same workbook in which there is a combo box. I need this 
>> combo
>> box to have the names of all worksheets in the workbook. Any sheets
>> added/deleted in the workbook  should also be auto updated in the
>> combo box. When I select any worksheet name from the combo box, it should
>> take me to that particular worksheet. Can someone help me with a solution
>> please?
>>
>>
>>
>>
>> Thanks and regards
>>
>> Yahya
>>
>> --
>> 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 (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 lin

Re: $$Excel-Macros$$ Help me with a macro

[son nguyen]

Hi Sam
 I tried on office 2010 ,result is ok.Could you send me a modified version
2003 and explain for me a bit of this code as i am a beginer of VB.

Thanks a lot
Son

2011/11/28 Sam Mathai Chacko 

> Son, the macro is written for 2007-10. Will send a modified version,
> but before that, can you confirm the result is correct in 2007-10? If
> not, what is the issue?
>
> Sam
>
> On 28/11/2011, son nguyen  wrote:
> > Hi Mr Sam.
> > I wonder this code used for which office as 2003,2007,2010.Because my
> > office is 2003 and result  is not to like my desirement.
> >
> > Hope that you can feed back more to me
> >
> > Regards
> > son
> >
> > 2011/11/27 Sam Mathai Chacko 
> >
> >> Here's a macro to get this done
> >>
> >> Sub Consolidator()
> >>
> >> Dim rngStart As Range
> >>
> >> Application.ScreenUpdating = 0
> >> Range("F1").CurrentRegion.Clear
> >> With Cells.Find(What:="Machine", Lookat:=xlWhole,
> >> searchDirection:=xlNext, After:=Cells(1))
> >> Set rngStart = Range(.Offset(1), .Offset(, 1).End(xlDown).Offset(,
> >> -1))
> >> End With
> >> On Error Resume Next
> >> rngStart.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=r[-1]c"
> >> Err.Clear: On Error GoTo -1: On Error GoTo 0
> >> With Range("F1")
> >> .Resize(rngStart.Rows.Count + 1, 2).Value =
> >> rngStart(0).Resize(rngStart.Rows.Count + 1, 2).Value
> >> .CurrentRegion.RemoveDuplicates Columns:=Array(1, 2),
> >> Header:=xlYes
> >> .Offset(, 2).Resize(1, 2).Value = rngStart(0).Offset(,
> >> 2).Resize(1, 2).Value
> >> With .Offset(1, 2).Resize(.CurrentRegion.Rows.Count - 1, 2)
> >> .Formula = "=SUMPRODUCT(--(" & rngStart.Address &
> "=$F2),--("
> >> & rngStart.Offset(, 1).Address & "=$G2)," & rngStart.Offset(,
> >> 2).Address(1,
> >> 0) & ")"
> >> .Value = .Value
> >> End With
> >> End With
> >> On Error Resume Next
> >> rngStart.SpecialCells(xlCellTypeFormulas).ClearContents
> >> Err.Clear: On Error GoTo -1: On Error GoTo 0
> >> Application.ScreenUpdating = 1
> >>
> >> End Sub
> >>
> >> Regards,
> >>
> >> Sam Mathai Chacko
> >>
> >>
> >> On Sun, Nov 27, 2011 at 6:40 PM, rajan verma
> >> wrote:
> >>
> >>>  Hi
> >>> Please see the attached file.. Pivot table can be used for this ..
> >>>
> >>> Regards
> >>> Rajan
> >>>
> >>>  On Sat, Nov 26, 2011 at 8:23 PM, son nguyen
> >>> wrote:
> >>>
>  Dear all,
> 
> 
>  I have problem of calculating sheet.Detail as sheet attached.
>  I want to have a macro to sum value within qty, and downtime column
> then
>  delete products are duplicated within each machine.
> 
>  I look foward to hear your help asap
> 
> 
>  Best Regards
>  Son
> 
>  --
>  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
> 
> >>>
> >>>
> >>>
> >>> --
> >>> Regards
> >>> Rajan verma
> >>> +91 9158998701
> >>>
> >>> --
> >>> 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
> >>>
> >>
> >>
> >>
> >> --
> >> Sam Mathai Chacko
> >>
> >> --
> >> FORUM RULES (934+ members already BANNED for violation)
> >>
> >> 1) Use concise, accurate 

Re: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

[Kenil Gala]

Rename the file.
2003 format :  .xls
2007 format :   .xlsx

--- On Mon, 11/28/11, Sanjib Chatterjee  wrote:


From: Sanjib Chatterjee 
Subject: $$Excel-Macros$$ how to open a 2007 excel file in previous version of 
excel
To: "excel-macros" 
Date: Monday, November 28, 2011, 11:23 AM


Dear Members,

Would you please help regarding How to open a excel file saved on 2007 format 
in 2003 format


Thanking you in Advance

Sanjib


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

Re: $$Excel-Macros$$ Code in the userform for date validation not working properly

[NOORAIN ANSARI]

Dear Santosh,

Please see attached sheet i hope it will help to you.

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Mon, Nov 28, 2011 at 3:00 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:

> Hi All,
>
> In the user form I have coded a date validation which should take data for
> current date or the previous date only with the help of *calendar only*.
>
> However, the code is not working properly.
>
> Moreover in the textbox3 I want it to restrict it only for numbers and no
> character should be allowed to be entered for which I need help.
>
> --
> Regards
> Santosh
> santoshkumar.subu...@gmail.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 (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


Testing-1(Solved).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

[Bé Trần Văn]

2011/11/28 Kenil Gala 

>   Rename the file.
> 2003 format :  .xls
> 2007 format :   .xlsx
>
> --- On *Mon, 11/28/11, Sanjib Chatterjee *wrote:
>
>
> From: Sanjib Chatterjee 
> Subject: $$Excel-Macros$$ how to open a 2007 excel file in previous
> version of excel
> To: "excel-macros" 
> Date: Monday, November 28, 2011, 11:23 AM
>
>
> Dear Members,
>
> Would you please help regarding How to open a excel file saved on 2007
> format in 2003 format
>
>
> Thanking you in Advance
>
> Sanjib
>
> --
> 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
>

You unzip it and run it FileFormatConverters open File 2007

You download the File under the followingLink:

http://www.mediafire.com/?xatxj4f59m4754y

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

Re: $$Excel-Macros$$ Almost all calculator in one sheet

[vijayajith VA]

Thanks ankit.

On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal
wrote:

> Hello All,
>
> In our daily life we calculate so many thing & use different calculator.
> Here is one excel file which contain almost all calculator.
>
>
> Calculate & enjoy !!!
>
>
> Regards,
>
> Ankit
>
> --
> 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

Re: $$Excel-Macros$$ Almost all calculator in one sheet

[sujitd9]

Dear Ankitji,

Can u please re-send the worksheet ?

Regards,
Sujit
Sent on my BlackBerry® from Vodafone

-Original Message-
From: Amit Gandhi 
Sender: excel-macros@googlegroups.com
Date: Mon, 28 Nov 2011 17:38:31 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Almost all calculator in one sheet

very useful sheet. thanks for sharing.

On Mon, Nov 28, 2011 at 12:20 PM, NOORAIN ANSARI
wrote:

> Thanks Ankit,
>
> Very useful sheet you have shared with Group.
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal <
> ankit.agrawal...@gmail.com> wrote:
>
>> Hello All,
>>
>> In our daily life we calculate so many thing & use different calculator.
>> Here is one excel file which contain almost all calculator.
>>
>>
>> Calculate & enjoy !!!
>>
>>
>> Regards,
>>
>> Ankit
>>
>> --
>> 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
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

Re: $$Excel-Macros$$ Almost all calculator in one sheet

[Bé Trần Văn]

2011/11/28 vijayajith VA 

> Thanks ankit.
>
>  On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal <
> ankit.agrawal...@gmail.com> wrote:
>
>> Hello All,
>>
>> In our daily life we calculate so many thing & use different calculator.
>> Here is one excel file which contain almost all calculator.
>>
>>
>> Calculate & enjoy !!!
>>
>>
>> Regards,
>>
>> Ankit
>>
>> --
>> 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
>

Thanks for sharing, sheet very useful .

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

Re: $$Excel-Macros$$ Help me with a macro

[Sam Mathai Chacko]

Great, so no modifications required for Excel 2010

The code below works for both 2003 and 2010

Sub Consolidator()

Dim rngStart As Range
Dim varArray As Range

Application.ScreenUpdating = 0
Range("F1").CurrentRegion.Clear
With Cells.Find(What:="Machine", Lookat:=xlWhole,
searchDirection:=xlNext, After:=Cells(1))
Set rngStart = Range(.Offset(1), .Offset(, 1).End(xlDown).Offset(, -1))
End With
On Error Resume Next
rngStart.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=r[-1]c"
Err.Clear: On Error GoTo -1: On Error GoTo 0
With Range("F1")
.Resize(rngStart.Rows.Count + 1, 2).Value =
rngStart(0).Resize(rngStart.Rows.Count + 1, 2).Value
If Val(Application.Version) <= 11 Then
.CurrentRegion.AdvancedFilter Action:=xlFilterInPlace,
Unique:=True
.CurrentRegion.SpecialCells(xlCellTypeVisible).Copy
rngStart.Offset(rngStart.Rows.Count + 1)(1)
.AutoFilter: .Parent.AutoFilterMode = 0
.CurrentRegion.Clear
With rngStart.Offset(rngStart.Rows.Count + 1)(1).CurrentRegion
.Copy Range("F1"): .ClearContents
End With
Else
.CurrentRegion.RemoveDuplicates Columns:=Array(1, 2),
Header:=xlYes
End If
.Offset(, 2).Resize(1, 2).Value = rngStart(0).Offset(, 2).Resize(1,
2).Value
With .Offset(1, 2).Resize(.CurrentRegion.Rows.Count - 1, 2)
.Formula = "=SUMPRODUCT(--(" & rngStart.Address & "=$F2),--(" &
rngStart.Offset(, 1).Address & "=$G2)," & rngStart.Offset(, 2).Address(1,
0) & ")"
.Value = .Value
End With
End With
On Error Resume Next
rngStart.SpecialCells(xlCellTypeFormulas).ClearContents
Err.Clear: On Error GoTo -1: On Error GoTo 0
Application.ScreenUpdating = 1

End Sub

Regards,
Sam Mathai Chacko

On Mon, Nov 28, 2011 at 6:33 PM, Bé Trần Văn wrote:

>
>
> 2011/11/28 Sam Mathai Chacko 
>
>> Son, the macro is written for 2007-10. Will send a modified version,
>> but before that, can you confirm the result is correct in 2007-10? If
>> not, what is the issue?
>>
>> Sam
>>
>> On 28/11/2011, son nguyen  wrote:
>> > Hi Mr Sam.
>> > I wonder this code used for which office as 2003,2007,2010.Because my
>> > office is 2003 and result  is not to like my desirement.
>> >
>> > Hope that you can feed back more to me
>> >
>> > Regards
>> > son
>> >
>> > 2011/11/27 Sam Mathai Chacko 
>> >
>> >> Here's a macro to get this done
>> >>
>> >> Sub Consolidator()
>> >>
>> >> Dim rngStart As Range
>> >>
>> >> Application.ScreenUpdating = 0
>> >> Range("F1").CurrentRegion.Clear
>> >> With Cells.Find(What:="Machine", Lookat:=xlWhole,
>> >> searchDirection:=xlNext, After:=Cells(1))
>> >> Set rngStart = Range(.Offset(1), .Offset(, 1).End(xlDown).Offset(,
>> >> -1))
>> >> End With
>> >> On Error Resume Next
>> >> rngStart.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=r[-1]c"
>> >> Err.Clear: On Error GoTo -1: On Error GoTo 0
>> >> With Range("F1")
>> >> .Resize(rngStart.Rows.Count + 1, 2).Value =
>> >> rngStart(0).Resize(rngStart.Rows.Count + 1, 2).Value
>> >> .CurrentRegion.RemoveDuplicates Columns:=Array(1, 2),
>> >> Header:=xlYes
>> >> .Offset(, 2).Resize(1, 2).Value = rngStart(0).Offset(,
>> >> 2).Resize(1, 2).Value
>> >> With .Offset(1, 2).Resize(.CurrentRegion.Rows.Count - 1, 2)
>> >> .Formula = "=SUMPRODUCT(--(" & rngStart.Address &
>> "=$F2),--("
>> >> & rngStart.Offset(, 1).Address & "=$G2)," & rngStart.Offset(,
>> >> 2).Address(1,
>> >> 0) & ")"
>> >> .Value = .Value
>> >> End With
>> >> End With
>> >> On Error Resume Next
>> >> rngStart.SpecialCells(xlCellTypeFormulas).ClearContents
>> >> Err.Clear: On Error GoTo -1: On Error GoTo 0
>> >> Application.ScreenUpdating = 1
>> >>
>> >> End Sub
>> >>
>> >> Regards,
>> >>
>> >> Sam Mathai Chacko
>> >>
>> >>
>> >> On Sun, Nov 27, 2011 at 6:40 PM, rajan verma
>> >> wrote:
>> >>
>> >>>  Hi
>> >>> Please see the attached file.. Pivot table can be used for this ..
>> >>>
>> >>> Regards
>> >>> Rajan
>> >>>
>> >>>  On Sat, Nov 26, 2011 at 8:23 PM, son nguyen
>> >>> wrote:
>> >>>
>>  Dear all,
>> 
>> 
>>  I have problem of calculating sheet.Detail as sheet attached.
>>  I want to have a macro to sum value within qty, and downtime column
>> then
>>  delete products are duplicated within each machine.
>> 
>>  I look foward to hear your help asap
>> 
>> 
>>  Best Regards
>>  Son
>> 
>>  --
>>  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 reg

Re: $$Excel-Macros$$ Help me with a macro

[dguillett1]

Even when presented with a problem for xl2007+, I usually write in 2003 .xls 
and tell user to convert to .xlsm if desired. Prevents these problems. However, 
sometimes there ARE things later versions can do or do better.

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

From: Sam Mathai Chacko 
Sent: Monday, November 28, 2011 8:32 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Help me with a macro

Great, so no modifications required for Excel 2010

The code below works for both 2003 and 2010

Sub Consolidator()

Dim rngStart As Range
Dim varArray As Range

Application.ScreenUpdating = 0
Range("F1").CurrentRegion.Clear
With Cells.Find(What:="Machine", Lookat:=xlWhole, searchDirection:=xlNext, 
After:=Cells(1))
Set rngStart = Range(.Offset(1), .Offset(, 1).End(xlDown).Offset(, -1))
End With
On Error Resume Next
rngStart.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=r[-1]c"
Err.Clear: On Error GoTo -1: On Error GoTo 0
With Range("F1")
.Resize(rngStart.Rows.Count + 1, 2).Value = 
rngStart(0).Resize(rngStart.Rows.Count + 1, 2).Value
If Val(Application.Version) <= 11 Then
.CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, Unique:=True
.CurrentRegion.SpecialCells(xlCellTypeVisible).Copy 
rngStart.Offset(rngStart.Rows.Count + 1)(1)
.AutoFilter: .Parent.AutoFilterMode = 0
.CurrentRegion.Clear
With rngStart.Offset(rngStart.Rows.Count + 1)(1).CurrentRegion
.Copy Range("F1"): .ClearContents
End With
Else
.CurrentRegion.RemoveDuplicates Columns:=Array(1, 2), Header:=xlYes
End If
.Offset(, 2).Resize(1, 2).Value = rngStart(0).Offset(, 2).Resize(1, 
2).Value
With .Offset(1, 2).Resize(.CurrentRegion.Rows.Count - 1, 2)
.Formula = "=SUMPRODUCT(--(" & rngStart.Address & "=$F2),--(" & 
rngStart.Offset(, 1).Address & "=$G2)," & rngStart.Offset(, 2).Address(1, 0) & 
")"
.Value = .Value
End With
End With
On Error Resume Next
rngStart.SpecialCells(xlCellTypeFormulas).ClearContents
Err.Clear: On Error GoTo -1: On Error GoTo 0
Application.ScreenUpdating = 1

End Sub

Regards,
Sam Mathai Chacko


On Mon, Nov 28, 2011 at 6:33 PM, Bé Trần Văn  wrote:




  2011/11/28 Sam Mathai Chacko 

Son, the macro is written for 2007-10. Will send a modified version,
but before that, can you confirm the result is correct in 2007-10? If
not, what is the issue?

Sam


On 28/11/2011, son nguyen  wrote:
> Hi Mr Sam.
> I wonder this code used for which office as 2003,2007,2010.Because my
> office is 2003 and result  is not to like my desirement.
>
> Hope that you can feed back more to me
>
> Regards
> son
>
> 2011/11/27 Sam Mathai Chacko 
>
>> Here's a macro to get this done
>>
>> Sub Consolidator()
>>
>> Dim rngStart As Range
>>
>> Application.ScreenUpdating = 0
>> Range("F1").CurrentRegion.Clear
>> With Cells.Find(What:="Machine", Lookat:=xlWhole,
>> searchDirection:=xlNext, After:=Cells(1))
>> Set rngStart = Range(.Offset(1), .Offset(, 1).End(xlDown).Offset(,
>> -1))
>> End With
>> On Error Resume Next
>> rngStart.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=r[-1]c"
>> Err.Clear: On Error GoTo -1: On Error GoTo 0
>> With Range("F1")
>> .Resize(rngStart.Rows.Count + 1, 2).Value =
>> rngStart(0).Resize(rngStart.Rows.Count + 1, 2).Value
>> .CurrentRegion.RemoveDuplicates Columns:=Array(1, 2),
>> Header:=xlYes
>> .Offset(, 2).Resize(1, 2).Value = rngStart(0).Offset(,
>> 2).Resize(1, 2).Value
>> With .Offset(1, 2).Resize(.CurrentRegion.Rows.Count - 1, 2)
>> .Formula = "=SUMPRODUCT(--(" & rngStart.Address & "=$F2),--("
>> & rngStart.Offset(, 1).Address & "=$G2)," & rngStart.Offset(,
>> 2).Address(1,
>> 0) & ")"
>> .Value = .Value
>> End With
>> End With
>> On Error Resume Next
>> rngStart.SpecialCells(xlCellTypeFormulas).ClearContents
>> Err.Clear: On Error GoTo -1: On Error GoTo 0
>> Application.ScreenUpdating = 1
>>
>> End Sub
>>
>> Regards,
>>
>> Sam Mathai Chacko
>>
>>
>> On Sun, Nov 27, 2011 at 6:40 PM, rajan verma
>> wrote:
>>
>>>  Hi
>>> Please see the attached file.. Pivot table can be used for this ..
>>>
>>> Regards
>>> Rajan
>>>
>>>  On Sat, Nov 26, 2011 at 8:23 PM, son nguyen
>>> wrote:
>>>
 Dear all,


 I have problem of calculating sheet.Detail as sheet attached.
 I want to have a macro to sum value within qty, and downtime column 
then
 delete products are duplicated within each machine.

 I look f

Re: $$Excel-Macros$$ Code in the userform for date validation not working properly

[Sam Mathai Chacko]

A TEXT can never be lesser than a number. At least in the Excel world.

Santhosh, please replace the entire code in form1 with this

Private Sub CommandButton1_Click()

If CDate(TextBox1.Value) > Date Then
msg = MsgBox("You cannot make a transaction for a future date",
vbCritical, "Your Personal Banking")
Exit Sub
End If
With Cells(Rows.Count, 1).End(xlUp)(2)
.NumberFormat = "[$-409]d-mmm-yy;@"
.Resize(1, 3).Value = Array(TextBox1.Value, TextBox2.Value,
TextBox3.Value)
End With

End Sub

Private Sub CommandButton2_Click()

Unload UserForm1

End Sub

Private Sub CommandButton3_Click()

Userform2.Show

End Sub

Private Sub TextBox3_Change()

Application.EnableEvents = 0
If Len(TextBox3.Text) = 1 Then
If InStr(1, "0123456789", TextBox3.Text) = 0 Then
TextBox3.Text = ""
End If
End If

If Len(CStr(Val(TextBox3.Text))) <> Len(TextBox3.Text) Then
TextBox3.Text = ""
End If
Application.EnableEvents = 1

End Sub

Regards,
Sam Mathai Chacko
On Mon, Nov 28, 2011 at 6:47 PM, NOORAIN ANSARI wrote:

> Dear Santosh,
>
> Please see attached sheet i hope it will help to you.
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Mon, Nov 28, 2011 at 3:00 PM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
>> Hi All,
>>
>> In the user form I have coded a date validation which should take data
>> for current date or the previous date only with the help of *calendar
>> only*.
>>
>> However, the code is not working properly.
>>
>> Moreover in the textbox3 I want it to restrict it only for numbers and no
>> character should be allowed to be entered for which I need help.
>>
>> --
>> Regards
>> Santosh
>> santoshkumar.subu...@gmail.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 (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
>



-- 
Sam Mathai Chacko

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

Re: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

[Sam Mathai Chacko]

For the sake of readers, and for posterity, you CANNOT just change the file
extension (xlsx to xls) and make it compatible with Excel 2003.

Regards,
Sam

On Mon, Nov 28, 2011 at 6:58 PM, Bé Trần Văn wrote:

>
>
> 2011/11/28 Kenil Gala 
>
>>   Rename the file.
>> 2003 format :  .xls
>> 2007 format :   .xlsx
>>
>> --- On *Mon, 11/28/11, Sanjib Chatterjee 
>> *wrote:
>>
>>
>> From: Sanjib Chatterjee 
>> Subject: $$Excel-Macros$$ how to open a 2007 excel file in previous
>> version of excel
>> To: "excel-macros" 
>> Date: Monday, November 28, 2011, 11:23 AM
>>
>>
>> Dear Members,
>>
>> Would you please help regarding How to open a excel file saved on 2007
>> format in 2003 format
>>
>>
>> Thanking you in Advance
>>
>> Sanjib
>>
>> --
>> 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
>>
>
> You unzip it and run it FileFormatConverters open File 2007
>
> You
>  download the File under the followingLink:
>
> http://www.mediafire.com/?xatxj4f59m4754y
>
> --
> 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
>



-- 
Sam Mathai Chacko

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

$$Excel-Macros$$ Re: Grant chart.......

[larry]

Do you mean gannt chart?

On Nov 28, 1:50 am, Brajesh Kumar Porwal
 wrote:
> Hi Expert,
>
> I have some activity. i want to create grant chart on this activity.
> How's make it. for help see enclose file.
> give me best solution.
>
> Regards,
> Brajesh
>
>  Activity.xlsx
> 15KViewDownload

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

Re: $$Excel-Macros$$ Other possibility

[Aamir Shahzad]

thanks all of you.

Regards,

Aamir Shahzad


On Mon, Nov 28, 2011 at 10:22 AM, NOORAIN ANSARI
wrote:

> Dear Aamir,
>
> You can also try.
> *=LOOKUP(C4,$F$9:$G$14)*
>
>
> 0 upto 50 M
>  51,000,000  51- to 100M
> 101,000,000  101 to 300M
> 301,000,000  301 to 500M
> 501,000,000  501M to 1 Bn
>  1,000,000,001  1 Bn +
>
>
>
> On Mon, Nov 28, 2011 at 12:35 AM, Aamir Shahzad 
> wrote:
>
>> Dear  Experts,
>>
>> I have already write formula to get the bucket result in attached sheet,
>> is there another possible formulas?
>>
>>
>> Regards,
>>
>> Aamir Shahzad
>>
>> --
>> 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
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.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
>



-- 

Regards,

Aamir Shahzad

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

Re: $$Excel-Macros$$ re: conversion of numbers

[Aamir Shahzad]

how to recall this add-inn in working sheet.

Regards,

Aamir Shahzad

On Mon, Nov 28, 2011 at 11:41 AM, Ankit Agrawal
wrote:

> Hi Harsh,
>
> Use attached add-inn.
>
> Regards,
> Ankit
>
>
> On Mon, Nov 28, 2011 at 1:22 AM, Vinod Narayanan wrote:
>
>> Hi Harsh,
>>
>>
>> Select the cells which requires the formatting to be done and in Format
>> Cells --> Custom, Please type *#,*  to convert numbers in thousands and
>> so on
>>
>> Option 1 = If base data is 10 - type *#,* in Format Cells -->
>> Custom.. The result will be 100
>> Option 2 = If base data is 10 - type *#,,* in Format Cells -->
>> Custom.. The result will be 1000
>> Option 3 = If base data is 10 - type *#,#,* in Format Cells -->
>> Custom.. The result will be 1,000,000
>> Option 4 = If base data is 10 - type *#,#,,* in Format Cells -->
>> Custom.. The result will be 1,000
>> Option 5 = If base data is 10 - type *#,#,,,* in Format Cells
>> --> Custom.. The result will be 1
>>
>> Please have an eye on the number of commas(,) added after hash(#)
>>
>> Thanks for the query
>> Vinod
>>
>>
>> On Sun, Nov 27, 2011 at 10:00 AM, harsh shah 
>> wrote:
>>  > dear all,
>> >
>> > i have a data sheet with numbers in it.
>> >
>> > i want to convert them into thousands or in lacs.
>> >
>> > is there a way to format the selected data cells so as to convert the
>> same
>> > in thousands or in lacs ?
>> >
>> > harsh.
>> >
>> > --
>> > 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 (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
>



-- 

Regards,

Aamir Shahzad

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

Re: $$Excel-Macros$$ Criteria based copy DATA FROM THIS Summary AND PASTE IT ON SHEET 2 TRANSPOSED

[dguillett1]

How about AFTER example using your data.

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

From: shashank bhosle 
Sent: Monday, November 28, 2011 1:14 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Criterria based copy DATA FROM THIS Summary AND PASTE 
IT ON SHEET 2 TRANSPOSED

  Hello ALL,


  I WANT TO PULL THE DATA FROM THIS Summary AND PASTE IT ON SHEET 2 
TRANSPOSE BASED ON FOLLOWING CRITERIA.   1. SAle office,Customer,Loc,Material 
Code….i want to find the data NBLM,anand ,keral and manza ..copy the data from 
oct to sep and paste it in sheet2 in columm K vertically..eg are given in blue 
and yellow colour 









Regards
Shashank


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

$$Excel-Macros$$ Expert Advice Needed - Formula to count Worksheets

[Secret Shot]

Dear Experts,

It there any Formula to count worksheets in a Excel File. I know VBA code
for this but i want any Formula or any combination of formula's only to
solve this. kindly Help. This is very critical for me.

Thanks in Advance..

-- 
Pankaj Pandey
Bhopal

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

Re: $$Excel-Macros$$ Expert Advice Needed - Formula to count Worksheets

[dguillett1]

One way would be to select all sheets and put 1 in cella1 (or any cell 
desired). Assuming sheet1 names shf and last sheet named  shl
=sum(shfhl!A1)There are other ways

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

From: Secret Shot 
Sent: Monday, November 28, 2011 3:36 PM
To: excel-macros@googlegroups.com 
Cc: pankaj.pandey 
Subject: $$Excel-Macros$$ Expert Advice Needed - Formula to count Worksheets

Dear Experts, 

It there any Formula to count worksheets in a Excel File. I know VBA code for 
this but i want any Formula or any combination of formula's only to solve this. 
kindly Help. This is very critical for me.

Thanks in Advance..  


-- 
Pankaj Pandey
Bhopal

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

$$Excel-Macros$$ Job

[ashish koul]

Contact Details Recruiter :-

*New*star **Consulting** *| Email: ash...@newstarconsulting.com   | T:
+91-11-43142000 (100 Lines)|

| No.6, Corner Market, Malviya Nagar | **New Delhi** - 110017| *
***India |



Requirement:

*1. VBA Macros + Advanced Excel + MS Access + (Experience to create
automation to support financial team of the company)*

** **

*Thanks and Regards"*

Ashish Mishra

*Lead IT *Recruiter@*New*star* * **Consulting** *

-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

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

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

[maulik desai]

Thanks you so much deepak for your great support lastly i just want to ask
you 1 thing that when ever i clicked on

Macro for mail send microsoft gives me pop up for stating that whould you
like to send this mail (with allow or dinied option ) so every time i have
to click allow buttion is there any why to remove this pop uo windlow rest
everytrhing working fine

pls revert with solution & thanks once again..
On Wed, Nov 23, 2011 at 10:14 AM, Deepak Pal Singh <
deepaktheind...@gmail.com> wrote:

> Attached is the updated file, now you won't need to prepare a separate
> table to get channel wise unique email id's...
>
>
>
>
> On Mon, Nov 21, 2011 at 10:09 PM, maulik desai wrote:
>
>> Thanks Deepak, Actually those id;'s i cant disclose it but yes Email ids
>> are not common & it is also not based on channel name.its is based on
>> location wise & its always get change so i suggest you to kindly add the
>> new column after G or After M
>>
>> Actaully My Database is from A to G & if u add the new col then From A To
>> H , actually there is no summry sheet (From K to M ,if u want u can remove
>> the column L(person name ) from summary sheet & can add in main database
>> after col F so while macro prepares summry sheet it will be easy for me to
>> get data) i have just shown to u for ref
>>
>> actaully i want it like once i update the database in column A to H ,
>> Macro can create the summry sheet based on unique list & then send the mail
>> to mail ids (from To & in CC fields)
>> Thanks
>>  On Mon, Nov 21, 2011 at 10:56 AM, Deepak Pal Singh <
>> deepaktheind...@gmail.com> wrote:
>>
>>> Sure Maulik... I just want to know those email ids (which you want to
>>> add in CC & BCC) are common or they'll be changed with every channel
>>> name...??
>>>
>>> Regards
>>> Deepak
>>>
>>>
>>> On Sun, Nov 20, 2011 at 2:43 PM, maulik desai wrote:
>>>
 Thanks you so much deepak for your effort & sorry for late reply
 becasue i can not able to use Gmail from my office pc & i check your file
 it is working very well just one thing i want to ask u that i want to add
 some email id on CC & BCC can u please help in this that how can i do
 that.& while data pasted to mail body , bottom line of table is not
 reflected .

 Request you to please look in small chnages & revert

 Thnaks in Advance..

  On Wed, Nov 16, 2011 at 11:01 AM, Deepak Pal Singh <
 deepaktheind...@gmail.com> wrote:

> Here it is I developed this code on 2007 platform..I hope it'll
> work in 2003 as well...
>
> Sorry.. I couldn't attached the excel file with my previous post
> because I's in office at that time & can't access to gmail over
> there...
>
> Regards
> Deepak
>
>
> On Tue, Nov 15, 2011 at 11:32 PM, maulik desai  > wrote:
>
>> Hi deepu,
>>
>> Thanks you so much for your reply
>>
>> I have tried to paste the code in module but it not work properly
>> request you to kindly provide me the excel sheet with your macro code but
>> before you send me the file required small changes do not use K & M 
>> column
>> for Chennel name & email address that is given just for information my
>> actual database is from A to G request you to kindly change the macro 
>> code
>> accordingly & send it back for the other checks also if you want u can
>> create the summary sheet with the help of macro & paste it on sheet 2 &
>> also for name u can use Column H for the proper output.1 more thing i 
>> want
>> to tell you that a have to send mail with our official signature so if u
>> can apply macro logic for the same also it would be very great ful to u.
>>
>> Request you to kindly make the changes & resend it for the final check
>>
>> Thanks in Advance & thanks for your time & support.
>>
>> On Mon, Nov 14, 2011 at 4:10 PM, deepu wrote:
>>
>>> Hi Maulik,
>>>
>>> Below is the code that you're looking for...
>>> Insert a module in your workbook and paste the following code and run
>>> it...
>>>
>>>
>>> ---
>>> Dim MyArray() As Variant, ListArray() As Variant
>>> Dim R As Long, C As Integer, LastRow As Long, i As Long
>>> Dim OutObj As Object, EmailObj As Object, EmailBody As String, RecAdd
>>> As String
>>> Sub PrepareData()
>>> 'Assigning values to MyArray
>>> LastRow = Sheet1.Range("A6").End(xlUp).Row
>>> MyArray = Sheet1.Range("A7:G" & LastRow).Value
>>>
>>> 'Assigning values to ListArray
>>> LastRow = Sheet1.Range("K6").End(xlUp).Row
>>> ListArray = Sheet1.Range("K7:M" & LastRow).Value
>>>
>>> For i = LBound(ListArray) To UBound(ListArray)
>>>RecAdd = ListArray(i, 3)
>>>EmailBody = "Hi " &
>>> App

Re: $$Excel-Macros$$ Expert Advice Needed - Formula to count Worksheets

[NOORAIN ANSARI]

Dear Pankaj,

Please find attached sheet i hope it will help to you.
Press F2 in Formula for Refresh..

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Tue, Nov 29, 2011 at 3:06 AM, Secret Shot  wrote:

> Dear Experts,
>
> It there any Formula to count worksheets in a Excel File. I know VBA code
> for this but i want any Formula or any combination of formula's only to
> solve this. kindly Help. This is very critical for me.
>
> Thanks in Advance..
>
> --
> Pankaj Pandey
> Bhopal
>
> --
> 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


Count_Sheets_through_formula.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Grant chart.......

[Brajesh Kumar Porwal]

Hi,

Gantt charts can be used to show current schedule status using
percent-complete shadings and a vertical today line as shown here.
Regads,
Brajesh


On Mon, Nov 28, 2011 at 8:57 PM, larry  wrote:

> Do you mean gannt chart?
>
> On Nov 28, 1:50 am, Brajesh Kumar Porwal
>  wrote:
> > Hi Expert,
> >
> > I have some activity. i want to create grant chart on this activity.
> > How's make it. for help see enclose file.
> > give me best solution.
> >
> > Regards,
> > Brajesh
> >
> >  Activity.xlsx
> > 15KViewDownload
>
> --
> 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

$$Excel-Macros$$ Job

[ashish koul]

*Recruiter Id* i...@tekshapers.com

Greetings!!

Interview Tomorrow( candidate who can attend interview tomorrow need to
apply)

We are looking for the position of "Data Analyst" for one of our
prestigious client.

Location- Gurgaon

Exp- 2 -4yrs

Skills-Need people with Advanced excel exp(V Lookup, h lookup, pivot table,
charts)
Should have good knowledge of macros

candidate with good communication need to apply.

If interested for above mentioned profile kindly revert back with your
updated resume.

Thanks & Regards:
Warm Regards,
Indu Rawat
0120-4137000 xtn- 203 I
Contact no-932895
TekShapers India
www.tekshapers.com
i...@tekshapers.com
-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

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

Re: $$Excel-Macros$$ re: conversion of numbers

[Ankit Agrawal]

Hi Aamir,


   1. Click the *Microsoft Office Button* [image: Button image], click *Excel
   Options*, and then click *Add-Ins*.
   2. View the add-ins and application extensions that are categorized as
   follows:
  - *Active Application Add-ins* Lists the extensions that are
  registered and currently running in your Office program.
  - *Inactive Application Add-ins* Lists the add-ins that are
  present on your computer but are not currently loaded. For example, smart
  tags or XML Schemas are active only when the document that
references them
  is open. Another example is the COM add-ins that are listed in the *COM
  Add-ins* dialog box. If the check box for a COM add-in is selected,
  the add-in is active. If the check box for a COM add-in is cleared, the
  add-in is inactive. To learn how to open the *COM Add-in* dialog box,
  see the section called Turn off or manage the installed
add-ins
  .
  - *Document Related Add-ins* Lists template files that are
  referenced by currently open documents.
  - *Disabled Application Add-ins* Lists add-ins that were
  automatically disabled because they are causing Office programs to crash.

how to use SureshAddin.xla

syntax:-

=rswords(cell no.)

Example:
suppose we have a num value in cell 'B2'
we will write

=rswords(b2)

Regards,
Ankit


On Tue, Nov 29, 2011 at 12:56 AM, Aamir Shahzad wrote:

> how to recall this add-inn in working sheet.
>
> Regards,
>
> Aamir Shahzad
>
> On Mon, Nov 28, 2011 at 11:41 AM, Ankit Agrawal <
> ankit.agrawal...@gmail.com> wrote:
>
>> Hi Harsh,
>>
>> Use attached add-inn.
>>
>> Regards,
>> Ankit
>>
>>
>> On Mon, Nov 28, 2011 at 1:22 AM, Vinod Narayanan wrote:
>>
>>> Hi Harsh,
>>>
>>>
>>> Select the cells which requires the formatting to be done and in Format
>>> Cells --> Custom, Please type *#,*  to convert numbers in thousands and
>>> so on
>>>
>>> Option 1 = If base data is 10 - type *#,* in Format Cells -->
>>> Custom.. The result will be 100
>>> Option 2 = If base data is 10 - type *#,,* in Format Cells -->
>>> Custom.. The result will be 1000
>>> Option 3 = If base data is 10 - type *#,#,* in Format Cells -->
>>> Custom.. The result will be 1,000,000
>>> Option 4 = If base data is 10 - type *#,#,,* in Format Cells
>>> --> Custom.. The result will be 1,000
>>> Option 5 = If base data is 10 - type *#,#,,,* in Format Cells
>>> --> Custom.. The result will be 1
>>>
>>> Please have an eye on the number of commas(,) added after hash(#)
>>>
>>> Thanks for the query
>>> Vinod
>>>
>>>
>>> On Sun, Nov 27, 2011 at 10:00 AM, harsh shah 
>>> wrote:
>>>  > dear all,
>>> >
>>> > i have a data sheet with numbers in it.
>>> >
>>> > i want to convert them into thousands or in lacs.
>>> >
>>> > is there a way to format the selected data cells so as to convert the
>>> same
>>> > in thousands or in lacs ?
>>> >
>>> > harsh.
>>> >
>>> > --
>>> > 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

Re: $$Excel-Macros$$ Expert Advice Needed - Formula to count Worksheets

[STDEV(i)]

Create a Name in your workbook (ribbon > Tab Formula > Name Manager

Name (for Excample) : SheetsCount
Refer to:   =GET.WORKBOOK(4)

[image: Create a NAME.PNG]

in the sheet you can use
*=SheetsCount*
resultling number of sheet in the workbook

they called it : Macro Excel4
http://support.microsoft.com/kb/109976




On Tue, Nov 29, 2011 at 4:36 AM, Secret Shot  wrote:

> Dear Experts,
> It there any Formula to count worksheets in a Excel File. I know VBA code
> for this but i want any Formula or any combination of formula's only to
> solve this. kindly Help. This is very critical for me.
>
> Thanks in Advance..
> Pankaj Pandey
> Bhopal
>
>

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

Re: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

[Sanjib Chatterjee]

Thank you experts,

But would the Convert run in Windows 2000?

Thanking you in Advance

Sanjib


On Mon, Nov 28, 2011 at 9:02 PM, Sam Mathai Chacko wrote:

> For the sake of readers, and for posterity, you CANNOT just change the
> file extension (xlsx to xls) and make it compatible with Excel 2003.
>
> Regards,
> Sam
>
>
> On Mon, Nov 28, 2011 at 6:58 PM, Bé Trần Văn wrote:
>
>>
>>
>> 2011/11/28 Kenil Gala 
>>
>>>   Rename the file.
>>> 2003 format :  .xls
>>> 2007 format :   .xlsx
>>>
>>> --- On *Mon, 11/28/11, Sanjib Chatterjee 
>>> *wrote:
>>>
>>>
>>> From: Sanjib Chatterjee 
>>> Subject: $$Excel-Macros$$ how to open a 2007 excel file in previous
>>> version of excel
>>> To: "excel-macros" 
>>> Date: Monday, November 28, 2011, 11:23 AM
>>>
>>>
>>> Dear Members,
>>>
>>> Would you please help regarding How to open a excel file saved on 2007
>>> format in 2003 format
>>>
>>>
>>> Thanking you in Advance
>>>
>>> Sanjib
>>>
>>> --
>>> 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
>>>
>>
>> You unzip it and run it FileFormatConverters open File 2007
>>
>> You
>>  download the File under the followingLink:
>>
>> http://www.mediafire.com/?xatxj4f59m4754y
>>
>> --
>> 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
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> 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, F

RE: $$Excel-Macros$$ stop receiving mail in this mail id

[smitha.kumari]

Sorry, I didn't find the way to unsubscribe. Please help

 

Regards

Smitha

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Monday, November 28, 2011 10:36 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ stop receiving mail in this mail id

 

Hi,

Please visit here for more details.. 
www.discussexcel.com

On Mon, Nov 28, 2011 at 10:04 AM, smitha.kumari
 wrote:

HI,

 

I am changing my mail id after two weeks. If I want to stop the receipt of
mails from excelgroops in this mail Id. What shall I do?

 

Regards

Smitha/ Senior Finance Executive

Speridian%20Logo

World Class Solutions to Power Global Businesses

Office: 0471-2527525/2700526

smitha.kum...@speridian.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




-- 

Thanks & regards,

Noorain Ansari

  http://excelmacroworld.blogspot.com/

  http://noorain-ansari.blogspot.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 (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
<>