Maybe...

And Debra Dalgleish added some stuff he
http://contextures.com/xlForm02.html
and maybe he
http://contextures.com/xlForm03.html

Jessica wrote:

Hi. I am trying to automatically transfer data entered on my Master sheet
(entered in a column) to a second sheet in row format. I also want each time
an entry is made on my Master sheet to know to enter on sheet 2 on a new row
so that the data entered previously will still show.
--
Jessica

--

Dave Peterson