Recorded macro doesn't seem to provide expected result

Hi you all,

Normally I keep trying until I find what's wrong but this time I could use some help.

On column A, I simply do an A-Z sort that gives the expected result. So I recorded it as a macro.
In column G is a code that corresponds with column A. When the marcro is executed Column A is sorted but the corresponding value in G stays where it is.
Clicking the A-Z button works. But when that action is recorded as a macro I get the above quirck.

Since VBA is not my beef, I don't really know what wrong...

cheers,


edit; Doh, Monday morning; This should go into the excel section.

[MOD EDIT - moved]

Jeroen