value against names on sheet / page 2 Free Excel Macros (VBA) | Excel Programs

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Excel Free Macros (VBA)

Value Against Names On Sheet / Page 2

Online Excel and Excel Macro (VBA) Courses

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Sub çizelge()
    Dim Tarih
    Dim isim As String
    Dim Son As Integer
    Dim satir, sutun, i
    Dim tarihalani As Range, isimalani As Range, tarih1 As Range, isim1 As Range

On Error Resume Next
   
    Son = Sheets("sayfa2").Range("a65536").End(xlUp).Row
    Set tarihalani = Sheets("sayfa2").Range("c1:ag1")
    Set isimalani = Sheets("sayfa2").Range("a3:a" & Son + 15)
    Tarih = Sheets("sayfa1").Range("A1").Value

For i = 13 To Sheets("sayfa1").Range("b65536").End(xlUp).Row
        isim = Sheets("sayfa1").Range("B" & i).Value
        Set tarih1 = tarihalani.Find(Tarih, lookat:=xlWhole)
        Set isim1 = isimalani.Find(isim)
       
        If tarih1 Is Nothing Then
            MsgBox "Aradığınız isim ve ya tarih bulunamadı.", vbCritical, "Arama Sonucu."
            Exit Sub
        Else
            sutun = tarih1.Column
            satir = isim1.Row
            Sheets("sayfa2").Cells(satir, sutun) = Sheets("sayfa1").Cells(i, 4)
        End If
    Next i
End Sub

Report problem with this macro

Report error

ALL MACROS

Youtube Channel
The following macros may be useful for you.

Similar Results
No	Macro Name
1	value against names on sheet / page 2
2	records detailed formatted cells on the records sheet / page
3	specifies in detail how many references the book contains (on new sheet / page)
4	Write sheet / page names from a1
5	writes the names of all sheet / pages from the active sheet / page and cell and adds a link to the sheet / pages
6	Send all pivot tables to printer
7	Sorts unordered names in column a of sheet / page 1 to a-z in column a of sheet / page 2
8	list sheet / page names 2
9	go to sheet / page when clicking sheet / page names in combobox on active sheet / page
10	excel operators hk
11	listing sheet / page names
12	name the cell write that cell sheet / page name o
13	inserts months as sheet / pages Specifies days in detail
14	put the calendar on the sheet / page (change year)
15	list formulas on new sheet / page
16	specifies in detail how many formulas are in the book (on new sheet / page)
17	finds formulas on active sheet / page lists new sheet / page
18	record on multiple sheet / pages with the same macro
19	sheet / page address and set column width
20	Filter the same values in column a on the next sheet / page and add the totals in b

Excel Free Macros (VBA)

Value Against Names On Sheet / Page 2

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords