Spreadsheet help,

[Rjb]

Ok, working on this for work and I can not figure this out I'm not
real familiar with excel. I need to take a number that changes day to
day, and enter it into cell corrosponding to the days of the week on
another spreadsheet. I'm using an IF statement to figure out the day
of the week and put the number in, using
(weekday(now(),2)=1,2,3,4,5),b2,(don't know what to put here)
depending on the day. The problem I am haveing is I need the number in
the cell to stay the same that it was on that day so I can total the
week up at the end of the week.

input cell on monday->25 , input cell on tues-> 15

then the cells with the if statements should look like this,

Mond->25, Tues-> 15,

but instead on tues

mond->0, tues->15

Hope this makes sense

 

[Rjb]

I don't think that will work. Basically I am taking the value from 1
cell in a spreadsheet 1, same file, and putting it in another cell, in
a different spreadsheet 2, same file, based on what day of the week it
is. The problem is the on tuesday the value taken from spreadsheet 1
and put in the cell for monday on spreadsheet 2, is erased because the
source cell on spreedsheet 1 is changed for the tuesday value.

Ex.
Spreedsheet 1

Todays production
15

spreedsheet 2

Production by day,

Mon Tues Wed...
15 0 0
----------------------------------------------------------------------------
Then on tues. this is what it reads now,

Spreadsheet 1

Todays production
30

Production by day
Spreadsheet 2
Mon Tues Wed
0 30 0

------------------------------------------------------------------------------
It should read this

Spreadsheet 2

Production by day
mon tues wed...
15 30 0

Now I know the problem is that since the source cell changes everyday
that the previous days values are not staying like they should, there
has to be away to keep it from changing the target cell when the
source cell changes.