I have a very large worksheet for which I need to create separate workbooks when the value of a particular cell changes. Each workbook would contain the range of cells prior to the cell break. I would like for the workbooks to be named the same as the trigger cell contents (5-digit number). I have searched but am not able to find any code that would perform this function for me. Can you help?