2 Replies Latest reply: Sep 14, 2016 3:18 AM by Guillermo Lo-Kioeng-Shioe RSS

    Excel report in Nprinting

    Guillermo Lo-Kioeng-Shioe

      Hi,

       

      I am trying to create a report in excel with a few if formula's refering to another sheet.

       

      So this is the issue:

       

      Sheet 1: I have a few formulas refering to sheet 2

       

      Sheet 2: is a table i'm importing from qlikview. It has a 4 columns and some rows.

       

      I want sheet 1 to show some data only if there is "something" in a cell on sheet 2.

       

      However the problem im facing is that whenever im running the report the table is being "insterted" what makes the formula in sheet 1 jump all the rows thats being insterted. So my formula was refering to cell A3 but because the table was "inserted" now its refering to cell A685. I tried dollar signs but it still went from $A$3 to $A$685.

       

      Any idea's how i can fix this?

       

      Thanks in advance.