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

Help Community
1

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.

image
image1366Ă—768 46.7 KB

Request your assistance on the same.

Irfan M.

1 Like
2

Hi @irfan.mansoori ,

See if this solution is what you are looking for:

Main.xaml (9.9 KB)

AllSheets.xlsx (12.0 KB)

3

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…

Regards,

Irfan M.

4

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