I am trying to create a worksheet moving copying from Worksheet 1 to
Worksheet 2.

On worksheet 1 my data is sorted by column 1 in months but I have multiple
lines per month.

I am trying to copy those multiple lines to a second worksheet without
actually having to copy and paste.

What is the best formula to use to have all columns of multiple rows copied
over as they are typed?

Thanks!