Dear all, Please go through the sheet attached, where there are 4 columns.
Column 1 is ID which is used to differentiate the component or item. Column 2 is Stage, which is used to designate where the component / item is being processed (ie) stage 1 or 2. Column 3 is completion quantity of component against the stage mentioned. And Column 4 needs to be filled automatically, when ever new data is added as row detail.(validation at the entry stage of column 3 of any new row addition) For example, please refer to row 8, when I enter A001 in ID, and 2 as stage and Qty as 20, the macro/function should check the previous entries in the 7 rows, with respect to ID and Stage and update CL_stock in row 2 and row 8. That 20 nos of item A001 is passed from Stage 1 to Stage 2. The function / macro also should not allow the user to enter more than the qty 20 in Column C of row 8 and also Stage entry for any item should not get duplicated. In the above case item A001 is processed in toto. Where as for ID B001 the item is processed partially. How to achieve this using Macro/Functions. Regards Eugene -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Validate and Update.xls
Description: MS-Excel spreadsheet
