Re: $$Excel-Macros$$ reference auto copy in shee2
Dear Sanjib, Please see attached sheet. On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Good Morning Everybody, I want to create a macro to copy the selected data from sheets1 to sheet2 automatically after pressing a shortcut key. Please help who to do that. Waiting for your reply. Thank you in Advance Sanjib Chatterjee -- -- 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://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *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 Short_cut Key.xlsm Description: Binary data
Re: $$Excel-Macros$$ reference auto copy in shee2
Dear Sanjib, Another option, you record macro with short-cut key and paste red color code Sub Macro10() ' ' Macro10 Macro ' ' Keyboard Shortcut: Ctrl+r ' *If TypeName(Selection) = Range Then Selection.Copy Sheets(Sheet2).Range(A Sheets(Sheet2).UsedRange.Rows.Count + 1) End If * End Sub On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Good Morning Everybody, I want to create a macro to copy the selected data from sheets1 to sheet2 automatically after pressing a shortcut key. Please help who to do that. Waiting for your reply. Thank you in Advance Sanjib Chatterjee -- -- 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://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *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$$ reference auto copy in shee2
Dear Friends, error message will not take any arguments On Thu, Sep 8, 2011 at 1:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sanjib, Another option, you record macro with short-cut key and paste red color code Sub Macro10() ' ' Macro10 Macro ' ' Keyboard Shortcut: Ctrl+r ' *If TypeName(Selection) = Range Then Selection.Copy Sheets(Sheet2).Range(A Sheets(Sheet2).UsedRange.Rows.Count + 1) End If * End Sub On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Good Morning Everybody, I want to create a macro to copy the selected data from sheets1 to sheet2 automatically after pressing a shortcut key. Please help who to do that. Waiting for your reply. Thank you in Advance Sanjib Chatterjee -- -- 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://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *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
Re: $$Excel-Macros$$ reference auto copy in shee2
Dear Sanjib, Please see updated sheet.. On Thu, Sep 8, 2011 at 5:03 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Friends, error message will not take any arguments On Thu, Sep 8, 2011 at 1:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sanjib, Another option, you record macro with short-cut key and paste red color code Sub Macro10() ' ' Macro10 Macro ' ' Keyboard Shortcut: Ctrl+r ' *If TypeName(Selection) = Range Then Selection.Copy Sheets(Sheet2).Range(A Sheets(Sheet2).UsedRange.Rows.Count + 1) End If * End Sub On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Good Morning Everybody, I want to create a macro to copy the selected data from sheets1 to sheet2 automatically after pressing a shortcut key. Please help who to do that. Waiting for your reply. Thank you in Advance Sanjib Chatterjee -- -- 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://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *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://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *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 Short_cut Key(Update).xlsm Description: Binary data
Re: $$Excel-Macros$$ reference auto copy in shee2
Hi Sanjib, You Can try Advanced filter Option in 2007 *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Good Morning Everybody, I want to create a macro to copy the selected data from sheets1 to sheet2 automatically after pressing a shortcut key. Please help who to do that. Waiting for your reply. Thank you in Advance Sanjib Chatterjee -- -- 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