RE: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.

[BS CTC]

FIFO calculation means calculation on the basis of First In First Out.

 

In a year we purchase goods on different rates,

For Example

 

In April I purchased 10 Pcs @ Rs. 5.00 

In May I purchased 5 Pcs @ Rs. 6.00

In June I purchased 8 Pcs @ Rs. 5.50

 

So when I will put the consumption for the months it will calculate the
consumption value on the basis of FIFO

For Example

In April Consumed 7 Pcs @ Rs. 5/- Value Rs. 35/- (Apr Purchase)

In May Consumed 8 Pcs @ 5.625/- Value Rs. 45/- (3Pcs x Rs. 5/- Apr Pur) +
(5Pcs x Rs. 6/- May Pur)

 

Hope you understand the calculation.

The closing value of stock will be calculated on the Balance Quantity (@ of
last purchase rate)

 

Thanks & Regards,

BS

 

 

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Maries
Sent: Sun, 06-May-2012 11:46 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula required for finding Consumption value
for giving cons. Qty.

 

Can you explain more about FIFO calculation.

On Fri, May 4, 2012 at 8:19 PM, B Sharma  wrote:

Dear Friends and excel experts,,

 

I have a sheet in which there are columns like "Qty""Rate" of purchase
of items,

In Another sheet I need a formula for auto calculation of consumption value
of goods for the given quantity in FIFO method (First In First Out)

 

I have tried all my known tricks, but failed..

 

Please help.

 

Thanks & Regards,

BS

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

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

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.

[Maries]

*Can you explain more about FIFO calculation.*

On Fri, May 4, 2012 at 8:19 PM, B Sharma  wrote:

> Dear Friends and excel experts,,
>
> I have a sheet in which there are columns like "Qty""Rate" of purchase
> of items,
> In Another sheet I need a formula for auto calculation of consumption
> value of goods for the given quantity in FIFO method (First In First Out)
>
> I have tried all my known tricks, but failed..
>
> Please help.
>
> Thanks & Regards,
> BS
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Problems Comparing New Line Character in Strings

[BNS kumar]

Can u send a sample file.

Regards
Kumar

On Mon, Apr 30, 2012 at 3:32 AM, Alan  wrote:

> I have two sets of Excel worksheets I am trying to compare.  The cells
> contained multiple lines of text.  Some identical-looking lines do not
> compare with string1 = string2 syntax.  It appears the comparison is
> failing when it tries to compare new line characters (ASCII code 10).
>
>Has anyone else run into this?  I tried to do some Google searches, but
> no luck in finding answers to this problem.
>
>  Thanks, Alan
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

[Bé Trần Văn]

2012/5/4 Deba Ranjan 

> *Congrats Rajan Shahab,
>
>And Thanks every member of Excel forum who have devoted their times in
> analytical for solving problem and vice versa.
> *
>
>
> Thanks & Regards,*
> *
>
> *Deba Ranjan P***
>
>
>
> On Fri, May 4, 2012 at 2:45 PM, Ankit Agrawal 
> wrote:
>
>> Congratulation Rajan and other excel's mentors.
>>
>> Regards,
>> Ankit
>>
>>
>> On Wed, May 2, 2012 at 9:30 PM, Ayush Jain  wrote:
>>
>>>  Hello Everyone,
>>>
>>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>>> April'2012
>>> He has posted 185 posts in April 2012 and helped many people through his
>>> expertise. He has been consistent contributor to this excel forum and has
>>> acheived this recognition many times.
>>>
>>> Thanks to Don, Noorain, Asa, Maries, and other folks for helping excel
>>> enthusiasts voluntarily !! Keep it up !!
>>>
>>> Keep posting.
>>>
>>> Regards
>>> Ayush Jain
>>> Group Manager
>>> Microsoft MVP
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

Congratulations Rajan, a very large contribution to the forum
Thanks for your helpful

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Auto Numbers in Filtered Data & Data Validation

[nalini.pradha...@gmail.com]

Dear Experts,



Please help me in the following issues :-



1.I want to know how to get auto serial numbers in filtered data (in
stead of 2,5,7, etc...)

2.Similarly in case of data validation if my data increases it should
reflect in drop down automatically.



Thanks & Regards.



Nalini

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.

[Maries]

Hi,

Check the attachment.

Regards,

MARIES.

On Fri, May 4, 2012 at 12:27 PM, Tony Wu  wrote:

> Hello,
>
> I have a file for the forecast demand, some parts have substitution, what
> I need is if the part has substitution, the original demand will be added
> to the new part and original demand will be zero out, please see the
> attached file for reference.
>
> Thanks,
>
> Tony
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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


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

Re: $$Excel-Macros$$ Rounding value of six digit

[Maries]

Try this too,

=QUOTIENT(A1,1000)*1000


