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,
Bookmarks