Hi Dear's, Please hlep me with Macros,
I have problem with multiple sheets need to update corresponding status as per the order number in master sheet. Worksheet 1 "Master" is a list of orfer numbers that gets updated several times daily (some order numbers are deleted and others are added as they are brought in and shipped out). Worksheet 2 is a "Group1" log that is manually filled out every day, then printed and erased at 9am the following morning. Master loaded are posted on this sheet along with the order number, Status, Date, and other stuff. How do I automatically update the "Master" sheet (with the date loaded, order number, loader, etc.) when the operator fills in the cells on the "daily" worksheet? Bear in mind the info on the "Group1" sheet will disappear before dawn the following day. I want the data to stay with the Master number on the "Master" sheet. It seems to me the only way is to get the master number off the "Group1" worksheet and look it up on the "Master" sheet and copy/paste the info into the appropriate cells in columns to the right of the order number. Like this I have Group2, Group3,Group4, Group5 sheets are there , these all data columns with ordernumber & status, that shold be vlookup with Master file order number & paste that corresponding status in the Group1, Group2, Group3, Group4, Group5 Columns in the respective in the master sheet. Please help me with code. Thanks & Regards Venkat -- 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/d/optout.