+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Auto fill non adjacent cells +

  1. #1
    Registered User
    Join Date
    09-01-2009
    Location
    Cleator
    MS-Off Ver
    Excel 2007
    Posts
    11

    Auto fill non adjacent cells +

    My apologies to all but I cannot solve the following procedure myself.
    How can I auto fill two additional cells when I do the following.

    I manually input into cell A3 the words 'sheep feed 1' I then manually input in cell D3 '7.50' how do I set up an auto procedure to fill cells F3 and H3 with the amount I manually inputted into cell D3 (7.50)
    AND secondly can the above happen immediately the next time I manually input 'sheep feed 1' into (example) cell A9 (I.E cells D9, F9 and H9 to be auto filled with 7.50)

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Auto fill non adjacent cells +

    Hi quintain,

    Use the below formula in D, F and H columns :-

    =IF($A$3="Sheep feed 1", 7.5,"")

    autofill non adjacent cells.xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ 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