Moving data when I add a new sheet .

rdrum · Mar 29th, 2002, 07:10 PM

I want the data,(numbers) from cell BA41 (of the old page) to go to cell BA37 (of a new page)every time I create a new page in my book. Thanks in advance.

daleyman · Mar 29th, 2002, 07:17 PM

try this (add it to the code of the workbook object... it will take the reference value and put it onto every sheet you add or any existing one that you select...

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Sh.Range("ba37") = Sheets("source_sheet_name").Range("ba41")
End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 29th, 2002, 07:10 PM	#1
rdrum New Member Join Date: Mar 2002 Location: Yuba City, Ca. Posts: 16	I want the data,(numbers) from cell BA41 (of the old page) to go to cell BA37 (of a new page)every time I create a new page in my book. Thanks in advance.

Mar 29th, 2002, 07:17 PM	#2
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	try this (add it to the code of the workbook object... it will take the reference value and put it onto every sheet you add or any existing one that you select... Private Sub Workbook_SheetActivate(ByVal Sh As Object) Sh.Range("ba37") = Sheets("source_sheet_name").Range("ba41") End Sub