Worksheet_Change based on Cell Dropdown Selection

Hello,

I am trying to create a new worksheet based on the users input. The input cell is a data validation list. The code below works however, once the code executes and adds the new worksheet when I go back to the Scope worksheet if I make a change in any of the other cells the code runs again. I just want the code to work for that one cell.

HTML Code: 

Thanks! So I tried to add some code after your code to do some formatting on this new sheet like add column headings, make them bold, and add borders in range A1:J10. Now I'm running into an issue that when I go back to the Scope sheet and change another cell other than C8 the code starts to run again.

Hmm? Can you upload a sample workbook where you are experiencing this issue?

Copy of Scope Sheet - Copy.xlsm

Here is the file.

Thanks!

Not sure what C9 is supposed to do... but try below modification for C8.

Please Login or Register  to view this content.

This works perfect now. Thanks again!