vba help

[Roadhouse]

Hi could anyone help me I have a workbook (there are about 500 sheets) and in every sheet in that book there is data in F5:F10000 I want to do this sum F6-F5,F7-F6,F8-F7 etc all the way down and if the answer is greater or = to 3 I want to highlight that row and put the differences in D1, E1 etc for e.g if there were 3 answers => 3 then these 3 answers would go in D1,E1,F1 etc and the 3 rows would be highlighted. Can anyone help me with some vba code for this please?

[rourkem]

+1. I'd also like to know please if this can be done.

[NorthView]

You don't need VBA for this.: simple formulae and conditional formatting will do it. Some of the Excel forums will show you how to do it.

[Roadhouse]

Hi thanks for the replies, I don't think I've explained myself very well I don't want to input the sum down the column I would like the vba to just calculate the value in memory for F6-f5 , F7-F6, F8-F7 etc for F5:F10000 on all 500 sheets in the workbook and the rows where there is a difference equal or greater then 3 it would highlight these rows and put the difference at the top of the sheet. so for e.g. it found two values greater then 3 in F6-F5 which was 4 and say F23-F22 which was 5. These rows would highlighted and the differences 4 and 5 would be put in D1 and E1 and if there was more values greater then 3 say four values these then would go in D1/E1/F1/G1 and the rows would be highlighted.

[MiniBlueDragon]

For something this in depth I'd use the "Find an Excel developer" forum.

[brumbie]

No offence mate but as this problem has nothing to do with gruss or betting why don't you just go to an excel board with the problem?...