+ Reply to Thread
Results 1 to 2 of 2

Automatically updating adjacent cells based on drop-down list selection even if you change

  1. #1
    Registered User
    Join Date
    03-10-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    6

    Automatically updating adjacent cells based on drop-down list selection even if you change

    Hi All,

    I'm having an issue. I have a workbook that has two worksheets. One worksheet is an input worksheet. A user will select a date from a drop-down list and type in the events that occurred on that date in 8 adjacent cells. The user selects a button that advances date and clears form. On sheet 2, whatever was typed into sheet one is saved via VLOOKUP formula. However, if I try to change something retroactively and select a previous date from the drop-down list, it clears everything in sheet 2 that was typed for any selected day.

    Does anyone know what could be causing that?

  2. #2
    Forum Contributor
    Join Date
    03-12-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2007
    Posts
    230

    Re: Automatically updating adjacent cells based on drop-down list selection even if you ch

    A VLOOKUP formula does not save what is in the cell. It is constantly referencing data, so if you change the data it is looking up, the other data will change too.

+ Reply to Thread

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