| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
import data from previous sheet in excel
I have created an excel spread sheet, to track data over multiple years. As
I create a new sheet for a new year, hou do I Import final tallys from the previous year i n a formula, so I don't have to manually update the 'sheet'! command |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
import data from previous sheet in excel
Click in the destination cell, type the = sign to start the formula, then go
to the source sheet and click in the source cell, which will put that cells's reference into your formula. Hit enter. -- David Biddulph "gasman" wrote in message ... I have created an excel spread sheet, to track data over multiple years. As I create a new sheet for a new year, hou do I Import final tallys from the previous year i n a formula, so I don't have to manually update the 'sheet'! command |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
| Import data into Excel sheet from CSV File | Excel Discussion (Misc queries) | |||
| Best way to import data from an e-mail to an excel sheet? | Excel Discussion (Misc queries) | |||
| Protecting sheet disables import of extetrnal data in Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I import data from 1 workbook excel sheet into another? | New Users to Excel | |||
Hybrid Mode
