I have a Excel spreadsheet with 10 columns and 900 lines.

I wrote a macro to take information off of line 2 on worksheet #1 and place
it in a form on worksheet #2


How do I get the macro to run on different lines say line 4 and then line
498 and then 987. (The macro is written for line #2)

The form on sheet #2 is the same. Do I need to write this same macro for
each line? Is there a way to run a macro on a highlighted area? Can I put
a button at the end of each line?

Any help will be appreciated.