Re: $$Excel-Macros$$ Re: Auto highlight Row/Column of Active Cell...

[Vishwanath]

HI all,
This is really nice posting and solution!!!
Just a query extending this macro... Is it possible to run the macro 
running till it is deactivated.  IN short dynamic. I mean the rows and 
columns should be highlighted as the cursor moves.  It would be great 
utility...
rgds
vi

On Tuesday, February 13, 2018 at 5:45:31 AM UTC+5:30, bé trần văn wrote:
>
> Right click on the name sheet, then paste the following code.
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> Cells.Interior.ColorIndex = 0
> Target.Interior.ColorIndex = 40
> End Sub
>
>
> 2018-02-12 15:02 GMT+07:00 who :
>
>> Sorry for the previous post. It works, but also contains some 
>> experimental code which is no necessary, but I think you will see this when 
>> you try it out and will be able to fix this. If you do not see how to fix 
>> it, post and I will edit and repost. It is just pretty late here, after 
>> midnight and I am a little tired.
>>
>> Thanks, David
>>
>> On Thursday, February 8, 2018 at 9:49:25 AM UTC-8, Robert King wrote:
>>
>>> Hi Everyone
>>>
>>> I have a very wide sheet and sometimes it gets difficult to follow which 
>>> row contains the data I need.
>>>
>>> I would love it if excel could overlay shading or a colour to highlight 
>>> the row and column of the active cell. 
>>>
>>> Ive seen vba code which will do this but it overwrites the fill colour 
>>> of any cells which are highlighted.
>>>
>>> Is there a way to achieve the highlighting effect while preserving the 
>>> fill or format settings?
>>>
>>> Thanks very much for your time.
>>>
>>> R K
>>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Worksheet to Master - Row consolidation

[Vishwanath]

Dear De Premor,
I have no words to say thanks..
You are really great.
Which place you from? Wish i could meet you some time.

rgds
vishwanath



On 13 September 2013 08:39, De Premor d...@premor.net wrote:

  PFA and try to run macro named SAVE on module1


 On 29-08-2013 18:57, Vishwanath wrote:

  Dear Experts.
 Need your help.  the solution can be by using the macros.
 I have a workbook containing sheet called Indent and master sheet.
 Indent sheet is form.  The contents of the indent sheet to be updated to
 master sheet in a particular fashion by capturing information of the indent
 sheet in a particular manner given in sample sheet attached to this posting
 - solution required in master sheet.

  1.  Indent sheet is the sheet where data are updated on regular basis
 and needs to be updated in Master sheet
 2. There should be button in Indent sheet to click to update. On clicking
 the button, It should update the rows that are there from row number 18 to
 the row till The row with Total amount to the master sheet
 3. On each change the users update the master by clicking the click to
 update button. The data should be updated below the present data in master
 sheet
 4. The user can insert rows in between row number 18 and Total amount row
 while updating the master. It should take the range dynamically.

  rgds
 Vishwa
  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

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

 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to a topic in the
 Google Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/excel-macros/uh8nMZ4bAQ4/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

$$Excel-Macros$$ Re: Worksheet to Master - Row consolidation

[Vishwanath]

HI Experts,
Your help is appreciated.

On Thursday, August 29, 2013 5:27:09 PM UTC+5:30, Vishwanath wrote:

 Dear Experts. 
 Need your help.  the solution can be by using the macros.
 I have a workbook containing sheet called Indent and master sheet.
 Indent sheet is form.  The contents of the indent sheet to be updated to 
 master sheet in a particular fashion by capturing information of the indent 
 sheet in a particular manner given in sample sheet attached to this posting 
 - solution required in master sheet.

 1.  Indent sheet is the sheet where data are updated on regular basis and 
 needs to be updated in Master sheet
 2. There should be button in Indent sheet to click to update. On clicking 
 the button, It should update the rows that are there from row number 18 to 
 the row till The row with Total amount to the master sheet
 3. On each change the users update the master by clicking the click to 
 update button. The data should be updated below the present data in master 
 sheet
 4. The user can insert rows in between row number 18 and Total amount row 
 while updating the master. It should take the range dynamically.

 rgds
 Vishwa


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Worksheet to Master - Row consolidation

[Vishwanath]

Dear Experts. 
Need your help.  the solution can be by using the macros.
I have a workbook containing sheet called Indent and master sheet.
Indent sheet is form.  The contents of the indent sheet to be updated to 
master sheet in a particular fashion by capturing information of the indent 
sheet in a particular manner given in sample sheet attached to this posting 
- solution required in master sheet.

