Hi,
I have a workbook with around 60 sheets that are all essentially the same. Each sheet has a "weeks until due" value. I have added a "due date correction" value in C12 on all sheets.
Is it possible, to have on my front sheet, the due date correction value in one cell, then a drop down list of all the other worksheets in another cell. That way I can put a correction value in, select which sheets to update from the drop down list and finally hit an "update" button to carry it out? So, put value x in cell C12 on sheets A, B, C ...
I've tried searching the web, but all I can find for changing the same cell across sheets is grouping sheets and possibly 3-D referencing; but that doesn't look like it works the way I am trying to.
Thanks in advance
I have a workbook with around 60 sheets that are all essentially the same. Each sheet has a "weeks until due" value. I have added a "due date correction" value in C12 on all sheets.
Is it possible, to have on my front sheet, the due date correction value in one cell, then a drop down list of all the other worksheets in another cell. That way I can put a correction value in, select which sheets to update from the drop down list and finally hit an "update" button to carry it out? So, put value x in cell C12 on sheets A, B, C ...
I've tried searching the web, but all I can find for changing the same cell across sheets is grouping sheets and possibly 3-D referencing; but that doesn't look like it works the way I am trying to.
Thanks in advance