copying information
When working on a list of names in column A Excell will automatically pap the
name up if I start to enter it again on a different line, but how do I get excel to also copy the information for that person in cells in column B & C? example: A B C Name ID# Phone# smith, jo 231 9999999 If I type smith, jo again on the list only smith, jo appears I need for the other to colums to also appear. -- Thank you for your help, Taz |
copying information
Use VLOOKUP
-- Gary''s Student "Taz" wrote: When working on a list of names in column A Excell will automatically pap the name up if I start to enter it again on a different line, but how do I get excel to also copy the information for that person in cells in column B & C? example: A B C Name ID# Phone# smith, jo 231 9999999 If I type smith, jo again on the list only smith, jo appears I need for the other to colums to also appear. -- Thank you for your help, Taz |
All times are GMT +1. The time now is 07:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com