Within my workbook I have 26 worksheets and each sheet has a different amount of columns and rows. What I need to do is to create a new workbook based off of what is in column "C". So each sheet represents a different test. Column "C" on every sheet is the test location. So What I need is a workbook for every location that still has all 26 sheets, and each sheet only represents the location for each workbook. I will post an example of what I need. I hope that makes sense.
Thanks for the help!!
Bookmarks