simora
09-13-2014, 05:04 PM
I have a worksheet with a column of book# formatted like 6032-11, 2349-5 , 7455-22 etc...etc..
I want to format each number to a separate page based on the value to the left of the dash.
The problem is that I don't know how many different book types I will have, and its possible that there's 4 0r 5 digits before the dash.
How can I format each book type ( The numbers to the left of the - )to a separate page and leave the original page untouched. After filtering, I want to automatically SUM the Column H of each filtered sheet and retain the page headings.
A VBA solution is preferred if possible.
SEE ATTACHED WORKSHEET
Any help appreciated.
Thanks
I want to format each number to a separate page based on the value to the left of the dash.
The problem is that I don't know how many different book types I will have, and its possible that there's 4 0r 5 digits before the dash.
How can I format each book type ( The numbers to the left of the - )to a separate page and leave the original page untouched. After filtering, I want to automatically SUM the Column H of each filtered sheet and retain the page headings.
A VBA solution is preferred if possible.
SEE ATTACHED WORKSHEET
Any help appreciated.
Thanks