Prev: HOW TO MAKE A NUMBER OF CELLS INTO 1 BIG ONE AT THE BOTTEM
Next: counting identical items in a column and returning the occurrences
From: Mica on 26 Mar 2010 20:14 I have a camera object that refers to a range on another spreadsheet. When the user makes a selection the range filters to show only matching records. Unfortunately, the camera object does not resize to show only rows with data. Is there a way to make the camera object dynamic so that it will expand and contract based on the size of the currently filtered range? Thanks, - Mica |