Need to Make Camera Tool Image Dynamic (Auto resize as data is added/deleted)

Greetings.

I need to make a camera tool image automatically resize when data is added or deleted. Data set can be either a Table or a Range - no preference. Was initially thinking some type of offset formula would work but I don't know where to start...

Appreciate any help on this...

hi Steve N. press CTRL + F3 to go to the Name Manager. click on "New" & give it a name. i'll name it "CameraObj". in "Refers to", put in:
=OFFSET($A$1,,,COUNTA($A:$A),8)

click OK. now click on the camera object & you should see a formula in the formula bar. replace it with:
=CameraObj

you're very welcome~

OFFSET has 5 parts to it:
=OFFSET(reference,rows,cols,[height],[width])

reference
this is your starting point. it could be anywhere as long as you adjust the next 2 arguments. my formula is using A1 as the starting point

rows
this will adjust the starting point by the number you indicate. if my reference was in A2, then this would be "-1" to go back to A1. if i put "1" instead, it will add 1 row & bring it to A3. "0" will make it stay as it is & is the default value. hence, i didnt put anything to since the default is "0"

cols
like the rows, this will adjust the columns. so if my reference was in B1 now, "-1" will bring me to A1. "1" will bring me to C1. "0" would make it stay & this is the default. again, i did not put anything.

height
notice is argument is in square brackets. default is 1. it must be at least 1 cell high. it's optional. for your case, i need it to be 23 rows tall since it ends in row 23. to make it dynamic, i used COUNTA to count how many filled cells are in column A. and it actually returns "23".

width
again, in square brackets. default also 1. 1 cell high & 1 cell wide is referring to 1 single cell. since columns are unlikely to change, i fixed it at "8", which is the number of columns from A to H