updating value's with 2 workbooks?

[justchris]

What I'm trying to do is have a cumulitive number from 1 unsave
worksheet to a saved worksheet. Basically, I'll open up 2 worksheet
when I start, (FILE A), and (FILE B)IE: (FILE A) has Cell a1 which i
5, 5 needs to be transfered over to (FILE B) cell a1. (FILE B) will b
saved when im done and (FILE A) will be printed and closed. (FILE B
Needs to sum the totals and keep a record of previous totals.

example -
day 1
FILE A, cell a1 = 5
FILE B, cell a1 = 5
_FILE_B,_cell_a2_=_5_
day 2
FILE A, cell a1 = 7
FILE B, cell a1 = 7
add 5+7 = 13
_FILE_B,_cell_a2_=_13_
day 3
FILE A, cell a1 = 4
FILE B, cell a1 = 4
add 13 + 4 = 17
_FILE_B,_cell_a2_=_17_and so on and so forth

If that makes any sense I could use some help, theres has to be a way
I just dont know how. I'm doing this for book keeping and I need Fil
B to keep track of year to date info. If you knew a simpler way t
keep a year to date kind of record I'm all ears. Thanks in advanc

 

[justchris]

I take it there isnt a way to do this

 

[JE McGimpsey]

You can do almost anything using macros.

I, at least, can't tell what you're trying to do. If this is for a
bookkeeping system, shouldn't you retain the previous values rather than
overwriting them, for auditing and error corrections?

 

[justchris]

Ya, I do need to retain the values on file b. I open up 2 files.
file is for entering the info, the other file is to save the info