| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto fill entered data from one worksheet to another
When I enter data in RT report cell B18 I want worksheet#2 to to autofill
with the same information I asked that cell to = 'RT Report'!B18 but the formula is in the cell not the data? How do I fix this I am sure it is simple |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto fill entered data from one worksheet to another
So, in other words, when looking in the spreadsheet, you are seeing the
formula instaed of the value from the other sheet? Try hitting CTRL+~ "Jane Griffel" wrote: When I enter data in RT report cell B18 I want worksheet#2 to to autofill with the same information I asked that cell to = 'RT Report'!B18 but the formula is in the cell not the data? How do I fix this I am sure it is simple |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto fill entered data from one worksheet to another
It is possible that the cell in which you are entering the formula has been
pre-formatted as Text. Format to General then F2 and Enter to re-enter the formula. Gord Dibben MS Excel MVP On Wed, 9 Sep 2009 12:13:19 -0700, Jane Griffel wrote: When I enter data in RT report cell B18 I want worksheet#2 to to autofill with the same information I asked that cell to = 'RT Report'!B18 but the formula is in the cell not the data? How do I fix this I am sure it is simple |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Fill Color When Data is Entered | Excel Discussion (Misc queries) | |||
| change fill color in 2 cells when data entered in one | Excel Worksheet Functions | |||
| Auto calculate formulas when new data is entered | Excel Discussion (Misc queries) | |||
| Auto fill for data from another worksheet | Excel Discussion (Misc queries) | |||
| Auto date/time insert when data entered into an adjacent cell | Excel Worksheet Functions | |||
![Jane Griffel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