1.  Indent sheet is the sheet where data are updated on regular basis and 
needs to be updated in Master sheet
2. There should be button in Indent sheet to click to update. On clicking 
the button, It should update the rows that are there from row number 18 to 
the row till The row with Total amount to the master sheet
3. On each change the users update the master by clicking the click to 
update button. The data should be updated below the present data in master 
sheet
4. The user can insert rows in between row number 18 and Total amount row 
while updating the master. It should take the range dynamically.

rgds
Vishwa

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


form update rows.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

[Vishwanath]

Awesome. I was Looking for it.
Thanks guys.

On Monday, July 22, 2013 8:56:49 PM UTC+5:30, Vijay Gande wrote:

 Hi there,

 I'm amateur with excel macros and need help with the following task,

 I've an excel workbook with 16 sheets, all the sheets have same # of 
 columns but different # of rows.  My task is to copy the data from each of 
 these 16 sheets and past in the consolidate sheet in the same workbook. The 
 rows in the sheets are dynamic means they change every month.

 Please find the attached excel for the sample data.

 I appreciate you help in advance.

 Thanks,

 Vijay



-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

[Vishwanath]

Dear Ashish,
Thanks. I was looking for similar solution.
But data structure remains the same.  But the amount should be distributed 
prorated for first month and last month.. For Example.  In the first 
month... the amount should be proportion to number of days rather than 
equal distribution.  in this example the first month distribution should be 
27 days and in the month of December, it should be proportionate to 14 
days. The balance should be distributed equally for other months for whole 
month.
Is it something possible?
best regards
vishwanath
 
 
 

On Thursday, July 18, 2013 10:11:28 PM UTC+5:30, ashish wrote:

 Try this formula


 =IF(AND(G$4=DATE(YEAR($D5),MONTH($D5),1),G$4=DATE(YEAR($E5),MONTH($E5),1)),$F5/(DATEDIF($D5,$E5,m)+1),)

 see if it helps



 On Thu, Jul 18, 2013 at 5:01 PM, Harish P Y py.h...@gmail.comjavascript:
  wrote:

 Please find the attached file and help me for the formula .
 When the start date and date are in different years


 With Regards

 *HARISH P Y*

 *P** **THINK BEFORE YOU PRINT:**Before printing this e-mail think 
 whether it is really necessary. Thanks for your support to protect our 
 environment for the future generation*

 *1 ream of paper = 6% of a tree and 5.4 kg CO2 in the atmosphere
 3 sheets of A4 paper pollutes 1 litre of water*

  
  
 -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners and 
 members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google Groups 
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to excel-macros...@googlegroups.com javascript:.
 To post to this group, send email to excel-...@googlegroups.comjavascript:
 .
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.
  
  




 -- 
 *Regards*
 * *
 *Ashish Koul*


 *Visit*
 *My Excel Blog http://www.excelvbamacros.com/*
 Like Us on 
 Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
 Join Us on Facebook http://www.facebook.com/groups/163491717053198/


 P Before printing, think about the environment.

  
  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

[Vishwanath]

Dear Mr.DP..
Awesome... I admire it.  You have reduced my whole day effort to
few minutes.. My heart filled thanks to you.
Best regards
Vishwanath



