copy data without headers

  1. C

    Consolidation data from multiple worksheets error

    Hi, 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...

Some videos you may like

This Week's Hot Topics