Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type info in one cell that automatically repeats in other cells.
Hi,
I'm trying to format a spreadsheet in such a way that when I enter a data value into a given cell, for instance an ID #, it repeats that same ID # throughout the spreadsheet without me ever having to type it again. Basically, the document is 16 pages long, and the ID # is required on every page. There are other repeat values as well. It just occurred to me that maybe I could just make it a header, but with all of the different categories of information I have to add, and the number of spreadsheets I'm dealing with, that might get ridiculous. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type info in one cell that automatically repeats in other cells.
In Sheet1!A1 enter the relevant ID#.
Then, in all subsequent sheets in the workbook enter the formula =Sheet1!A1 where you want the ID# to appear. Repeat this process for any other values which you want to repeat throughout your workbook. Dave -- Brevity is the soul of wit. "L. Mo" wrote: Hi, I'm trying to format a spreadsheet in such a way that when I enter a data value into a given cell, for instance an ID #, it repeats that same ID # throughout the spreadsheet without me ever having to type it again. Basically, the document is 16 pages long, and the ID # is required on every page. There are other repeat values as well. It just occurred to me that maybe I could just make it a header, but with all of the different categories of information I have to add, and the number of spreadsheets I'm dealing with, that might get ridiculous. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type info in one cell that automatically repeats in other cell
I'm not into the whole brevity thing, man. Thanks for the info.
"Dave F" wrote: In Sheet1!A1 enter the relevant ID#. Then, in all subsequent sheets in the workbook enter the formula =Sheet1!A1 where you want the ID# to appear. Repeat this process for any other values which you want to repeat throughout your workbook. Dave -- Brevity is the soul of wit. "L. Mo" wrote: Hi, I'm trying to format a spreadsheet in such a way that when I enter a data value into a given cell, for instance an ID #, it repeats that same ID # throughout the spreadsheet without me ever having to type it again. Basically, the document is 16 pages long, and the ID # is required on every page. There are other repeat values as well. It just occurred to me that maybe I could just make it a header, but with all of the different categories of information I have to add, and the number of spreadsheets I'm dealing with, that might get ridiculous. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - I type 9-6 in cell and it automatically changes to 9 June | New Users to Excel | |||
How do I total range of cells that have checks in checkboxes? | Excel Discussion (Misc queries) | |||
Automatically update cells | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
copying content of cell automatically to multiple cells | Excel Worksheet Functions |