My Documents > My Games > FINAL FANTASY XIV > user > (find folder with the newest date [NOT the 00000000 folder, one of the others]) > macr0

You can also copy the 'ui' and 'game' files. I usually copy all three of these because some of the patch updates cause your macros to disappear, UI and in-game settings to return to default state. It's nice to not have to re configure chat logs, keyboard settings etc, etc every time theres a patch.

Hope this helps!