Mac Excel users

Where do I put the code? I don't do Visual Basic or VLookup, etc...not yet although I guess I need to learn!

Originally Posted by virtualadmin

...I don't do Visual Basic or VLookup, etc...not yet although I guess I need to learn!

Well in that case,...I'll write a routine that check two worksheets to see if their formulas match each other. I'm on lunch break at work right now, so it will be a few hours until I get a chance to do this.

(This sounds like its going to be a fun routine to write.)

I am in awe of how kind and generous that is. Thanks so very much

Is this a one-time situation or are you looking for something that can be used in various situations.

Ideally, the ability to use it in multiple situations would be very nice. However, in the immediate future, it's a one time situation.

Thanks

OK, This is my current plan.

We are creating a Comparing Workbook that will look at two other workbooks and verify that their formulas match. (Values can be different.)

The sheets need to be named the same in each book. It is not clever enough to notice that someone SavedAs and renamed the sheets, but left the formulas alone. (I think I could be made it that clever, but it would be deadly slow.)

If there are any mismatches, they will be noted on a sheet in Workbook("Compare").

If these restrictions need to be changed, now is the best time to do that.

Also, aprox. how many sheets per book? I think that I can deal with 500ish sheets per book but its still good to know.

Thanks!

There are only 3 sheets in each workbook and they are both identically named.

Thanks so much for doing this!