Dear Cab, Attachment Missing.
On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose <swch...@gmail.com> wrote: > Hi > I have in attached workbook: > Has two worksheets- 'ByGroups' and 'ByAssly" > The two sheets should be the same, however they are in different order. > First Question: Which is the best way to find the differences between the > two sheets as at the moment so that corrections can be made. Have searched > google etc Looks like I need a match/vlookup ?? or probably vba would be > better ? Would like to see a separate sheet with the differences. > Second Question: Once the sheets are sorted, I want to be able to have > entries made onto the part # in each sheet at the same time. eg if I have > part # 27184 I want to enter 'InStock' number entered on both sheets against > that number. I think a user form could be used, but I do not know how to get > both sheets entered at the same time. The user form would show the 5 column > heading (on the RHS) > Your comments and guidance would be appreciated. > > Thankyou > > Charlie Harris > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel