Hello All

I am pretty new to XL but need a little bit of help.

I have 10 lines of data in column A
In column B, are numbers 1 to 10
If I remove line 5, I want all the numbers in column B to recalculate to show only 9 lines of data.

At the moment, the figures in Column B are hand typed in but I suppose to make it calculate, a formula must be written...

Trust this makes sense ?

Thanks