Float an “image” of some cells in your sheet and have them update automatically!
- Select the cells you want in the dynamic image
- copy them as picture (the copy drop-down on the home ribbon)
- paste the picture wherever you want it
- With the image selected, press F2
- Enter an equals sign in the formula bar
- and then select the cells where the original data lives. Hit enter.
Your data should now update in the image!