Macro loop

Hello, i have a macro that takes information from one tab to another that i found, and at the moment it only does it for one row. what and where do i add to it to make it do until end of table, sometimes there will be blank information (no information on other tab), or after every 15 or 17 rows (so can rewrite as needed) will be a total column, so it needs to skip these if able, but not too big of a deal. My excel macro skills are non existent at this time. macro is follows. thank you. so any and all help will be appreciated.

Please Login or Register  to view this content.

Hello jstuffle,

Welcome to the Forum.

Please read the Forum rules.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Regards.