Tab Name as column Name

[swathidas]

Hi All,

I have some Excel sheets in E:\DLB folder, for some Excel files there are two worksheets for some three worksheets and for some four worksheets. The number of worksheets are not fixed. I want to insert the worksheet name as column data for all the worksheets present.

Please suggest me a logic, how can I do this.

Thanks,
Swathi

[arlu1201]

In which column should the sheet name be copied? All cells or just one particular cell of the column?

[swathidas]

The sheet name should be copied to column M for all rows.

Thanks,
Swathi

[arlu1201]

Ok, i will have something for you shortly.

[arlu1201]

Use this code -

Please Login or Register  to view this content.

[arlu1201]

Got posted twice so removed the code.