Re: $$Excel-Macros$$ reference auto copy in shee2

2011-09-08 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ reference auto copy in shee2

2011-09-08 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ reference auto copy in shee2

2011-09-08 Thread Sanjib Chatterjee
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 ' '

Re: $$Excel-Macros$$ reference auto copy in shee2

2011-09-08 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ reference auto copy in shee2

2011-09-08 Thread Venkat CV
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