Macro Question noob: Rearrange data

[Life-is-good]

Hey there,

I have a huge data set that needs to be rearranged. I believe recording a macro for this would be most appropriate and easy, problem is that I have no experience with macro whatsoever.

My Data looks like this:

-- removed inline image ---


and so on...always same layout.

What I have to do is to basically quite simple. From e.g. Lot 517 I have to go down one row -> cut -> paste in "G421" (or "one up, 6 to the right).
Next step is to rearrange number of bottles: e.g. cut "A423" -> paste in "L421".
Next would be to fill in "price local": e.g. cut "A430" -> paste in "J421". Then same for USD: e.g. cut "A431" -> paste in "K421".

Last step would be to delete rows 422 - 431 which would leave me with with the same picture as above just one row further.

In the end it should look like this:

-- removed inline image ---


Now I have to do this for like 200days each around 500 "lots".

Can I set something like: repeat action above for a specific amount of times e.g. 423 times the above cut - paste - delete rows action?

I would highly appreciate your help

Regards

 

[Life-is-good]

pictures werent uploaded so they are on

http://www.dropbox.com/gallery/18518557/1/Excel?h=f4980d

oh and one thing i forgot is to cut and paste "Vintage". In that example above: "C422" to "I421"