Need to bring worksheet name from the range of data that is copied

[Ignesh]

Hi,

I have tried to bring data from multiple sheets to summary sheet. One point which is missing is which I am not able to bring sheet name to the number of lines of data each sheet has.

Also, the data merger is currently set up with range mode and If I need to select all the data (if data has variance of my range) without range setting then how do I code it.

I have enclosed the file for the reference.

Thanks,

[mikerickson]

This should do what you want

Please Login or Register  to view this content.

[Ignesh]

Thanks for the help.

Now, the macro runs on a particular range and if I have multiple ranges in different worksheets, then the complete data has to be selected and copied to the summary sheet.

If I use in cells.select instead of range settings, does it works or else please let me know the code to change for the unknown data to be selected.

Thank you.

[mikerickson]

It worked on the sample data in the workbook you attached.
Please attach a workbook with the data that it failed to work on. (redacting any sensitive information) and a description of what it did that you didn't want it to do.

[Ignesh]

Thanks, I was able to do small tweaks and the macro is running fine.

Thanks for the help.