VBA: Compare rows of worksheets

[MJAY__77]

Hello all together,

I would like to compare the rows of two worksheets with each other.

So, for example worksheet 1 has 8 rows, and worksheet 2 has 5 rows there is a difference of -3.

Now I would like to have a macro which calculate this automatically and put it into a specific cell.

I hope somebody can help me and I wish you a nice sunday

 

[mumps]

I think that it would be easier to help and test possible solutions if I could work with your actual file which includes any macros you are currently using. Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do using a few examples from your data and referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.