title: Google Sheets - Add new row in Named Range
body: <p>I have Dynamic Named Range in Google Sheet B3:C and call to another cell F1, H9:H were input manually as <a href="https://i.stack.imgur.com/xJdtQ.jpg" rel="nofollow noreferrer">Pic 1</a> and <a href="https://i.stack.imgur.com/1fYgR.jpg" rel="nofollow noreferrer">Pic 2</a>.</p>
  <p>My question is: anytime I add new row in Range1 B2:C, data input in column H didn't expand corresponding <a href="https://i.stack.imgur.com/2Letb.jpg" rel="nofollow noreferrer">Pic 3</a>.</p>
  <p>How can the column H auto add new row follow Range1 and still keep data relate to cell next to it as shown in
  <a href="https://i.stack.imgur.com/ICi4Y.jpg" rel="nofollow noreferrer">Pic 4</a>?</p>