updating value's with 2 workbooks?

  • Thread starter Thread starter justchris
  • Start date Start date
J

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
 
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?
 
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
 
Back
Top