data entry to correct cell range...code needs help

[paul_pearson]

Hi

I have userform "Production" transferring data to the correct cell range....need help getting the code to transfer "Planned Stop" and Machine Stoppage

All dates for Userforms called "Production","Planned Stop" and Machine Stoppage go into Column B in the sheets..
Planned Stop data transfers to Column G,H and I
Machine Stoppage data transfers to Columns J,K,L,M,N,O,P,Q

When data is entered by any of the 3 userforms into the sheets that there is only 1 entry per row....sample:if data is entered in row 15 for XFLOW A for production then the next entry into XFLOW A sheet goes into row 16....please see example sheet attached for sheet XFLOW A

Example:When an entry is entered in say Production for row 15 can the empty cells for Planned Stop and Machine Stoppage in row 15 automatically color Red

Thanks

Paul