Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Moving data when I add a new sheet .

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Yuba City, Ca.
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •