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 * * * On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Good Morning Everybody, > > I wa

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 > wrote: > >> Dear Sanjib, >> >> Another option,

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 wrote: > Dear Sanjib, > > Another option, you record macro with short-cut key > and paste red color code > > Sub Macro10() > ' > ' Macro10 Macro > ' > ' Keyboard Shortcut:

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 +

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