VBA Code for looping through the worksheets and active next cell then run the same command

Hi, I need help to give a tweak of a code that a friend give (thank you very much for it).

Please Login or Register  to view this content.

What I need to make adjustments are:
after the code executed, move the selected cell to the end of the filled cells and run the code again through the worksheets inside the workbook (because the code only runs on the specified sheet only and I need to make it run through the entire worksheets inside the workbook).

Thank you!

Possibly...

Please Login or Register  to view this content.

thank you for the reply and it works like what I expected. But the problem within the code is that its also copying the header of the table. is there any fix for this? thanks so much

Hard to tell without seeing the workbook. Suggest you attach a sample workbook.

hope the screenshot can explain the problem

Attachment 764927

Your attachment isn't viewable.