Hi,
Currently I am facing an issue with compiling the data from multiple sheets at 'Summary' Sheet.Here the problem is that I want Column A (NAME) from multiple sheets which will be unique and no duplicates.Secondly I want to pull the data of the column which has header 'Net Pay' but the problem is that Column is not fixed and may vary its position. In some sheets it is Column Y, sometimes Z,AB,AA and so on.
So,how can this be done ?
Here sheet name can be shown in row.Sample header and column A data is shown manually in 'Summary' sheet including Total of 'Net Pay' at last.
Pls note that there are many sheets may be 50-60.Here in this demo file I have presented only few sheets for demonstration purposes.
Bookmarks