Creating a heat map to run with one click

Hi, So basically i have to create a macro for work that takes information from one spreadsheet and then reconfigures it and places it on a map. I have written most of it and have it running so that you have to select each row individually. I want to make it so that it can be run by pressing a button and it runs through all the rows and adds the information, but I'm having trouble getting to to select the next line once its added the first line and the getting it to stop at the last line. Thanks, Luke