I am trying to parse a simple statement but cant seem to work it out.
I have a list of stakeholders, upto 10. I enter their names into a list and I need VBA to rename a hidden sheet to that Stakeholder's name then unhide it. I have 10 hidden sheets, labelled "Stakeholder1" ... "Stakeholder10, with sheet indexes of Sheet11 to Sheet20. Because each one is tied to a cell I want to "link" the VBA to reference Sheet11 when "Stakeholder1"'s cell is edited. I can do it by sheet name but I have to track the name and if some butthead enters the name "Stakeholder3" in the cell for Stakeholder 5, everything goes to heck in a wicker basket.
My problem to date with searching for answers is I either can't explain it properly in my search text or Google is "helping" by "understanding" what I was "really" looking for.
I have a list of stakeholders, upto 10. I enter their names into a list and I need VBA to rename a hidden sheet to that Stakeholder's name then unhide it. I have 10 hidden sheets, labelled "Stakeholder1" ... "Stakeholder10, with sheet indexes of Sheet11 to Sheet20. Because each one is tied to a cell I want to "link" the VBA to reference Sheet11 when "Stakeholder1"'s cell is edited. I can do it by sheet name but I have to track the name and if some butthead enters the name "Stakeholder3" in the cell for Stakeholder 5, everything goes to heck in a wicker basket.
My problem to date with searching for answers is I either can't explain it properly in my search text or Google is "helping" by "understanding" what I was "really" looking for.