1) Add VBA language that consolidates Fuse Main, CompSmP, Wty Htg, and OEM sheets into 1 csv file called [login to view URL] with a button click (see language for the button on the "OORPT" sheet. The .csv file should contain in the first five columns as follows: column 1=SOD, column 2=prom date, column 3=will ship date, column 4=plan date (sched), column 5=scheduler comments. The button should say "Export Data" and should be located on the Coversheet tab.
2) On the "coversheet" tab, the notes field should show missing parts for each sales code. Sales codes are noted in the corresponding notes cell on the coversheet tab. (Missing parts come from the "build comments" column on the OORPT tab where the text string begins with "Parts:" I need all notes after "Parts:" to appear in the notes field. Different notes separated by commas.