Create a column per record containing the file and tab names

[Bigmonki]

Hi,

I have a single workbook with multiple tabs and I want to add the file name and tab name as a file name to the end of each field.

So my data to work with looks like this:

I have tried a CrewMacro and I have also tried Dynamic input, so far I have been unable to achieve the desired result!

Any ideas

 

[afv2688 · Accepted solution]

Hello @Bigmonki 

This macro may be able to help you with your needs

Regards

[Bigmonki]

Hi @afv2688 

Thanks for this, it worked a treat.