Results 1 to 4 of 4

how to make live update of cells?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-14-2010
    Location
    Toronto,Canada
    MS-Off Ver
    Excel 2003
    Posts
    145

    how to make live update of cells?

    Hi,
    Sorry if the title is misleading, i am not good at making titles

    Problem: I have a data validation list in couple cells and would like the index of the item in that list displayed in the cell right beside it using =MATCH(H12,CableList,0).
    Note: CableList is the array to look for the H12 value.
    Right now, I have to go to that cell, and run that formula again.
    I would like to make it so that the index changes as soon as a new item is selected.

    I had it the way i wanted a week ago, but it seems i messed up something.
    Could anyone please help me solve this problem?

    Thanks
    Last edited by adds007; 06-28-2010 at 01:51 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1