Excel Macro: Last Row Failed to Capture

Hi Excel Gurus,

I have a report in a workbook that contains multiple worksheets and I want these data be copied on a "Summary" sheet. However, the last row of the data of each worksheets did not captured when I tried running the macro I have.

I appreciate if there could be someone that could help me check and correct the missing code per attached sample workbook. Let me know if you need additional details or clarifications. Thank you!


Warmest regards,
Arnel

Hi bakerman2,

Thanks for taking time answering my query.

I tried incorporating the codes that you've provided but it looks like it did not hit the target data I wanted.

On the attached workbook, I have highlighted (in yellow) the data in each worksheets after the "Summary" sheet that I want to be consolidated after clicking the "Generate" button.

I appreciate if you could please revisit the existing VBA code that I have and correct what's the missing pieces. Thank you so much!

Warmest regards,
Arnel

Hi bakerman2,

It works perfect!

Thank you for your immediate feedback and for sharing your expertise. Much appreciated!

Warmest regards,
Arnel