I would like to consolidate all the data from worksheets that start with "Production" in a file and have used the following code. The macro works with
If sh.Name <> DestSh.Name Then, but not when I change this line into
If LCase(Left(sh.Name, 10)) = "Production" Then</pre>
What is the...