Copy/Paste Loop Macro

I am trying to create a macro to copy data from one sheet to another. The first sheet has data that has been entered and the second sheet is used organize the data so it can be used to make calculations and graphs from the data. The problem that I am having now is being able to loop through all of the lines of the entered data in order to copy it to the second sheet from which the data is used.
The data in "Enter Data" is in entries of 9 rows by 27 columns (A2:AA10) and the converted code ("Hr-by-Hr Chart Data") is 30 rows by 20+ columns. I am using column B, first row of each data entry in Enter Data, and column A, first empty row in Converted Data, as the baseline boxes from which ranges are selected relative to because there will always be data for the cells in those columns, while there may or may not be data in most of the rest... if that all makes sense.
Here is the declaring and looping parts of my code:

Please Login or Register  to view this content.

I have only been working with excel for a few weeks so I am still trying to learn the code and how to do relatively simple things like using variables correctly and looping correctly, so please let me know if I am doing anything that I really shouldn't do or if there is a better way to do it.

That is very good. I was not sure what would be the best way to set up the loop.
Just out of curiosity, why would you choose to use a 'for' loop instead of a 'do until isempty' loop?

You're welcome.

Originally Posted by danderson2692

...why would you choose to use a 'for' loop instead of a 'do until isempty' loop?

No major reason. Personal preference I guess. A For\Next loop does allow for a Step size in the one line of code.

Your original code was pretty good. The actual "Loop" wasn't much of an issue. Most improvements in the new code were in how Sheets and Ranges wre referenced.

Ok. Thanks for the help!