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