Not at all... I didn't mean to imply selecting 8 options, but that 8 were available as a validation list. So, each time an option is selected, the data on the sheet changes to reflect that option. So the intent was to preserve that data as a separate sheet named for the option selected. I am used to creating separate sheets from a db table and using copyfromrecordset() so the approach used by my co-worker threw me off... but that what he wants to do.