See Repeating Data (Populating Multiple Like Fields).
There are a lot of ways of doing what you want and few require macros. The article is long because there are a lot of ways. I urge you to read through it.