+ Reply to Thread
Results 1 to 3 of 3

Change cell values based on other cells.

  1. #1
    Registered User
    Join Date
    02-03-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Change cell values based on other cells.

    Hi,

    Try this...

    There are some valid datas in the cells A2 (Eg. 100), B2(Eg. 200), C2 and D2.
    Data validation is used in cell K2 to limit it to a set of values.

    Can we implement this formula?

    IF(K2="Approved")
    {
    A2=A3; B2=B3; C2=C3; D2=D3; K2=K3;
    }
    ELSE
    {
    no change to any values.
    }

    Thanks in advance...

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Win 2010-2016
    Posts
    11,127

    Re: Change cell values based on other cells.

    Hello,

    are the values in A2, B2, C2 and D2 entered manually?

    If so, you can not change them with a formula. You will need VBA to do that.

    Are you open to a VBA solution?

    It would help immensely if you could post a sample Excel file with some data that reflects your needs. Click "Go Advanced" below and then the paper clip icon to attach a file.

    cheers,

  3. #3
    Registered User
    Join Date
    02-03-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Change cell values based on other cells.

    Yes.. The values in A2, B2, C2 and D2 are entered manually...

    VBA is ok with me.. but i am new to it.. i have attached my requirement ....
    Attached Files Attached Files
    Last edited by a.velganesh; 02-03-2011 at 06:58 AM.

+ 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