Creating a Macro Loop to copy & paste several lines

My question is one is this possible with a macro?
Second, if so, how?

1. Copy one row from Data sheet.
2. Paste into Master sheet. (it will generate a solution)
3. Copy the solution from Master sheet & paste the values on the Answer sheet.
4. Repeat for every row of data in Data sheet.

I hope this modified version starts you in the right direction

Please Login or Register  to view this content.

to speed up the macro, add

Please Login or Register  to view this content.

right after the Sub Test line and then add

Please Login or Register  to view this content.

right before the End Sub line