I have been trying to simplify my code with no luck. What I am using works fine but to adopt the same code for more workbooks I would like it to be easier. Currently I am having the VBA evaluate some cells but I would like to have it do the same thing for the whole worksheet and I am not having...