Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can I transfer data from sheet 1 to sheet2?
In excel I have several files in which there are areas where data is entered
on a regular basis. To save effort I would like to enter data in one file and have it also enter into another file. Can I by using separate sheets in the first file by combining the files and therefore have one lot of enteries? |
#2
|
|||
|
|||
deshall
You can "link" workbooks together so when you update one the others will be updated. OR........You could combine the workbooks into one workbook with several worksheets and link the cells in sheets to one sheet. Your choice. The latter is easiest to maintain in most cases. See Help on "linking" and "Create a link to another cell, workbook, or program". Gord Dibben Excel MVP On Tue, 7 Dec 2004 13:23:02 -0800, "deshall" wrote: In excel I have several files in which there are areas where data is entered on a regular basis. To save effort I would like to enter data in one file and have it also enter into another file. Can I by using separate sheets in the first file by combining the files and therefore have one lot of enteries? |
#3
|
|||
|
|||
I think what you may have in mine is having say 12 sheets for the year and on
each sheet have the same basic information on all 12 sheets in the same place so that you don't have to type it over again each month? The remaining areas you have the monthly information as you go along Let me knwo if this is what you need. "Gord Dibben" wrote: deshall You can "link" workbooks together so when you update one the others will be updated. OR........You could combine the workbooks into one workbook with several worksheets and link the cells in sheets to one sheet. Your choice. The latter is easiest to maintain in most cases. See Help on "linking" and "Create a link to another cell, workbook, or program". Gord Dibben Excel MVP On Tue, 7 Dec 2004 13:23:02 -0800, "deshall" wrote: In excel I have several files in which there are areas where data is entered on a regular basis. To save effort I would like to enter data in one file and have it also enter into another file. Can I by using separate sheets in the first file by combining the files and therefore have one lot of enteries? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Automatioc spill over data to a new Excel sheet from Xml source? | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |