Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Here's and example of what I'm trying to do
Say I have a book by the name.... 'Eating Apples' is cell A1, and next to it i type the numbers '1234' in cell B1. Right, what I'm trying to do is that if I type the number 1234 is any cell in any sheet hereafter, the Title 'Eating Apples' would pop up, replacing the numbers 1234. Basically what I'm trying to do is linking the numbers '1234' to 'Eating Apples', so that if someone wanted to type down 'Eating Apples' in any other cell, they dont have to do that, instead they just have to type '1234' and the title 'Eating Apples' would replace those digits. Does this make sense? Is this possible on Excel? Thanks for any help guys :) |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() One way. .....Tools/Auto Correct....replace: 1234 with: Eating Apples HTH Jean-Guy -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=514584 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks pinmaster
However, if I have several data the would need to be replaced. Would there be any other way of performing this? cheers vin "pinmaster" wrote: One way. .....Tools/Auto Correct....replace: 1234 with: Eating Apples HTH Jean-Guy -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=514584 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Also, if i use auto correct, am i right in assuming that it will be recorded
only in my PC. Will the changes in my autocorrect apply if someone else opens up this sheet on their PC? Thanks "Vin81" wrote: Thanks pinmaster However, if I have several data the would need to be replaced. Would there be any other way of performing this? cheers vin "pinmaster" wrote: One way. .....Tools/Auto Correct....replace: 1234 with: Eating Apples HTH Jean-Guy -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=514584 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() If you are trying to save them time then you might try using validation. You can allow them to choose from a list. You can vlookup the values to carry them to any of the other sheets. You can also have a cell that they enter a # and then the cell next to it could be a vlookup that brings over the corresponding value. -- Kevin Ward ------------------------------------------------------------------------ Kevin Ward's Profile: http://www.excelforum.com/member.php...o&userid=31417 View this thread: http://www.excelforum.com/showthread...hreadid=514584 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
Linking 2 Excel Sheets, Anticipating Lines. | Excel Worksheet Functions | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |