ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Code to compare cell values from different worksheets (https://www.excelbanter.com/excel-programming/323526-code-compare-cell-values-different-worksheets.html)

Ed P[_2_]

Code to compare cell values from different worksheets
 
Can someone let me know if there is a way to compare the value of cells that
are on different worksheets within a workbook.

Thanks in advance for your help.
Ed

Mika

Code to compare cell values from different worksheets
 
Hi Ed,

Not sure to understand, but :

If sheets("your name sheet").range("b4")=sheets("your other
sheet").range("m8") then

follow by your code...

Rgd
MIka



All times are GMT +1. The time now is 03:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com