MOVE CELLS DOWN AS TEXTBOX GROWS

Question

I have a form that has a format at the top and in the middle of the page there is a text box that I have set up to resize shape to fit text but not overflow the shape. Underneath this text box I need to be able to pull information using an equation from another sheet. Right now the text box just writes over the information underneath it. I need the information to move down as the text box grows. Any suggestions on how to do this? Any help is appreciated. Thank you. 

EX:

TITLE

NAME

PRODUCT

[                                                       TEXTBOX                                                 ]

PRODUCT 2

(ONCE YOU HIT ENTER INSIDE THE TEXT BOX WHILE ADDING A PRODUCT DESCRIPTION, PRODUCT 2 NEEDS TO ENTER DOWN A SPACE SO THAT THEY MAINTAIN A DISTANT FROM EACH OTHER)

Answer 1

Hi Mackenzie,

Thank you for posting your query in Microsoft Community.

As your query, I suggest you to post your query in Excel IT Pro for better suggestions related to this issue. Please click on the link below to post your query:

https://social.technet.microsoft.com/Forums/office/en-US/2daccafe-13b1-4009-96ad-e58f8adcb5b9/excel-data-add-values-if-other-values-are-equal?forum=excel

Hope this helps. Please post to us if you need any further assistance with Office products.

Thank you.