+ Reply to Thread
Results 1 to 3 of 3

Compare and copy

  1. #1
    AJM1949
    Guest

    Compare and copy

    Hello everyone
    I have an excel price list where i need to compare the active cell with the
    one immediately below and then if they are equal copy the 4 columns adjacent
    to the active cell into the row immediatley below. If they are not equal then
    do nothing. I hope the figures below help explain my needs.

    $4,789,00 123.09 65.00 45.00 76.00 12.00
    $4789.00

    Many Thanks in advance
    --
    AJM1949

  2. #2
    Sridhar
    Guest

    RE: Compare and copy

    Hi, with the help of a functions it is not possible you need to create your
    own function.

    "AJM1949" wrote:

    > Hello everyone
    > I have an excel price list where i need to compare the active cell with the
    > one immediately below and then if they are equal copy the 4 columns adjacent
    > to the active cell into the row immediatley below. If they are not equal then
    > do nothing. I hope the figures below help explain my needs.
    >
    > $4,789,00 123.09 65.00 45.00 76.00 12.00
    > $4789.00
    >
    > Many Thanks in advance
    > --
    > AJM1949


  3. #3
    Ardus Petus
    Guest

    Re: Compare and copy

    Paste following macro into a Module

    Sub FillIt()
    Dim rng As Range
    With ActiveCell
    If .Value = .Offset(1, 0).Value Then
    Set rng = .Offset(0, 1).Resize(1, 4)
    rng.Offset(1, 0).Value = rng.Value
    End If
    End With
    End Sub

    HTH
    --
    AP

    "AJM1949" <AJM1949@discussions.microsoft.com> a écrit dans le message de
    news:B9646236-9835-4A91-B77B-F0587C0779D9@microsoft.com...
    > Hello everyone
    > I have an excel price list where i need to compare the active cell with

    the
    > one immediately below and then if they are equal copy the 4 columns

    adjacent
    > to the active cell into the row immediatley below. If they are not equal

    then
    > do nothing. I hope the figures below help explain my needs.
    >
    > $4,789,00 123.09 65.00 45.00 76.00 12.00
    > $4789.00
    >
    > Many Thanks in advance
    > --
    > AJM1949




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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