I have 49 sheets of meal plans in Excel looking like the regular output image attached. I need someone to format them in Excel to look like the final output image attached.
Basically you will need to:
-Hide the rows that are used for calculating
-Adjust the calculation to total the meals and the sum of the meals
-Format the headings, meal rows
-Capitalize the first letter for the foods on the left, leave units of measure lower case
-Fix units of measure c to cups and tbs to tbsp
-Make width common for all sheets – protein, calories, fat, carbs should be same width.
-Rename table headings as shown in final output image.
I will provide 7 files each with the 7 meal plans. Each sheet is unique but same layout, so you need to change each individually. Fairly simple work that might take 3-4 hours or so.
Your bid is to change 49 sheets from unformatted to formatted look in Excel. Must have experience in Excel and a positive rating. I need this within 48 hours.