Dear DD,

Coba buka vba,kemudian klick 2 kali pada sheet1(List Kirim GT) dan masukan 
formula:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Sheet2.Range("D3").Value = ActiveCell.Value

End Sub

It's work in Office 2013 SP1

TerimaKasih.

Sent from Yahoo Mail on Android

  • Re: [belajar-excel] For... Andrie - sioe...@yahoo.com [belajar-excel]
  • Re: [belajar-excel] For... Andrie - sioe...@yahoo.com [belajar-excel]
    • [belajar-excel] Ru... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
      • Re: [belajar-e... Andrie - sioe...@yahoo.com [belajar-excel]
        • RE: [belaj... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
          • [belaj... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
            • R... Heru Safrudin superhe...@gmail.com [belajar-excel]
              • ... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
              • ... Heru Safrudin superhe...@gmail.com [belajar-excel]
              • ... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
              • ... Toby kenzo tobyke...@yahoo.co.id [belajar-excel]
              • ... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
              • ... Toby kenzo tobyke...@yahoo.co.id [belajar-excel]
              • ... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
              • ... Heru Safrudin superhe...@gmail.com [belajar-excel]
              • ... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
              • ... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
              • ... Toby kenzo tobyke...@yahoo.co.id [belajar-excel]
              • ... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
              • ... Toby kenzo tobyke...@yahoo.co.id [belajar-excel]
              • ... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]

Kirim email ke