FR - inserting rows

Posted by: JeanB

FR - inserting rows - 07/15/23 03:39 PM

How do I insert rows/columns in the Financial Reporter without affecting the "QUERYSHEET" formula references in the rows below the inserted line? If I insert a row on a referenced sheet then I have to go back to the QUERYSHEET formulas and update the referenced cell. FR doesn't seem to be intuitive in that respect and does not update the formulas like excel would.
Posted by: Retired_Guy

Re: FR - inserting rows - 07/25/23 12:21 PM

If you name the cells or cell ranges, and use the names in the QUERYSHEET() formulas rather than the cell coordinates, then the formulas will be updated properly as the named ranges are updated when rows/columns are inserted.
Posted by: JeanB

Re: FR - inserting rows - 07/27/23 11:26 AM

So for each cell reference I would first need to name the cell, and then use those names in the QUERYSHEET formula? So two steps?
Is this in the Financial Reporter webinar? If so can you tell me whereabouts in the video... if it's not I'll need better instructions. :)_