On Sat, May 5, 2012 at 5:47 AM, Maries  wrote:

> *Asa, Good Information*
>
>
> On Fri, May 4, 2012 at 6:44 PM, Asa Rossoff  wrote:
>
>> Hi Shekhar,
>>
>> ** **
>>
>> Either of these:
>>
>> =ROUNDDOWN(A1,-3)
>>
>> =MROUND(A1-500,1000)
>>
>> ** **
>>
>> If you wanted to round to the nearest multiple of 1000, instead of
>> rounding down, you could use either of these:
>>
>> =ROUND(A1,-3)
>>
>> =MROUND(A1,1000)
>>
>> ** **
>>
>> Functions used for/in rounding include:
>>
>> ROUND
>>
>> ROUNDUP
>>
>> ROUNDDOWN
>>
>> MROUND
>>
>> CEILING
>>
>> CEILING.PRECISE
>>
>> FLOOR
>>
>> FLOOR.PRECISE
>>
>> EVEN
>>
>> ODD
>>
>> INT
>>
>> TRUNC
>>
>> MOD
>>
>> LOG10
>>
>> LOG
>>
>> ABS
>>
>> SIGN
>>
>> GCD
>>
>> LCM
>>
>> FIXED
>>
>> TEXT
>>
>> ** **
>>
>> Asa
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Shekhar Sharma
>> *Sent:* Friday, May 04, 2012 8:19 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Rounding value of six digit
>>
>> ** **
>>
>> Hi Experts,
>>
>>  
>>
>> Kindly help me with rounding a value of six digit.
>>
>>  
>>
>> Example:
>>
>>  
>>
>> Cell A1 has value as : 59687
>>
>> I want a formula available in excel to convert this value into 59000.
>>
>>  
>>
>> I have used
>>
>>  
>>
>> =ROUND(A1/1000,0)*1000,
>>
>> however its not a perfect way to convert this value.
>>
>>  
>>
>> Let me know if you are aware of any typical formula available with in
>> excel.
>>
>> --
>> Shekhar Sharma
>> 9910010060
>> "Life consists not in holding good cards but in playing
>> those  you hold well"
>>  "Before you judge another, think of your own last mistake."
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Rounding value of six digit

[Maries]

*Asa, Good Information*

On Fri, May 4, 2012 at 6:44 PM, Asa Rossoff  wrote:

> Hi Shekhar,
>
> ** **
>
> Either of these:
>
> =ROUNDDOWN(A1,-3)
>
> =MROUND(A1-500,1000)
>
> ** **
>
> If you wanted to round to the nearest multiple of 1000, instead of
> rounding down, you could use either of these:
>
> =ROUND(A1,-3)
>
> =MROUND(A1,1000)
>
> ** **
>
> Functions used for/in rounding include:
>
> ROUND
>
> ROUNDUP
>
> ROUNDDOWN
>
> MROUND
>
> CEILING
>
> CEILING.PRECISE
>
> FLOOR
>
> FLOOR.PRECISE
>
> EVEN
>
> ODD
>
> INT
>
> TRUNC
>
> MOD
>
> LOG10
>
> LOG
>
> ABS
>
> SIGN
>
> GCD
>
> LCM
>
> FIXED
>
> TEXT
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shekhar Sharma
> *Sent:* Friday, May 04, 2012 8:19 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Rounding value of six digit
>
> ** **
>
> Hi Experts,
>
>  
>
> Kindly help me with rounding a value of six digit.
>
>  
>
> Example:
>
>  
>
> Cell A1 has value as : 59687
>
> I want a formula available in excel to convert this value into 59000.
>
>  
>
> I have used
>
>  
>
> =ROUND(A1/1000,0)*1000,
>
> however its not a perfect way to convert this value.
>
>  
>
> Let me know if you are aware of any typical formula available with in
> excel.
>
> --
> Shekhar Sharma
> 9910010060
> "Life consists not in holding good cards but in playing
> those  you hold well"
>  "Before you judge another, think of your own last mistake."
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Help Required to update off days in a tracker

[Seema]

hi,
 
thankyou. the tracker looks good. but it allows the user to have the same 
day off for two consecutive weeks. and also allows the user to choose 
multiple days off in the same week.
 
please help in putting these two conditions.
1. the user should not be allowed to have the same day off for 3 
consecutive weeks, ex: if the user has monday off for this week, the 
application shud not allow him to have monday off for week2 and week3.
2. the user should not be allowed multiple days off in the same week.
 
regards
Seema 
On Saturday, 5 May 2012 00:10:20 UTC+5:30, Lalit_Mohan wrote:

