Hi All

I'm not sure if what I have in mind is possible but any help or advise is appreciate it.

I have a spreadsheet which contains sales figures for each week on separate worksheets, i.e. the figures (which are ranked) for week one is in WS1 and for week 2 in WS2 etc for each division (there are twenty of them)

What I need to do is form a weekly league chart for sales within each division.

I have set the worksheets correctly but what I am required to do is to put up or down arrows in the cell using the following criteria
as an example in week 2 I have WS2 which contains sales figures for week 2. what I need to do now is to look at the rankings in WS1 for week 1 and insert an arrow in week 2 for the same division, so that if the sales for that division has increased compare to previous week then it will show a green arrow and if its down it shows the red downward arrow. then for week 3 it then needs to look at the figures in WS2 and see whether in week three they have improved or not.

At the moment I am doing this manually as the figures change every week against the previous one I.e. there is no set target but just a comparison to performance against its previous week for the same. The name of the worksheets are WS1 , WS2 .....

Is there a way I can automate this as it is currently time consuming doing it manually. I need to get he logic sorted out and then need help with the formula or even a VB code to do this

any help is appreciate it