Hi,
I have a Nested Loop that is taking a value from one workbook, which has a scpecific cell color....
So once that Outer Loop value is determined from the first book, It's going to scan inside a pivot table (Just down the intersecting column) to find that value from Book 1.
Once inside the pivot where in the nested part of the loop.
When running the Macro, I see that the interior cell color changes but reverts back to the normal format (inside the pivot) once the code has fully ran.
Here is a look at the code....
Bookmarks