Searchin for a vba line to Put data in ...

[poetbil]

I need to put range A9:E9 in A1 causing last line (A5:E5)
to say Bye Bye,leaving its place to the new data set
I did it with a macro ,but it makes formulas in dependent cells to produce #errors
Can I get some help ,thanks for your kindness

[IMG
][/IMG]

 

[FormR]

Hi, something like this maybe?

Sub m()
Range("A2:E5").Value = Range("A1:E4").Value
Range("A1:E1").Value = Range("A9:E9").Value
End Sub

 

[poetbil]

so beautifully simple ,Thanks
Very much FormR