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) |
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 |
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 |
All times are GMT +1. The time now is 08:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com