It seems like I've copied and pasted every example I could find, and none have worked. Sheet One, is the Input Sheet, that populates the values in Sheet Two which is the Invoice Sheet(Sheet Two, all Cells are totally locked).
I have 10 devices(rows) I can enter in the input sheet(sheet 1). The next row would be the totals. If I only enter 7 devices(rows), I would like the remaining 3 rows to be hidden(sheet two), like on an invoice. If I need to add an 8th device(row) it will unhide that 8th row on Sheet Two, when I enter the information in the appropriate Cell in the input sheet, etc.
I'm trying to avoid having empty rows between the device list and the totals.
My first Device Column/Row starts at A8, and my last Device Column/Row ends at A26. An example of the formula in Column A is: =IF('Input Sheet'!$B15>0,'Input Sheet'!$B15,""). So if I don't enter anything in the input sheet Cell $B15, the value is 0 and the A8 row hides. Help
I have 10 devices(rows) I can enter in the input sheet(sheet 1). The next row would be the totals. If I only enter 7 devices(rows), I would like the remaining 3 rows to be hidden(sheet two), like on an invoice. If I need to add an 8th device(row) it will unhide that 8th row on Sheet Two, when I enter the information in the appropriate Cell in the input sheet, etc.
I'm trying to avoid having empty rows between the device list and the totals.
My first Device Column/Row starts at A8, and my last Device Column/Row ends at A26. An example of the formula in Column A is: =IF('Input Sheet'!$B15>0,'Input Sheet'!$B15,""). So if I don't enter anything in the input sheet Cell $B15, the value is 0 and the A8 row hides. Help