Hi There,
I would like to try and shorten a long formula that I am using to check about 25 sheets for a match.
I have attached an example of what I would like to do with just 4 sheets but eventually this will expand to over 50 sheets plus.
This is just a snippet of the code I am using, this only checks TWO sheets and I currently have approx 25 and increasing
If you open the attached example it should explain my requirements in an easier format.Please Login or Register to view this content.
Thanks
Bookmarks