Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: How to show if the figures have gone up or down

    Im wondering if you guys can help.

    I need to indicate if the figures for this week has gone up or down compared to last weeks figures.

    So looking at the attached, I need to add a column (I5) to sheet Admitted Patients WE 20081005, so it compares the % treated in <18 wks figure by specialty to previous weeks figures on sheet Admitted Patients WE 20080921.

    Ideally I would love an arrow either point up if the figures has increased or down if they have reduced.

    Im open to suggestions.


    Thanks in advance
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2007
    Posts
    127
    any help guys

  3. #3
    Join Date
    Dec 2007
    Posts
    37

    Hope this helps u

    put a macro with this
    Note : for sample i have compared B & c columns in same sheet


    Sub tst()

    For Each opic In Me.Pictures
    opic.Delete
    Next

    For i = 6 To 28
    Cells(i, 8).Activate
    If Cells(i, 2) > Cells(i, 3) Then
    ActiveSheet.Pictures.Insert ("C:\up.bmp")
    Else

    ActiveSheet.Pictures.Insert ("C:\down.bmp")
    End If

    Next

    End Sub
    Meyyappan

  4. #4
    Join Date
    Oct 2007
    Posts
    127
    SOLVED - thanks for all your help again :-)

Posting Permissions

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