+ Reply to Thread
Results 1 to 4 of 4

Using If's and Elses to fill multiple cells

  1. #1
    Registered User
    Join Date
    10-07-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Using If's and Elses to fill multiple cells

    I am having troubles getting the third and 4th cells in this section to fill properly. I am pulling data from one specific cell on a separate sheet (O1), and attempting to fill one cell at a time, only if (O1) is not the same as a previous listing.


    The first and second operation will work, no matter which of the If/ Else bunches that I ask it to fill. However the 3rd and 4th changes will not fill the 3rd and 4th cell. Any ideas?

    Please Login or Register  to view this content.
    Last edited by kingkyle2005; 11-26-2013 at 02:54 PM.

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Using If's and Elses to fill multiple cells

    Hello,

    If I understood correctly... this maybe ???

    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Registered User
    Join Date
    10-07-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Using If's and Elses to fill multiple cells

    Got it figured. Required a different placement of my End If's

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    10-07-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Using If's and Elses to fill multiple cells

    Not sure why, but this one didn't work for me. Got it solved now, even if it looks ugly.

+ 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] Fill Prompt Value in Multiple Cells
    By FallingDown in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2013, 02:33 PM
  2. Replies: 1
    Last Post: 06-30-2012, 01:54 AM
  3. Replies: 3
    Last Post: 05-05-2012, 11:43 AM
  4. Excel 2007 : How to get fill to span across multiple cells
    By Darkmatter in forum Excel General
    Replies: 1
    Last Post: 07-23-2009, 05:16 PM
  5. fill down multiple cells in the same column
    By Jerome in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2006, 09:30 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