Project # 1:
On the "COGS TOTAL" sheet (Row 27 and below each yellow column), please create a formula that gives a total quantity of cells with data in them.
Row 27: A,C,E,G,I,K,M,O,Q,S,U,W,Y,AA,AC,AE,AG,AI,AK,AM
A27 =3 by counting cells with numbers in A3:A25
Project # 2:
Using the total 's from project # 1 (Row 27 and below each yellow column), please put these totals on "PRODUCTION" sheet Row B67:O67 by finding matching the initials.
"DR" Cogs Total = 3, find "DR" in Row B1:O1 on "PRODUCTION SHEET" and insert "3" somewhere in Row B67:O67
Project # 3:
On the "VENDOR TOTAL" sheet in Row H47:Y47 (highlighted in pink), please insert the "COGS TOTAL" (Row 26 Blue Column's) by initial's
"DR" Cogs total is $1,117 (COGS TOTAL) and needs to appear somewhere in Row H47:Y47 depending on which column is "DR" (VENDOR TOTAL)
Project # 4:
On the "VENDOR TOTAL" sheet Row 76:183 and Columns H:Y (highlighted in pink) please create a VBA where I can type initials in Row 76 and infromation will appear from the "PRODUCTION" sheet