Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring data between sheets
Not sure if this is possible or how simple it is (for someone not so clued up
on Excel). My boss uses a lot of worksheets and has to enter a lot of things numerous times on different sheets (Company Names, Account Numbers, Rep codes etc etc). He has asked if it is possible to create some kind of programme or function that would mean if he created one main sheet with all the details on, that on other worksheets he could just enter the company name it would bring up the rest of the details? (sorry if that doesn't make much sense) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring data between sheets
Maybe you could retrieve the other data by using =vlookup() or =index(match()).
Debra Dalgleish has lots of notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) and http://contextures.com/xlFunctions02.html#Trouble suzi_wells wrote: Not sure if this is possible or how simple it is (for someone not so clued up on Excel). My boss uses a lot of worksheets and has to enter a lot of things numerous times on different sheets (Company Names, Account Numbers, Rep codes etc etc). He has asked if it is possible to create some kind of programme or function that would mean if he created one main sheet with all the details on, that on other worksheets he could just enter the company name it would bring up the rest of the details? (sorry if that doesn't make much sense) -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring data between sheets
Thanks Dave, I will have a look and give them a try!
"Dave Peterson" wrote: Maybe you could retrieve the other data by using =vlookup() or =index(match()). Debra Dalgleish has lots of notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) and http://contextures.com/xlFunctions02.html#Trouble suzi_wells wrote: Not sure if this is possible or how simple it is (for someone not so clued up on Excel). My boss uses a lot of worksheets and has to enter a lot of things numerous times on different sheets (Company Names, Account Numbers, Rep codes etc etc). He has asked if it is possible to create some kind of programme or function that would mean if he created one main sheet with all the details on, that on other worksheets he could just enter the company name it would bring up the rest of the details? (sorry if that doesn't make much sense) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring data from multiple sheets in workbook to one sheet | Excel Discussion (Misc queries) | |||
Transferring data from multiple sheets in workbook to one sheet | Excel Discussion (Misc queries) | |||
transferring data between sheets | Excel Worksheet Functions | |||
Transferring data to other sheets | Excel Discussion (Misc queries) | |||
Transferring Data Between Sheets | Excel Discussion (Misc queries) |