Results 1 to 4 of 4

Using If's and Elses to fill multiple cells

Threaded View

  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?

        If Range("at9") = "" Then
        ActiveSheet.Range("at9") = Worksheets("Mud Reports").Range("o1")
        Else
        If ActiveSheet.Range("bc9") = "" Then
        If Worksheets("Mud Reports").Range("o1") <> ActiveSheet.Range("at9") Then
        If Worksheets("Mud Reports").Range("o1") <> ActiveSheet.Range("at10") Then
        If Worksheets("Mud Reports").Range("o1") <> ActiveSheet.Range("bc10") Then
        ActiveSheet.Range("bC9") = Worksheets("Mud Reports").Range("o1")
        Else
        If ActiveSheet.Range("at10") = "" Then
        If Worksheets("Mud Reports").Range("o1") <> ActiveSheet.Range("at9") Then
        If Worksheets("Mud Reports").Range("o1") <> ActiveSheet.Range("bc9") Then
        If Worksheets("Mud Reports").Range("o1") <> ActiveSheet.Range("bc10") Then
        ActiveSheet.Range("at10") = Worksheets("Mud Reports").Range("o1")
        Else
        If ActiveSheet.Range("bc10") = "" Then
        If Worksheets("Mud Reports").Range("o1") <> ActiveSheet.Range("at9") Then
        If Worksheets("Mud Reports").Range("o1") <> ActiveSheet.Range("bc9") Then
        If Worksheets("Mud Reports").Range("o1") <> ActiveSheet.Range("at10") Then
        ActiveSheet.Range("bc10") = Worksheets("Mud Reports").Range("o1")
        End If
        End If
        End If
        End If
        End If
        End If
        End If
        End If
        End If
        End If
        End If
        End If
        End If
    Last edited by kingkyle2005; 11-26-2013 at 02:54 PM.

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