VBA to add Worksheet Name after the last column of a Table

Hi all,

I have a folder which contains several Excel workbooks. Each Workbook has got only 1 Worksheet with a specific name and each Worksheet contains a single Table (number of columns of that Table are not the same for each Worksheet).

Is it possible to run some VBA codes that would automatically run on that folder and create a new column (say, WorksheetName) at the end of the Tables and fill its relevant rows with its Worksheet Name?

Any help would be much appreciated.


Attachment (sample Worksheet):

https://www.excelforum.com/attachmen...1&d=1651947172

Yes it is...Pls upload a sample file depicting actual setup of said workbooks...You say Table...Is it an actual Table(ListObject) or Range...

Change red snippet to path housing files...

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Glad I could assist...Tx for Rep +