Hi Vabz, Please find the attached file.
thanks in advance if you find solution.. I am wasting everyday so much time for doing vlookups everyday. looking for simple automation Thnaks On Tuesday, July 29, 2014 1:45:48 PM UTC+5:30, Vabz wrote: > > Hi share sample file with data format.. > > Cheers!! > > > On Mon, Jul 28, 2014 at 9:42 AM, venkateswara reddy < > venkatesw...@gmail.com <javascript:>> wrote: > >> 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...@googlegroups.com <javascript:>. >> To post to this group, send email to excel-...@googlegroups.com >> <javascript:>. >> Visit this group at http://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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
sample file.xlsx
Description: MS-Excel 2007 spreadsheet