Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 17th 05, 11:20 PM
sans
 
Posts: n/a
Default Auto-fill cell based on adjacent cell information..

I've got a column where I insert a contact like NOC-EDS and NOC-WAC. Is it
possible to have the cell adjacent to that column auto-fill those phone
numbers? Or will I need a macro?

Thanks,
Ryan

  #2   Report Post  
Old October 17th 05, 11:38 PM
Anne Troy
 
Posts: n/a
Default Auto-fill cell based on adjacent cell information..

Ryan, you probably just need a lookup. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"sans" wrote in message
...
I've got a column where I insert a contact like NOC-EDS and NOC-WAC. Is it
possible to have the cell adjacent to that column auto-fill those phone
numbers? Or will I need a macro?

Thanks,
Ryan





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Cell Shading (based on the shading of other cells) Tubby Excel Worksheet Functions 2 June 20th 06 10:03 PM
SQL - Auto Refresh Upon Cell Value Change Elliot J Excel Worksheet Functions 1 May 12th 05 10:22 AM
changing value of a cell based on another cell color Gary Excel Discussion (Misc queries) 2 January 30th 05 11:19 AM
Can you conditional format based on information in cell comments? Jflyer Excel Worksheet Functions 1 January 15th 05 02:52 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017