Re: $$Excel-Macros$$ Worksheet to Master - Row consolidation
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
Re: $$Excel-Macros$$ Worksheet to Master - Row consolidation
U're welcome i' stay in Borneo Island (Indonesia) (^_^) Pada 16/09/2013 13:13, Vishwanath menulis: 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 mailto: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 mailto:excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com mailto: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 mailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com mailto: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
Re: $$Excel-Macros$$ Worksheet to Master - Row consolidation
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 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. Copy of form update rows.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Worksheet to Master - Row consolidation
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