I am trying to create a Month to Date total of all tons mined. I have one
worksheet that is my daily report that has columns for daily tonnage, and one
column for month to date total. Now I am trying to figure out a way to enter
the tons in on one sheet for the date, then it sends the data to my report,
but at the same time updates month to date. Any help would be appreciated.

"JulieD" wrote:

Hi

this requires VBA coding, if you'ld like to give us an idea of why you want
to key into A and have it stored in B we might be able to offer alternative
solutions.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"coal_miner" wrote in message
...
I am setting up a worksheet and need some assistance. I have two
worksheets,
A.xls, and B.xls. I am trying to have these worksheets setup so that I
can
key in data in A, and then it will store in B. But my problem after it is
stored in B, I want to be able to go back to A, delete, and key in more
information, then have that information added to the existing data in B.
Cany anyone help and is this even possible?