Adding Identifier from field when loading multiple excel files

[SB555]

Dear Community, 

I have the following problem/challenge.

I have multiple excel files with the exact same structure (see sample attached): A header area with one field containing a Customer Number, and a range below with the table including the data that I want to use in the workflow.

My goal would be to add the customer number to each record created from the range in order to identify the entries in the overall databased later on.

I was able to get it to work with only one file by using 2 inputs for the same file, separating the information and using append fields. Unfortunately this does not work when loading multiple files for different customers.

Thank you in advance for any ideas on how to achieve this.

Scheme

[binu_acs]

@SB555 can you screen shot your macro settings, right click and choose open macro

[SB555]

Found it.

[SB555]

good News, I just saved the macro, re-run everything and now it looks like this

And the result is exactly as I wanted it to be :-)

Brilliant solution, Thank you so much!