Populate name in cell from other tab.

D

DUSTWUN

New member
Joined
May 17, 2019
Messages
8
Reaction score
0
Points
0
Excel Version(s)
2019
I'm not sure what the proper term it would be, I have two tabs. Tab 1 has personnel with dates that countdown to whomever is overdue. Tab 2 is a rollup and a list of names that are overdue.


My question or dilemma is I want to have the names of the overdue people populate in the first tab.

help please! I've attached the spreadsheet.
 

Attachments

  • EXCEL HELP.xlsx
    22.5 KB · Views: 13
so you want people name (column C) where they had overdue item (column G , K , O) to be listed to in worksheet ROllUP 6L ?
you need to saved it to .xlsm if want to operate a macro, ok with that ?
Or it must be .xlsx type ?
 
This should do it
 

Attachments

  • ExcelGuru 10085 - Populate name.xlsx
    24.7 KB · Views: 17
Cant figure out how to reply with attached .lol

do it in macro way, code as below
if you need do it it excel formula, you need hire someone
too complicated for me

Code: 
Sub run()

Application.ScreenUpdating = False

Dim ws1, ws2 As Worksheet

Set ws1 = Sheets("ROLLUP 6L")
Set ws2 = Sheets("6L TRACKER")

Call CLEAR

WS1LR = ws1.Range("A" & Rows.Count).End(xlUp).Row
ws2lr = ws2.Range("A" & Rows.Count).End(xlUp).Row

ws2.Select

G = 7
K = 11
O = 15

Set Nrange = ws2.Range("c3", "c" & ws2lr)

For Each N In Nrange

G = ws2.Cells(N.Row, 7)
K = ws2.Cells(N.Row, 11)
O = ws2.Cells(N.Row, 15)
    If G = "OVERDUE" Or K = "OVERDUE" Or O = "OVERDUE" Then
    On Error Resume Next
    ws1.Cells(WS1LR + 1, 1) = N.Value
    ws1.Cells(WS1LR + 1, 2) = ws2.Cells(N.Row, 7)
    ws1.Cells(WS1LR + 1, 3) = ws2.Cells(N.Row, 11)
    ws1.Cells(WS1LR + 1, 4) = ws2.Cells(N.Row, 15)
    WS1LR = WS1LR + 1
    End If

Next N

ws1.Select

Application.ScreenUpdating = True
    
End Sub


Sub CLEAR()
Set ws1 = Sheets("ROLLUP 6L")
WS1LR = ws1.Range("A" & Rows.Count).End(xlUp).Row

ws1.Range("A11:D" & WS1LR + 1).CLEAR

End Sub
 
Last edited by a moderator:
That's perfect!!! I can work with this with some tweaking, but such a great starting point!!
 
np . hope you get what you need. i am edit ing the code now to remove it
tq
 
You must log in or register to reply here.
Back
Top