Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other
Hi Noorain On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Cab, Question -1, you can use attached Add in to Compare two worksheets.. Question -2, You can group both sheets to same entry on same time. Press ctrl+shift+Pg down.. Thanks for your reply and attachment. However the attachment opens Excel but will not show the workbook. If you could check and resend for me that would be great. Thanks and regars Charlie Harris On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose swch...@gmail.com wrote: Hi OOPS This time attached. Thanks Charlie On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose swch...@gmail.com wrote: Hi and oops. Attached now. On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: 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 -- -- 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 -- -- 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.
Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other
Dear Cab, Actually it is Add-In file when you click on this, it will be Show in Add-in Menu bar when you need it can be use.. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Aug 30, 2011 at 12:10 PM, Cab Boose swch...@gmail.coim wrote: Hi Noorain On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Question -1, you can use attached Add in to Compare two worksheets.. Question -2, You can group both sheets to same entry on same time. Press ctrl+shift+Pg down.. Thanks for your reply and attachment. However the attachment opens Excel but will not show the workbook. If you could check and resend for me that would be great. Thanks and regars Charlie Harris On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose swch...@gmail.com wrote: Hi OOPS This time attached. Thanks Charlie On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose swch...@gmail.com wrote: Hi and oops. Attached now. On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Attachment Missing. On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose swch...@gmail.comwrote: 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 -- -- 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 --
Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other
Hi Noorain Thanks for that. It does not show in the add-in at the moment. Have opened Excel and then opened the file you sent. Is there a process that I should foolw ? Thankyou Charlie On Tue, Aug 30, 2011 at 7:43 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Cab, Actually it is Add-In file when you click on this, it will be Show in Add-in Menu bar when you need it can be use.. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Tue, Aug 30, 2011 at 12:10 PM, Cab Boose swch...@gmail.coim wrote: Hi Noorain On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Question -1, you can use attached Add in to Compare two worksheets.. Question -2, You can group both sheets to same entry on same time. Press ctrl+shift+Pg down.. Thanks for your reply and attachment. However the attachment opens Excel but will not show the workbook. If you could check and resend for me that would be great. Thanks and regars Charlie Harris On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose swch...@gmail.com wrote: Hi OOPS This time attached. Thanks Charlie On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose swch...@gmail.com wrote: Hi and oops. Attached now. On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Attachment Missing. On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose swch...@gmail.comwrote: 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 -- -- 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
Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other
Dear Cab, Process to add Add-Ins in Excel Ribbon Excel Option-Add-Ins-Manage-Excel Add-Ins-Go-Ok You can see below link.. http://www.lytebyte.com/2009/01/08/how-to-add-and-remove-excel-add-in-or-plugins/ -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Aug 30, 2011 at 1:23 PM, Cab Boose swch...@gmail.com wrote: Hi Noorain Thanks for that. It does not show in the add-in at the moment. Have opened Excel and then opened the file you sent. Is there a process that I should foolw ? Thankyou Charlie On Tue, Aug 30, 2011 at 7:43 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Actually it is Add-In file when you click on this, it will be Show in Add-in Menu bar when you need it can be use.. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Tue, Aug 30, 2011 at 12:10 PM, Cab Boose swch...@gmail.coim wrote: Hi Noorain On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Question -1, you can use attached Add in to Compare two worksheets.. Question -2, You can group both sheets to same entry on same time. Press ctrl+shift+Pg down.. Thanks for your reply and attachment. However the attachment opens Excel but will not show the workbook. If you could check and resend for me that would be great. Thanks and regars Charlie Harris On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose swch...@gmail.com wrote: Hi OOPS This time attached. Thanks Charlie On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose swch...@gmail.comwrote: Hi and oops. Attached now. On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Attachment Missing. On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose swch...@gmail.comwrote: 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 -- -- 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/ --
Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other
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