VBA help ... copy data from one worksheet to another (date and value)

[Joelui]

Hi all,

I hope someone can help me with the VBA.

I have 2 worksheets, first worksheet called "DailyUpdate" & 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 the value on the "DailyUpdate" corresponding with the date and staff number and replace the cells in Master worksheet

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 too....

Thanks,
Joe

 

[vletm]

Joelui
My version of that case ...
1) Fill 'DailyUpdate'-sheet as 'normal'
2) Press [Update Master]-button

(there are reasons ...why this way!)​

 

[Joelui]

Joelui
My version of that case ...
1) Fill 'DailyUpdate'-sheet as 'normal'
2) Press [Update Master]-button

(there are reasons ...why this way!)​

thank you so much for your help on this. this is exactly what I need!! is it possible to keep the Master worksheet in the same format?

Thanks,
Joe

 

[vletm]

You wrote ... this is exactly what I need!! ... Yes!
... but You continue with a question ... hmm?
Answer is Yes ..
but as I wrote (there are reasons ...why this way!)
~ if in Master-sheet there would be more staff than dates...
= if You'll use this only eg 10 days and every day will come ~111 new staff ... hmm?
( My version: You'll use this eg 2 years and there would be less than 730 staff ... hmm?)
Of course, You can modify that code Yourself ... as You would like ...

 

[Joelui]

You wrote ... this is exactly what I need!! ... Yes!
... but You continue with a question ... hmm?
Answer is Yes ..
but as I wrote (there are reasons ...why this way!)
~ if in Master-sheet there would be more staff than dates...
= if You'll use this only eg 10 days and every day will come ~111 new staff ... hmm?
( My version: You'll use this eg 2 years and there would be less than 730 staff ... hmm?)
Of course, You can modify that code Yourself ... as You would like ...

Indeed you are correct. thanks again