I have only 2003 and will help a friend of mine. He has only 2007. When I
write a simple macro in 2003, it will not work in 2007

What format should I save the file

( the macro is simple as Copy one row of data and paste it in another sheet)

Hope these genuine group will find a solution.