Event Triggering When Specific type of information is entered into Shipping Schedule

Hi all, I am brand new to this forum and have a problem I think you guys would be able to answer.

Ok, so I am looking for some VBA code (or function) to do the following in my (tentative) shipping schedule:

A) When I enter a new shipment in the project column, with its shipment date in the ship column, I want it to automatically create 2 more entries at later dates (also in project column and date column), because shipments are always done in 3 different trucks.

B) These new entries need to be in different colors. So first entry (the one I manually type in) will be in Green

C) The second and automatically (macro) added entry should be 46 days after the first entry and have the same project, notes, and cpm info, but needs to be in blue font and instead of saying truck 1 trellis and exterior, it needs to say truck 2 trim and beams.

D) The third and last automatically added entry should be 81 days after the first entry and have the same project, notes, and cpm info as whatever i manually typed, but needs to be in yellow font and instead of saying truck 1 or 2, it needs to say truck 3 cabinets.

I realize that the format of the spreadsheet needs work, so if you feel so inclined, go ahead and add rows, headers, or whatever so that each months area is the same size, etc.

Also, it may not be necessary, but you might need to have the shipping date be in mm/dd/yyyy format instead of 28-Feb format, which is perfectly fine.Attachment 144106

Thanks for all your help you guys!
Cheers,
Siddhartha Owens
2011 tentative shipping schedule Macro.xlsm

Hi, look at the attached file and see if it suits your needs.
Remark that program is adding new lines to the sheet in order to be sure not to overwrite anything.
See comment in VBA for possible modifications.
Regards