dotchieJack
Member
Hello,
In a sheet called data i have in c3 : c34 20 sheetnames (manualy input).
I would like a piece of code to change a cell if the sheetname changes.
For example if i change the sheet name sheet 1 into sheet 10 then the value of c3 in the sheet data should also change into sheet 10
Any suggestions welcome
In a sheet called data i have in c3 : c34 20 sheetnames (manualy input).
I would like a piece of code to change a cell if the sheetname changes.
For example if i change the sheet name sheet 1 into sheet 10 then the value of c3 in the sheet data should also change into sheet 10
Any suggestions welcome