If Worksheet name contains X then do Y

Hi Daniel

One way to copy only for the holding sheets is to use an IF statement such as:

If Left(mysheet.Name, 8) = "holdings" Then
Cells.Select
Selection.Copy
...
End if

The Left function picks up the first 8 characters of the sheet name.

This would be within a For loop that cycles through all the sheets adding the data to the master sheet.

I've attached an example where 3 holding sheets are consolidated with Copy/Paste Special Add.

You didn't say how your macro did the consolidation but let me know if I'm on the right lines.

Thanks
Doug Dunn
Best STL Training