+ Reply to Thread
Results 1 to 5 of 5

Auto fill cells based if there is something there or not

  1. #1
    Registered User
    Join Date
    06-05-2013
    Location
    USA
    MS-Off Ver
    2010
    Posts
    22

    Auto fill cells based if there is something there or not

    So i have been messing around with this spread sheet but i can not figure out a way to use the customer name to auto fill my cells based if there is price there or not. I have attached an example of what i am talking about below.


    Sample.xlsx

  2. #2
    Registered User
    Join Date
    08-26-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    58

    Re: Auto fill cells based if there is something there or not

    see the attached. I have added some helper column to implement the formula. you may hide them
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: Auto fill cells based if there is something there or not

    Hi,

    Attached is a modified workbork from your attached file. This should do what you require and I have tried to explain each bit on the file itself instead of on the post so that it should be clearer as to how things work.

    If you need any futher help on what I've done let me know.
    Attached Files Attached Files
    Say thanks, click *

  4. #4
    Spammer
    Join Date
    02-04-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2013
    Posts
    190

    Re: Auto fill cells based if there is something there or not

    my contribution to a solution
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-05-2013
    Location
    USA
    MS-Off Ver
    2010
    Posts
    22

    Re: Auto fill cells based if there is something there or not

    Thanks guys this is perfect all suggestions work thank you thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to auto fill in cells based on value on different cells
    By juskojj in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-11-2013, 01:35 PM
  2. Auto fill cells based on a date range given
    By timmy1254 in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 11:12 PM
  3. Auto fill cells based on the data in another cell
    By excelnewman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-08-2011, 01:29 AM
  4. auto fill cells based on value entered in first cell?
    By Synthia in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-29-2010, 08:27 AM
  5. Replies: 3
    Last Post: 01-26-2007, 06:37 PM

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