Forum Discussion
color coding values based on values in multiple sheets vba script
I am trying to color values in cells based on certain range criteria. I do a lot of data entry on a daily basis. I came across a lot of VBA related things and macro recorder etc in excels. However ...
I believe the code is the first half of the project. The second half would be to create a LOOP in the macro that can open each of the 3,000 files and import the macro in the loop.
Can you confirm if all files you have follow the same naming structure, layout and table dimensions?