+ Reply to Thread
Results 1 to 8 of 8

Auto Fill from other columns and using IF with related to blank or Zero cells

  1. #1
    Registered User
    Join Date
    07-08-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    17

    Auto Fill from other columns and using IF with related to blank or Zero cells

    Hello Team,

    Could you please help with what i am trying to do here. In the attachment if you see, i have 3 sections.

    1) I want the section 2 column I to be auto filled based on that data i feed in section 1 columns C, D, E.
    2) In section 3, If you see P8 formula, I derived it based on L:M values because both Item1 and item2 has value. Here is that possible that when Item A column has some value and Item1 and Item2 are blank or Zero then the Final result should show product of Item A and default value in M8?

    Thank you in advance for your efforts.
    Attached Files Attached Files

  2. #2
    Forum Contributor Bhuvi's Avatar
    Join Date
    04-19-2013
    Location
    Delhi, India
    MS-Off Ver
    MS Excel 2003,07,10
    Posts
    153

    Re: Auto Fill from other columns and using IF with related to blank or Zero cells

    Hi Psionicrnd,

    In your sheet paste the below formula in cell P4 and drag it down, note: Item 1 & 2 should be blank and not zero 0.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If this helped and you wish to say thanks, then Please click on the Star* icon below this post.

  3. #3
    Registered User
    Join Date
    07-08-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    17

    Re: Auto Fill from other columns and using IF with related to blank or Zero cells

    Thank you Bhuvi...thats answers my second question...well that works with blank cells, how about cells with zero? is it possible too?
    Any lights on my first question above?

  4. #4
    Forum Contributor Bhuvi's Avatar
    Join Date
    04-19-2013
    Location
    Delhi, India
    MS-Off Ver
    MS Excel 2003,07,10
    Posts
    153

    Re: Auto Fill from other columns and using IF with related to blank or Zero cells

    Hi Psionicrnd,

    For your second question another condition added to the previous formula, see below:

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    For your first question see the attached sheet ,I hope this is what you want. If not then please elaborate your question giving examples and scenarios.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-08-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    17

    Re: Auto Fill from other columns and using IF with related to blank or Zero cells

    Thank you so much....that really answered all my questions here will come up with some other new questions...thanx again

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Auto Fill from other columns and using IF with related to blank or Zero cells

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  7. #7
    Registered User
    Join Date
    07-08-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    17

    Re: Auto Fill from other columns and using IF with related to blank or Zero cells

    Sorry for re-opening this thread again. Well i just noticed the solution provided Bhuvi with related to my 1st question has slight mistake.
    The use of transpose is only limited to switch rows to columns or columns to rows without based on dates and the specific column. I am trying to auto fill data when entered in A:E that should auto filled under "I" column based on dates and shifts. Can you please help me with this? because the data will grow on A:E columns.

  8. #8
    Registered User
    Join Date
    07-08-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    17

    Re: Auto Fill from other columns and using IF with related to blank or Zero cells

    Closing this thread as i got my answer...ty all

+ 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. Auto fill worksheet cells based on certain criteria w/out leaving blank rows.
    By Txprospector in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-10-2014, 07:35 AM
  2. [SOLVED] Auto Fill Blank Cells - Using Differing "Start" Numbers
    By HowD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2013, 01:05 PM
  3. Auto fill blank cells with data in a cell above
    By StudentMod in forum Excel General
    Replies: 4
    Last Post: 05-09-2008, 04:37 PM
  4. [SOLVED] blank cells with auto fill in excel
    By derecl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-02-2005, 06:20 PM
  5. Auto Fill blank cells
    By maddz in forum Excel General
    Replies: 0
    Last Post: 02-01-2005, 05:49 AM

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