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.

I’m open to suggestions.


Thanks in advance

any help guys

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

SOLVED - thanks for all your help again :-)