Re: $$Excel-Macros$$ copy from sheets1 to sheets2 automatically

2011-11-01 Thread Sanjib Chatterjee
thank you sam and thank you Ashish regards sanjib On Tue, Nov 1, 2011 at 2:12 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Members, > > I have two sheets in my excel file. In sheets1 i have data but sheets2 is > blank. > I want when i select a value of sheet1 it copy a

Re: $$Excel-Macros$$ copy from sheets1 to sheets2 automatically

2011-11-01 Thread ashish koul
Group the sheets http://spreadsheetpage.com/index.php/tip/making_an_exact_copy_of_a_range_of_formulas/ or add sam's macro to any module and then select any cell sheet 1 and run the macro On Tue, Nov 1, 2011 at 3:02 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear Sam, > how

Re: $$Excel-Macros$$ copy from sheets1 to sheets2 automatically

2011-11-01 Thread Sanjib Chatterjee
Dear Sam, how to execute that. Thanking you Regards, Sanjib On Tue, Nov 1, 2011 at 2:20 PM, Sam Mathai Chacko wrote: > Sub CopyFromSheetToAnotherSheet() > > Selection.Copy Sheets(2).Range(Selection.Cells(1).Address) > > End Sub > > Regards, > > Sam Mathai Chacko (GL) > > > On Tue, Nov 1,

Re: $$Excel-Macros$$ copy from sheets1 to sheets2 automatically

2011-11-01 Thread Sam Mathai Chacko
Sub CopyFromSheetToAnotherSheet() Selection.Copy Sheets(2).Range(Selection.Cells(1).Address) End Sub Regards, Sam Mathai Chacko (GL) On Tue, Nov 1, 2011 at 10:42 AM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Members, > > I have two sheets in my excel file. In shee

$$Excel-Macros$$ copy from sheets1 to sheets2 automatically

2011-11-01 Thread Sanjib Chatterjee
Dear Members, I have two sheets in my excel file. In sheets1 i have data but sheets2 is blank. I want when i select a value of sheet1 it copy and paste in sheets2 automatically this will repeat again and again for each value. Thanking you in Advance Regards, Sanjib -- -- FORUM RULES (925+ m