That may depend on what "bob" does. It would be easier to help and test possible solutions if you could attach a copy of your file which includes any code you are currently using. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.