Can anyone pls point me to some example where we can compare contents of 2 excel tabs and writing the result in 3rd tab using PowerSh

Take a look this https://social.technet.microsoft.com/Forums/scriptcenter/en-US/50db542d-8c7d-47a3-9197-d4094ac352ba/compare-two-excel-sheets-using-powershell

Hi PK2015...thanks for your reply...but thats to compare contents from 2 CSV sheets, but I was looking to compare from same excel sheet, that will have 2 or more tabs and write an output in the 3rd or 4th tab...pls let me know...I am also searching online...

Why do you want to use a PowerShell script to compare sheets in a workbook? Wouldn't it be better to use functions and formulas in Excel? If you want help you need to give examples of data in the sheets you want to compare and what you expect as result in the third sheet.

Why do you want to use a PowerShell script to compare sheets in a workbook? Wouldn't it be better to use functions and formulas in Excel? If you want help you need to give examples of data in the sheets you want to compare and what you expect as result in the third sheet.

• Marked as answer by mywindows 6 hours 48 minutes ago

Why do you want to use a PowerShell script to compare sheets in a workbook? Wouldn't it be better to use functions and formulas in Excel? If you want help you need to give examples of data in the sheets you want to compare and what you expect as result in the third sheet.

• Marked as answer by mywindows 6 hours 55 minutes ago

Why do you want to use a PowerShell script to compare sheets in a workbook? Wouldn't it be better to use functions and formulas in Excel? If you want help you need to give examples of data in the sheets you want to compare and what you expect as result in the third sheet.

• Marked as answer by mywindows Sunday, April 05, 2015 12:11 AM

Thanks Leif for your input.