| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Type details into one cell and they copy into another
I have a list of school in two different orders but require to have the same
information listed next to them. Rather than type the information out twice, how do I set up Excel to copy the text as I write it into the same to schools on different sheets and on different lines? Hope ya can help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Type details into one cell and they copy into another
VLOOKUP function comes to mind
Set up 1 worksheet as your master list eg sheet 1 Name the data eg MasterTable Ensure that the school name is in the 1st column then in the cells where you need the data use =VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup) HTH "slavenp" wrote: I have a list of school in two different orders but require to have the same information listed next to them. Rather than type the information out twice, how do I set up Excel to copy the text as I write it into the same to schools on different sheets and on different lines? Hope ya can help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Type details into one cell and they copy into another
Steve, thanks for this post. Unfortunately it doesn't seem to work. May I
be doing something incorrect or is there another way to achieve what I require? Ta. "steve_doc" wrote: VLOOKUP function comes to mind Set up 1 worksheet as your master list eg sheet 1 Name the data eg MasterTable Ensure that the school name is in the 1st column then in the cells where you need the data use =VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup) HTH "slavenp" wrote: I have a list of school in two different orders but require to have the same information listed next to them. Rather than type the information out twice, how do I set up Excel to copy the text as I write it into the same to schools on different sheets and on different lines? Hope ya can help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for copy pasting details from main sheet | Excel Discussion (Misc queries) | |||
| Copy row details where cell value meets certain criteria | Excel Worksheet Functions | |||
| How do I copy subtotaled data without the underlying details? | Excel Worksheet Functions | |||
| Can I get excel to auto save details from a cell into the doc nam. | Excel Worksheet Functions | |||
| Automatic transfer of cell details | New Users to Excel | |||
Linear Mode
