ok this is the first time i have actually been stuck using excel.
project background: creating a diet template management sheet
i have the daily grids planned out for a full 52 weeks
each day has its own breakdown of calories, water intake, log of meals, nutrient breakdown (protien,carbs,fat) and the reccomended daily total for each.
on the diet schedule worksheet the reccomended totals are drawn from a secondary worksheet which is fine as it lets users tailor the sheet to thier specific needs before they start the program by simply editing the values on the secondary sheet.
now for my problem......
each day has its own rda of cals,and the breakdown for each in protien,carbs, and fats.
what i am looking for is a formula i can enter into each daily total that will give the user a final result for each bit.
tis a bit hard to explain but an example would be:
monday of week 1 total water intake on the sample form is 5200. that number is drawn from the previously mentioned secondary sheet.
as a user consumes water through the day they note how much on the log form and it auto sums to give a total drank each day.
what i want to do is have this total drank subtracted from the daily target allowance so the end users know how close to target they are coming each day.
the formula i have for day 1 is this :
=SUM(C21-C22)
where C21 is the total amount cunsumed during day 1 and C22 is the daily allowance.
this gives me the desired total.
to be honest the thought of going through and manually adding a similar formula for the 365 day spreadsheet is not ranking very high on my " Gee i would love to do that list" .
is there a formula i can use that contains a "wildcard" that will allow me to use the find and replace function, search for the default value i have in the result box and replace with a formula which will read from the desired cells daily?
i havent been working with excel long enough to figure this one out and when i do a web search for help i have no joy.the issue i run into is if i use find and replace now with the current formula , the entire sheet reads from the first day which is kinda useless.
any help will be appreciated.
thank you
Bookmarks