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/discussexcelFORUM RULES1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick 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
