Are there any Microsoft Excel gurus out there?

[Ryan Thomas]

I need a little help building a quick and easy macro, and im having a tough time (im no programmer). Basically it works like this:

Sheet 1 is a list of 10,000 property addresses and other info.
Sheet 2 is a template .enex file i exported from evernote.

What I want to do is create a macro that copies the template into sheet 3, then auto populates the info from each row of sheet 1 into a row on sheet 3 with the pre created template.

This way I can make my 10,000 properties individual notes to be uploaded into evernote.

I can pretty much create the macro to do one template, but I dont understand how to look it and make it go through the entire list from sheet 1.

Any help would be greatly appreciated.