Results 1 to 4 of 4

Thread: Automatic Subtraction Of Column Values To Adjacent Column

  1. #1
    Junior Member
    Join Date
    Jun 2012
    Posts
    15
    Rep Power
    0

    Exclamation Automatic Subtraction Of Column Values To Adjacent Column

    Dear Experts,

    i want Auto Subtraction between A1:A1000 - B1:B1000 Value apply to C1:C1000 in conditional formatting.
    find attachment.

    Regards,

    Sanjeevi.
    Attached Files Attached Files

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Can you elaborate that please? Are you saying you want to automatically have the column C have the difference of the values in columns A and B?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Jun 2012
    Posts
    15
    Rep Power
    0
    Yes that one..!

  4. #4
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Try this....

    Paste this in the sheet code module

    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    
        If Target.Cells(1).Column <= 2 Then
            With Me
                .Range("C2:C" & Application.Max(2, Me.Cells(Rows.Count, 3).End(xlUp).Row)).ClearContents
                .Range("C2:C" & Application.Max(.Cells(Rows.Count,  1).End(xlUp).Row, .Cells(Rows.Count, 3).End(xlUp).Row)).Formula =  "=A2-B2"
            End With
        End If
            
    End Sub
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 10
    Last Post: 05-23-2013, 12:30 PM
  2. Replies: 6
    Last Post: 05-22-2013, 02:23 AM
  3. Replies: 16
    Last Post: 04-19-2013, 08:20 PM
  4. Offset based on Values in Column E
    By mrmmickle1 in forum Excel Help
    Replies: 7
    Last Post: 12-04-2012, 10:06 AM
  5. Subtraction Of Series Of Cells' / Array Values
    By PcMax in forum Excel Help
    Replies: 6
    Last Post: 10-26-2012, 11:55 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •