Create excel formulas on worksheets
$30-250 USD
Pagado a la entrega
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
Example:
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.
Example:
"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
Example:
"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
Nº del proyecto: #4934451
Sobre el proyecto
Adjudicado a:
12 freelancers están ofertando un promedio de $57 por este trabajo
HI DEAR RESPECTED SIR, I AM A VERY HARD WORKING EFFICIENT HIGHLY SKILLED PROFESSIONAL. YOU CAN RELY ON ME ENTIRELY AS I HAVE DONE THESE TYPE OF JOBS PREVIOUSLY WITH HIGH DEGREE OF PERFECTION AND ACCURACY. I AM FREE NOW Más
Easy work. Let expert handle it. I have made various macro's, so this is easy work for me.