Macro to Copy/Paste Data down to where data in another column ends

Hello, I am new with VBA/Macros and have been trying to figure this out for the past two days. It appears others have had the same question but I have not, for the life of me, figured out how to accomplish it based on the different posts. I need to copy the data in columns A through G and paste down. I need the paste to end when the data ends in Column I. Column H does not have any data, but it needs to remain. I want to apologize for not being able to figure it out from the other posts. Thank you in advance.

Please Login or Register  to view this content.

Thanks,
Matt

Thomas,

Thank you! Worked perfectly.

Matt