I'm trying to setup a primitive dashboard (base display Sheet that is fed by other worksheets). I'm using the Paste Picture Link, which works well but I'm running into an issue that I'd like to solve. I'm pasting a small table of 6 rows and 4 columns. When I insert a row on my data input worksheet, the row gets added on my pasted picture link on the base display sheet. Is there a way for me to only show the top 6 rows (and not add a 7th row when I insert a row)?
Here's the forumla for the Pasted Picture Link
=BBS!$A$1:$D$6
when I add a row on the "BBS" sheet, it does this:
=BBS!$A$1:$D$7
I'd like it to stay at 6 rows, regardless of whether I insert a row or not.
Here's the forumla for the Pasted Picture Link
=BBS!$A$1:$D$6
when I add a row on the "BBS" sheet, it does this:
=BBS!$A$1:$D$7
I'd like it to stay at 6 rows, regardless of whether I insert a row or not.