Results 1 to 2 of 2

Sheet Coding

Threaded View

  1. #1
    Registered User
    Join Date
    08-14-2012
    Location
    Sandwell
    MS-Off Ver
    Excel 2007
    Posts
    15

    Sheet Coding

    Hi i am not sure if there is a post covering this so i apologize in advance if there is

    I am trying to get a sheet code for keeping the input data of a cell and saving it into another cell. To be specific i am talking dates
    I have been made aware of the following code;

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 2 Then
    Target.Offset(0, 1).Value = WorksheetFunction.Text(Target.Value, "mm/dd/yyyy") & vbCrLf & Target.Offset(0, 1).Value
    End If
    End Sub

    This makes the data typed into cell B copy into Cell C as a list

    However i want this to also affect cell G to copy the data into cell H. The same as B does into C

    All help is appreciated thanks
    Last edited by Liam.Poll; 10-03-2012 at 05:27 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1