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. :)_