Update info from one worksheet to the master worksheet

[joelui]

Staff Number	6/12/2018	7/12/2018	8/12/2018
200123	D	D	D
PC1223	OFF	OFF	D

<tbody>
</tbody>

Table1 (DailyUpdate)

Staff Number	1/12/2018	2/12/2018	3/12/2018	4/12/2018	5/12/2018	6/12/2018	7/12/2018	8/12/2018	9/12/2018
200123	D	D	D	D	D	AL	OFF	OFF	OFF
200156	OFF	D	D	D	D	D	OFF	OFF	OFF
200171	AL	AL	AL	AL	AL	AL	OFF	OFF	OFF
PC1223	D	D	D	D	OFF	OFF	D	D	D

<tbody>
</tbody>

Table2 (Master)

Hi all,

Happy New Year Eve!

I hope someone can help me with the below.

I have 2 worksheets, first worksheet called "DailyUpdate" (table 1 above) & second worksheet called "Master". each day I will get a daily report but not all staff will appear on the report and I want a VBA that can go and update the Master worksheet based on what is on the "DailyUpdate" file and replace the cells with what is in "DailyUpdate"

Is it possible to have a msg box prompt a user if there is a new staff showing on DailyUpdate not in the Master file....


Thanks,
Joe

 

[Yongle]

Is it possible to have a msg box prompt a user if there is a new staff showing on DailyUpdate not in the Master file..

One way..

Sub MsgBoxNewEmployees()
    Dim wsU As Worksheet, wsM As Worksheet, newEmp As String, rngM As Range, cel As Range
    Set wsU = Sheets("Daily Update")
    Set wsM = Sheets("Master")
    Set rngM = wsM.Range("A2", wsM.Range("A" & Rows.Count).End(xlUp))
        For Each cel In wsU.Range("A2", wsU.Range("A" & Rows.Count).End(xlUp))
            If WorksheetFunction.CountIf(rngM, cel) = 0 Then newEmp = newEmp & vbCr & cel
        Next cel
    If newEmp <> "" Then MsgBox newEmp, , "Additional Employees"
End Sub

 

[Fluff]

Cross posted https://chandoo.org/forum/threads/v...ne-worksheet-to-another-date-and-value.40571/

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[joelui]

Hi Yongle,

Many thanks for you help on this.

Cheers,
Joe

 

[joelui]

Thanks for your help Yongle.

 

[joelui]

Hi Fluff, apologies for this. I will definitely reference it next time.
Cheers,
Joe

 

[Yongle]

thanks for the feedback
happy 2019