PDA

View Full Version : Adding and Deleting a Sheet Dependent on Cell Content



Ghost662
10-06-2015, 06:45 AM
Hi Everyone,

I'm looking for a way to have excel add a worksheet for each populated cell in a range, say A1:A10, name each worksheet after the contents of its respective cell, and delete the worksheet if the cell's contents are deleted. If the value in a cell changes, I also want the name of it's worksheet to change.

I've already been able to do most of this in several different ways, but I'm struggling with deleting worksheets because I can't seem to link the cell to a worksheet. That is, I can come up with code that creates a sheet and names it whatever is in a particular cell, but that's where the link between the cell and the worksheet ends.

A potential solution I'm currently considering is to have excel add these worksheets with a unique code name, such as Cell1. However, if have no idea how to change code names. Can anyone help me? Or if you think you have a different solution, please share.

Thank you in advance!