> i have made some changes in Noorain's code :) 
>
> PFA
>
> *Regards,*
> *Lalit Mohan*
> *https://www.facebook.com/buzinesstransformation*
>  
>
>
>
> On Fri, May 4, 2012 at 11:16 PM, Seema  wrote:
>
>> hi,
>>  
>> thank you for the effort. but the sheet is not getting updated instead 
>> throws an error asking to debug at line15.
>> also, please let me know the logic applied here.
>>  
>> Regards
>>
>> On Friday, 4 May 2012 22:51:29 UTC+5:30, NOORAIN ANSARI wrote:
>>
>>> Dear Vaseema,
>>>
>>> Please see attached workbook, Hope it will help to you.
>>>
>>> -- 
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.**com
>>>
>>> On Fri, May 4, 2012 at 11:29 AM, Seema  wrote:
>>>

 hello,
  
 i am using a form as a user interface for an employee to enter the off 
 day of their choice week on week. 
  
 i want to update the tracker based on the entries from the combobox.
  
 Attached is the sample file with the entry format.
  
 Any help is highly apprecaited.
  
 Regards
 Seema
  

 -- 
 FORUM RULES (986+ members already BANNED for violation)
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
  
 2) Don't post a question in the thread of another member.
  
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
  
 4) Acknowledge the responses you receive, good or bad.
  
 5) Cross-promotion of, or links to, forums competitive to this forum in 
 signatures are prohibited. 
  
 NOTE : Don't ever post personal or confidential data in a workbook. 
 Forum owners and members are not responsible for any loss.
  
 --**--**
 --**
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>>
>>>
>>>  
>>>
>>>
>>>
>>>   -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>>  
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Need macro website

[Maries]

Hi,

Check below link,

http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm


Regards,

MARIES.

On Sat, May 5, 2012 at 4:41 AM, karthik N  wrote:

> Hi Friends,
>
>
> How learn the macro's in step by step,kindly provide the any macro
> tutorial website
>
>
> Pls Help
>
> Regards
> karthik.N
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Need macro website

[karthik N]

Hi Friends,


How learn the macro's in step by step,kindly provide the any macro tutorial
website


Pls Help

Regards
karthik.N

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days

[Maries]

Hi,

Find the attachment.

Regards,

MARIES.

On Fri, May 4, 2012 at 11:03 PM, Vijayendra Rao wrote:

> Dear Deba Ranjan,
>
> Thanks for efforts, I knew this formula and it was not solved my problem.
>
> I need the below details if any one worked 4th October 2011 to 4th May 2012
> - Total days worked in which beginning of the month, i.e: 4th oct to 31 st
> oct is 28 days, It should be zero if he worked full month.
> - Total completed months i.e. 1st November to 30th April is 6 Months
> - Total days worked in last month: i.e. 1st May to 4th May is 4 days, It
> should be zero if he worked full month
>
> Regards,
> Vijayendra
>
> 2012/5/4 Deba Ranjan 
>
>> *Hi  *Vijay,
>>
>>   You can you try formula, it will help you out.:-
>>
>> For Date diffrence:- =DATEDIF(A2,(B2),"md")
>>
>> For Month diffrence :- =DATEDIF(A2,(B2),"ym")
>>
>> For Year diffrence :-  =DATEDIF(A2,(B2),"y")
>>
>>
>>
>>
>>
>>
>> Thanks & Regards,*
>> *
>>
>> *Deba Ranjan P***
>>
>>  On Fri, May 4, 2012 at 12:39 PM, Vijayendra Rao <
>> vijayendrar...@gmail.com> wrote:
>>
>>>   Dear All,
>>>
>>>
>>>
>>> I need date formula for finding how many days and months between two
>>> different dates. Request you to resolve my query. I have attached is the
>>> same file.
>>>
>>>
>>>
>>> Regards,
>>>
>>> Vijayendra
>>>
>>> 94491 67631
>>>
>>>
>>>
>>> --
>>> ಧನ್ಯವಾದಗಳು,
>>> ವಿಜಯೇಂದ್ರ,
>>> ೯೪೪೯೧ ೬೭೬೩೧
>>>
>>> Regards,
>>> Vijayendra
>>> 94491 67631
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> ಧನ್ಯವಾದಗಳು,
> ವಿಜಯೇಂದ್ರ,
> ೯೪೪೯೧ ೬೭೬೩೧
>
> Regards,
> Vijayendra
> 94491 67631
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

--

Re: $$Excel-Macros$$ Please suggest as i want to learn MS-Access (Noida)

[LAKSHMAN PRASAD]

contect to NOORAIN
 
@ 
 
 



From: vijayajith VA 
To: excel-macros@googlegroups.com 
Sent: Saturday, May 5, 2012 11:31 AM
Subject: Re: $$Excel-Macros$$ Please suggest as i want to learn MS-Access 
(Noida)

HI prince 

