RUMUS / SCRIPT EXCEL AUTO INSERT KARYAWAN SESUAI NAMA ATASAN

 

Saya punya data kumpulan karyawan ,

sheet 1 adalah nama acak karyawan yang baru didaftarkan:

saya mau di sheet 2 sudah otomatis auto insert nama karyawan abru tersebut di sheet ke 2 dengan susunan dibawah nama atasan seperti gambar attachment ( terlampir ),



Microsoft Excel

Published Budget: Rp 51,000 - 60,000
Finish Days: 3
Published Date: 24/01/2021 16:49:11 WIB
Start Date:
Finish Date:
Project Status: Canceled by Owner
Accepted Worker:
Accepted Budget: Rp 0
Project Ending:

Project Owner

adninajah
    
8.00/10.00
16 Point
#7,518 dari 296,436

Accepted Worker

Bid masih terbuka.

Place New Bid

  User Bids

patrick_kinata
    
10.00/10.00

Storywin
    
10.00/10.00

DamianNK
    
9.70/10.00

Abdazikri
    
10.00/10.00

Iswanto
    
9.72/10.00

johansptraa
    
10.00/10.00

arayulkha
    
9.70/10.00

indraniman
    
10.00/10.00

sholeh
    
10.00/10.00

sigidsetyo
    
9.80/10.00

damayani_suyitno
    
10.00/10.00

Alfhian_muhammad
    
10.00/10.00

vintyer
    
10.00/10.00

rifkiabdu
    
10.00/10.00

numburanggata
    
0.00/10.00

SURYA27
    
0.00/10.00

rahmadhabibi
    
0.00/10.00

JoStUDH
    
0.00/10.00

izzah617
    
0.00/10.00

maskoko15
    
0.00/10.00

fadli18
    
0.00/10.00

ettrislasanov
    
0.00/10.00

fistaulia
    
0.00/10.00

foot_graph
    
0.00/10.00

ronnyhartono9atgmail.com
    
0.00/10.00

enggarsischawati
    
0.00/10.00

Grace1899
    
0.00/10.00

juan246
    
0.00/10.00

Febri11
    
0.00/10.00

Dea1131
    
0.00/10.00

IndoPranata_
    
0.00/10.00

Said_Muhibi
    
0.00/10.00

deviafifin
    
0.00/10.00

Hadi_Maolana
    
0.00/10.00

Recommended Workers

Iswanto

23,436 points
510 projects
    
9.72/10.00

butirpadi

3,730 points
2 projects
    
10.00/10.00

derodevil

3,554 points
26 projects
    
9.46/10.00

lamazido

1,853 points
7 projects
    
9.88/10.00

appzone

4,063 points
21 projects
    
9.86/10.00

Recommended Services

Pembuatan Add-in VBA Macro Excel / Outlook

Rp 950,000
9 sales
    
9.78/10.00

Pembuatan Program Matlab

Rp 1,500,000
3 sales
    
10.00/10.00

Open Projects

Memperbaiku bug dan menambaah feature aplikasi

Rp - 0Owner: hendramudaa
Deadline: 9 days

Aplikasi database surat dengan ms.access

Rp - 0Owner: irsyad
Deadline: 30 days

Memindahkan Projects Laravel dari VPS DO ke Vultr

Rp - 0Owner: insight
Deadline: 3 days

Merubah Kode C# Laporan EXCEL

Rp - 0Owner: Appmaker.id
Deadline: 7 days

Form Inputan dengan Aplikasi VBA Excel

Rp - 0Owner: hoktavian
Deadline: 7 days