On 23 July 2013 23:55, De Premor d...@premor.net wrote:

  Ups Sorry, i dont make an error checking before
 here is the rev code


 =(EOMONTH(D$4,0)$A5)*(D$4$B5)*IF(EOMONTH(D$4,0)$B5,DAY($B5),DAY(EOMONTH(D$4,0))-IF(D$4
 *=*$A5,DAY($A5),0))*($C5/($B5-$A5))

 Rgds
 [dp]

  Pada 24/07/2013 1:15, Vishwanath menulis:


 Dear Mr.DP.
 Thanks a ton.  Yes it computes on daily basis. It certainly helps me.
 I had small difficulty.  There is some problem.  The total of the
 allocated amount exceeds value when we take it from beginning. Example the
 first of if I put date of 1-Oct-13 to some end date, It allocates on number
 of days.. But sum of the allocation exceeds amount to be allocated.  Is it
 possible to rectify this issues?
 Attached the work sheet.
 rgds



 On 23 July 2013 21:11, De Premor d...@premor.net wrote:

  Paste this in Cell G5, then copy left and down

 *
 =(EOMONTH(G$4,0)$D5)*(G$4$E5)*IF(EOMONTH(G$4,0)$E5,DAY($E5),DAY(EOMONTH(G$4,0))-IF(G$4$D5,DAY($D5),0))*($F5/($E5-$D5))
 **
 *
 Formula above will calculate on daily basis

 Rgds,
 [dp]

 Pada 23/07/2013 21:33, Vishwanath menulis:

  Dear Ashish,
 Thanks. I was looking for similar solution.
 But data structure remains the same.  But the amount should be
 distributed prorated for first month and last month.. For Example.  In the
 first month... the amount should be proportion to number of days rather
 than equal distribution.  in this example the first month distribution
 should be 27 days and in the month of December, it should be proportionate
 to 14 days. The balance should be distributed equally for other months
 for whole month.
 Is it something possible?
 best regards
 vishwanath




 On Thursday, July 18, 2013 10:11:28 PM UTC+5:30, ashish wrote:

 Try this formula


 =IF(AND(G$4=DATE(YEAR($D5),MONTH($D5),1),G$4=DATE(YEAR($E5),MONTH($E5),1)),$F5/(DATEDIF($D5,$E5,m)+1),)

  see if it helps



 On Thu, Jul 18, 2013 at 5:01 PM, Harish P Y py.h...@gmail.com wrote:

 Please find the attached file and help me for the formula .
 When the start date and date are in different years


 With Regards

  *HARISH P Y*

 *P** **THINK BEFORE YOU PRINT:**Before printing this e-mail think
 whether it is really necessary. Thanks for your support to protect our
 environment for the future generation*

 *1 ream of paper = 6% of a tree and 5.4 kg CO2 in the atmosphere
 3 sheets of A4 paper pollutes 1 litre of water*


--
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros...@googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.






  --
 *Regards*
 * *
 *Ashish Koul*


  *Visit*
 *My Excel Blog http://www.excelvbamacros.com/*
 Like Us on 
 Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
 Join Us on Facebook http://www.facebook.com/groups/163491717053198/


  P Before printing, think about the environment.



 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google

Re: $$Excel-Macros$$ High low Query

[arvind vishwanath]

Hi ppl ,

Could u suggest some good vb and macros
material
On Dec 5, 2012 6:56 AM, Dhaval Shah todhavals...@gmail.com wrote:

 Friends,

 pls go through the attached  excel sheet

 in main sheet there is raw data of differenet date for different product
 now suppose product x trade for 5 days and 5 days close value is also
 different need to know the which date product x close on highest and lowest
 with date


 thanks

 dhaval shah

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

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

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




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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

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

[Vishwanath]

Hi,
You can also use sumif function

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


   
On Tuesday, October 23, 2012 12:56:36 PM UTC+5:30, Amit Desai (MERU) wrote:

  Dear All,

  

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

  

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

  

 Best Regards,

 Amit

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

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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




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

Re: $$Excel-Macros$$ Re: Need Help in allocation table

[Vishwanath]

Dear wabs,
Thanks for your reply.
The amount should be allocated equally over the period of time.
For example, for expenditure B, total expenditure of Rs. 1 has been 
distributed prorata basis. It works out 3667 for 22 days in April, 5000 for 
may(full month) and 1333 for for June . The period range from and to period for 
allocation is available in column 2 and 3.

Best Regards,
Vishwanath
 
Sent from my iPhone


On 08-Oct-2012, at 5:28 PM, Vabz v...@vabs.in wrote:

 Hi
  
 Can you explain base for allocation, theer is no standard method that can be 
 assumed on the basisi if data given by you.
  
 Rgds//Vabs
 
 On Thursday, October 4, 2012 12:03:22 PM UTC+5:30, Vishwanath wrote:
 
 Need help
  
  
 Dear All,
 I need your help in automatic some calculations in spreadsheet.
  
 I have data in excel as below;
 It consists of 2 parts. first part is Expense statement and second part is 
 allocation required.
 The expense statement has data period for each type of expenditure.  The 
 same needs to be allocated monthwise columns on prorata basis.
 I am not familiar with Macro.  Is there any formulat which can help the 
 allocation?  The file containing data is attached. Thanks in advance for 
 help.
  
 Data Available   Allocation required
 Satement of Allocation of expenses - Monthwise   
  
 Item Period  Amount  Apr-12  May-12  Jun-12  Jul-12  Aug-12  Sep-12
  FromTo   
 Expenditure A1-Apr-1230-May-12   15000   75007500
  
 Expenditure B8-Apr-127-Jun-121 3,667 
 5,000   333  
 Expenditure C15-May-12   10-Sep-12   5   0   6,780   
 12,712  12,712  12,712   5,085  
   
   
   
 Total'
 
  
 
  75000   11167   19280   14045   12712   12712   5085
 -- 
 Join official facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES (1120+ members already BANNED for violation)
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
 Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
 get quick attention or may not be answered.
  
 2) Don't post a question in the thread of another member.
  
 3) Don't post questions regarding breaking or bypassing any security measure.
  
 4) Acknowledge the responses you receive, good or bad.
  
 5) Cross-promotion of, or links to, forums competitive to this forum in 
 signatures are prohibited. 
  
 6) Jobs posting is not allowed.
  
 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
  
 NOTE : Don't ever post personal or confidential data in a workbook. Forum 
 owners and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google Groups MS 
 EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to 
 excel-macros+unsubscr...@googlegroups.com.
  
  

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Re: Need Help in allocation table

[Vishwanath]

Dear Ashishi,
Sending the the sample file.
thanks in advance for your cooperation.

On 8 October 2012 21:55, ashish koul koul.ash...@gmail.com wrote:

 can you attach the sample sheet


 On Mon, Oct 8, 2012 at 9:53 PM, Vishwanath vishwana...@gmail.com wrote:

 Dear wabs,
 Thanks for your reply.
 The amount should be allocated equally over the period of time.
 For example, for expenditure B, total expenditure of Rs. 1 has been
 distributed prorata basis. It works out 3667 for 22 days in April, 5000 for
 may(full month) and 1333 for for June . The period range from and to period
 for allocation is available in column 2 and 3.

 Best Regards,
 Vishwanath

 Sent from my iPhone


 On 08-Oct-2012, at 5:28 PM, Vabz v...@vabs.in wrote:

 Hi

 Can you explain base for allocation, theer is no standard method that can
 be assumed on the basisi if data given by you.

 Rgds//Vabs

 On Thursday, October 4, 2012 12:03:22 PM UTC+5:30, Vishwanath wrote:

 Need help


 Dear All,
 I need your help in automatic some calculations in spreadsheet.

 I have data in excel as below;
 It consists of 2 parts. first part is Expense statement and second part
 is allocation required.
 The expense statement has data period for each type of expenditure.  The
 same needs to be allocated monthwise columns on prorata basis.
 I am not familiar with Macro.  Is there any formulat which can help the
 allocation?  The file containing data is attached. Thanks in advance for
 help.

 Data Available Allocation required  Satement of Allocation of
 expenses - Monthwise   Item Period Amount Apr-12 May-12
 Jun-12 Jul-12 Aug-12 Sep-12From ToExpenditure A
 1-Apr-12 30-May-12 15000 7500 7500 Expenditure B 8-Apr-12
 7-Jun-12 1   3,667  5,000  333Expenditure C 15-May-12
 10-Sep-12 5 0 6,780  12,712  12,712  12,712   5,085


 Total'


 75000 11167 19280 14045 12712 12712 5085

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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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



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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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






 --
 *Regards*
 * *
 *Ashish Koul*


 *Visit*
 *http://www.excelvbamacros.com/*
 *http://www.accessvbamacros.com/*

 P Before printing, think about the environment.



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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

 5) Cross-promotion

$$Excel-Macros$$ Need Help in allocation table

[Vishwanath]

Need help
 
 
Dear All,
I need your help in automatic some calculations in spreadsheet.
 
I have data in excel as below;
It consists of 2 parts. first part is Expense statement and second part is 
allocation required.
The expense statement has data period for each type of expenditure.  The 
same needs to be allocated monthwise columns on prorata basis.
I am not familiar with Macro.  Is there any formulat which can help the 
allocation?  The file containing data is attached. Thanks in advance for 
help.
 
  Data Available Allocation required  Satement of Allocation of 
expenses - MonthwiseItem Period Amount Apr-12 May-12 Jun-12 
Jul-12 Aug-12 Sep-12From ToExpenditure A 1-Apr-12 
30-May-12 15000 7500 7500  Expenditure B 8-Apr-12 7-Jun-12 1   
3,667 
5,000 333Expenditure C 15-May-12 10-Sep-12 5 0 6,780 12,712 12,712 
12,712  5,085 

Total'

 
75000 11167 19280 14045 12712 12712 5085 

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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




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