Try this.
MVP'S Web Links 
Al Campagna http://home.comcast.net/~cccsolutions/index.html 
Alex Dybenko http://alex.dybenko.com/ 
Allen Browne http://allenbrowne.com/ 
Andrew Couch http://www.upsizing.co.uk/ 
Andy Baron http://www.mcwtech.com/ 
Arvin Meyer http://www.datastrat.com/ 
Bill Mosca http://www.thatlldoit.com/ 
Bob Larson http://www.btabdevelopment.com/ 
Crystal http://www.accessmvp.com/Strive4Peace 
D. C. Conlin http://www.access.qbuilt.com/ 
Daniel Pineault http://www.cardaconsultants.com/ 
Dev Ashish http://www.mvps.org/access 
Doug Steele http://www.accessmvp.com/DJSteele 
Emilio Sancha http://www.mvp-access.es/emilio 
Francisco Javier García Aguado http://accessbuho.mvps.org/ 
Graham Mandeno http://www.mandeno.com/ 
Graham R. Seach http://www.pacificdb.com.au/ 
Gunter Avenius http://www.accessribbon.com/ 
Gustavo Delucchi http://www.delucchimdb.com.ar/ 
Henry Habermacher http://www.psp-online.com/ 
Jeff Conrad http://www.accessmvp.com/JConrad/accessjunkie.html 
Jim Ferguson http://www.fmsinc.com/ 
Joan Wild http://www.jmwild.com/ 
John Viescas http://www.viescas.com/ 
José Bengoechea Ibaceta http://jbengoechea.com/ 
Juan M. Afan de Ribera http://accessvbafaq.mvps.org/ 
Karl Donaubauer http://www.donkarl.com/ 
Ken Getz http://www.mcwtech.com/ 
Ken Snell http://www.accessmvp.com/KDSnell/ 
Klaus Oberdalhoff http://www.sql-insider.de/ 
Lynn Trapp http://www.ltcomputerdesigns.com/ 
M.L. Sco Scofield http://www.scobiz.com/ 
Mary Chipman http://www.mcwtech.com/ 
Michael S. Kaplan http://www.trigeminal.com/ 
Mike Gunderloy http://www.mcwtech.com/ 
Olaf Rabbachin http://www.resources.intuidev.com/ 
Oliver Stohr http://www.access-freak.com/ 
Patrick Wood http://gainingaccess.net/ 
Paul Litwin http://www.mcwtech.com/ 
Philipp Stiefel http://www.codekabinett.de/ 
Rafael Andrada Cortina http://www.mcpegasus.net/ 
Roger Carlson http://www.rogersaccesslibrary.com/ 
Sandra Daigle http://www.daiglenet.com/msaccess.htm 
Simon Lewis http://www.btinternet.com/~srlewis 
Stephen Lebans http://www.lebans.com/ 
Steve Arbaugh http://www.groupacg.com/ 
Steve Clark http://www.fmsinc.com/ 
Steve Schapel http://www.datamanagementsolutions.biz/ 
Teresa Hennig http://www.datadynamicsnw.com/ 
Terry Kreft http://www.mps.co.uk/mps/ 
Thomas Möller http://www.team-moeller.de/ 
Tony Toews http://www.granite.ab.ca 
On Wed, Apr 25, 2012 at 8:55 AM, prince sethi  wrote: 
I am not aware whether i should have to write this or not.. If it not adequate 
post please discard this one but not banned me from this Forum. 
>what will be the duration for the same.-- 
>FORUM RULES (986+ members already BANNED for violation)
> 
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
> 
>2) Don't post a question in the thread of another member.
> 
>3) Don't post questions regarding breaking or bypassing any security measure.
> 
>4) Acknowledge the responses you receive, good or bad.
> 
>5) Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited. 
> 
>NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>owners and members are not responsible for any loss.
> 
>--
>To post to this group, send email to excel-macros@googlegroups.com
>-- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, 
>accurate thread titles. Poor thread titles, like Please Help, Urgent, Need 
>Help, Formula Problem, Code Problem, and Need Advice will not get quick 
>attention or may not be answered. 2) Don't post a question in the thread of 
>another member. 3) Don't post questions regarding breaking or bypassing any 
>security measure. 4) Acknowledge the responses you receive, good or bad. 5) 
>Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited.  NOTE : Don't ever post personal or confidential 
>data in a workbook. Forum owners and members are not responsible for any 
>loss. --To
> post to this group, send email to excel-macros@googlegroups.com

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

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

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

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

4) Acknowledge the respo

$$Excel-Macros$$ Charts

[joseph . camill]

Sent on my BlackBerry® from Vodafone

-Original Message-
From: joseph.cam...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 5 May 2012 04:32:26 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Charts

Hi,

I create a lot of stacked charts and I spend a lot of time formatting the 
overlapped numbers.

I need a macro that will move numbers that overlap other numbers in a stacked 
chart.

Thanks,
Joseph
Sent on my BlackBerry® from Vodafone

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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