VBA code to move data up one row

[Grahamfeeley]

Hi Experts, please help with my problem
I need to ask for a row number
from that row number copy down from A:E data
move that up one row
I have formulas in columns F:K, so I hope that code wont affect the formulas

Hope you can help
Graham

[Mumps1]

Maybe:

Please Login or Register  to view this content.

[davesexcel]

Can you delete the row at the top?

[Grahamfeeley]

No top 2 rows are headers

and i can only replace columns from A:E

Thanks

[Grahamfeeley]

Thank Mumps for the help, however that code throws out my formulas that are in columns G:K

I really need to copy data over the row above and than i can delete bottom row entirely
or else tell me how not to interfere with the formulas
thanks a lot
Graham

[Grahamfeeley]

Thanks Mumps1, I got it working fine and appreciate all your help

Very happy
Graham

[Mumps1]

Glad to help.