I want to compare two excel workbooks which differs in number of sheets, structure, column names etc whenever one matches value in another I want to create a new excel file with matched sheet names column name from both files. Is it possible?
It’s easy, but could take a very, very long time to run depending on the number of sheets, columns etc. You would have to nest for each loops to accomplish it. Honestly unless this is a crazy time savings, I wouldn’t recommend it. Are you really sure you need to iterate through every row and every column and every sheet and compare it one-by-one to every row and every column and every sheet in another workbook?
anything is possible and sometimes a robot is not even necessary.