Copy Sheet name and mention against all the records of the particular sheet name

Hi Team,

I have a an automation issue for which request your kind support and guidance.

I have 2 sheets in an excel file, all have 2 records each and there are 2 columns which are same.
I would like to copy the records from all the sheets in a new sheet. In the 3rd column, i would like to add the sheet name for whom the record belongs.

I could get all the records in one sheet, however I am unable to get the sheet name copied against their respective records.

An example is highlighted in the below screenshot where i could copy the data from both the sheets, however, sheet name is not coming.

Request your assistance on the same.

Irfan M.

1 Like

Hi @irfan.mansoori ,

See if this solution is what you are looking for:

Main.xaml (9.9 KB)

AllSheets.xlsx (12.0 KB)

Hi Alexandre,

Thank you for reply. I have checked the xaml file and it looks like ive got the result.

Thank you so much for the support and assistance. Appreciate your kindness…


Irfan M.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.