Thread: hope there is a formula

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

Method using 2003 - I don't know where the menu commands are located in 2007 or if the keyboard shortcuts are the same. (they should be but then again, we are talking MS)

I'm assuming you want to enter the formulas in the "Target" row - first one in row 27.

Enter your formula in the first row you want to perform the calculation.
Insert a column to the left of Column A.
give your column a header - doesn't matter what it is...
in A2 enter the formula =IF(D5="Monday",1,0)
Fill this formula down to the end of your data
Select all of your data
next apply an auto filter (Data / Filter /Auto Filter)
In your new A column filter for 1s only
Highlight the column where the formulas will be placed. Start your selection in the top most row - this will be the row you entered the formula at the beginning of these instructions
Press Alt+: - this selects visible cells only.
Press the F2 key - this edits the original cell
Press Ctl+Enter - this enters the formula into all of the selected cells, making adjustment to the cells references accordingly.

After you've done the whole week, remove the auto filter and delete Column A.

Wayne1969, Please read the Forum Rules about thread titles before starting your next thread.

ooooooooooh bitchy !!!!!!!!
...watches with glee as wayne throws toys out of pram .....

i will go somewhere else where ...

Godspeed, Wayne.