Auto fill date into multiple sheets based on main sheet

[lawrence24]

Hi guys,

I've posted a few other threads regarding this same type of question - I've tried to do it myself, and I've just given up. So, I'm giving you the whole excel sheet. If someone could PLEASE help me, that would be amazing!

There's the "Master" sheet. This is what I will fill in every month. From the 1st to the 30th (or 31st). For each day, I will fill in all the appropriate date for that row. Doesn't mean there will be any data for every single cell in that row, if there is any, I will enter it.

Now, I've entered sample data into the first row (1st of Oct). What I need to happen is for many different things:

1. I will enter data into the first row (as necessary).
2. Whatever value I enter into B4 (and below) should be copied over to Z2.
3. Z5 will be entered manually by me. Based on this value, Z6 and Z7 will be calculated automatically (already done).
4. B4 will be copied over to the same date into sheets 'MU' and 'KD'. So, B4 (Master) will be copied over to B4 (MU) and B3 (KD).
5. Sheet SH however will have the total of Master B4 + H4:L4 + P4 + S4.

6. Master Z6 data will be copied into DST B3.
7. The sum of Master H4:L4 will copied over to DST C3.
8. Master P4 will be copied over to DST D3.
9. Master S4 will be copied over to DST E3.

10. Master Z7 data will be copied into NAT B3.

11. H4 needs to be copied into J4U B28.
12. I4 needs to be copied into J4U C28
13. J4 into J4U D28.
14. K4 into J4U E28.
15. L4 into J4U F28.
16. The total of H4:L4 will be copied over to J4U D21.

All of this has to be done each time I enter data into a row. And I will do that every day.

test.xlsm

[lawrence24]

Anyone at all?

[sktneer]

This is the max help I can offer to you. Please find the attached sheet to see if this works as per your requirement. The worksheet contains a code for Worksheet Change Event and you will find this code on Master Sheet module. You need to follow a sequence while filling the info on the sheet. The proper sequence is mentioned on the Master Sheet in red text. Please read it carefully to know how the code will proceed.
Hope this helps.