data storage from one worksheet to another

[Guest]

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?

 

[JulieD]

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.

 

[Guest]

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]

Hi

in your Month to Date report how is the data structured, is it like
........A.........B............C...........D........E.
1.....Jan.......Feb.......Mar........Apr......May
2.....10000...12500....30000..15000....3000

where the value in E2 is the value you want to be updated automatically from
your other workbook?

and in your other workbook do you have a month to date column e.g.
........A...........B............C.......
1...Date.......Tonnes....Mth to Date
2...May 1.....1000.......1000
3....May 2.....1000......2000
4...May 3......1000......3000

if so, open both workbooks, click on E2 of the Month to Date workbook
and type
=MAX(
then switch to the other workbook and click on the column header C and then
press ENTER

now when you next open the monthly workbook you will be asked whether or not
you want to update links, choose YES and you should always see the total
month to date value displayed based on the information in the daily book.

-
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway