Auto Update Text Box Cell Reference

J

jsv

I have to manually update cell references in text boxes as data shifts
(across columns) daily in a separate workbook. Is there a way to
automatically update all of the cell references at once using VBA?
 
Top