Home |
Search |
Today's Posts |
#1
|
|||
|
|||
data storage from one worksheet to another
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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 "coal_miner" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
access my data from my master worksheet while calculation is don. | Excel Worksheet Functions | |||
Searching and Retrieving data from a Worksheet | Excel Worksheet Functions | |||
How do I pull data from a previous worksheet? | Excel Worksheet Functions | |||
How to move data on worksheet | Excel Discussion (Misc queries) | |||
URGENT Please... new worksheet with copied formats but no data. | Excel Worksheet Functions |