P
pcox
I have a workbook with several sheet in the book and one sheet that will need
to pul from one of the seperate sheet (same location, just different sheet).
The normal forlmula is ='[sheetname]'!cell. Is there anyway that the sheet
name can reference a data range so that all I have to do is change the value
in the data range to update the formula?
to pul from one of the seperate sheet (same location, just different sheet).
The normal forlmula is ='[sheetname]'!cell. Is there anyway that the sheet
name can reference a data range so that all I have to do is change the value
in the data range to update the formula?