Table information input

[iosiflupis]

I have a table that I am inputting data into. I am using the Forms built into Excel. I have three columns, Y, Z, and ZZ that have static numbers. I mean that each column has a specific number that does not change. I would like to have Excel automatically enter the data into the next row if there I have entered data into the blank row.

I tried in cell Y3 =Y2. that did not work. I also tried the =OFFSET(Y2,1,0) and was given a circular error. This table will have close to 3,000 rows when I finish entering data up to the current date and will continue to grow on a daily basis. I know that this is a simple answer, but for the life of me I cannot figure it out.

Thank you all for your help.

 

[OaklandJim]

What you need is not clear, to me at least. To get some help I recommend using the XL2BB add-in which allows you to post a portion of a workbook so we can see what the relevant data looks like. See HERE. That makes your need more understandable.