The attached sample has a code that breaks out information into separate workbooks based on changes in column C. The problem I am dealing with is a sub c code exception that has been added which is missing some rows when its created and saved in a file. For example, if the number in column c is 000060 and the manager is Washington, George, a new workbook is created named 000060A.
Based on the current code this works fine but when you open 000060A it is missing rows 1-13 that appear in the master. The Sub c code at the bottom calls out the SR =14 which is set to the number of rows with first line after header but this is not sufficient as I mentioned earlier because its missing rows 1-13 from that master sheet. If I change the SR to equal 1 (thinking that would grab everything), it bypasses the Sub c code.
So basically when you open 000060A the first 14 rows should look identical to opening workbooks 000030, 000002, etc. (see sample pic). Please note that if you are going to test the existing code you'll need to provide a file path of where you want the new workbooks to be saved (Filepath = "S:\").
I've been stuck with this issue for a while and hoping some VB wizards can provide assistance. Please provide a sample of the updated code in an attached workbook. Thank you!