I'm not sure I understand what you mean, but do have a look he

http://office.microsoft.com/en-us/ex...260381033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Howeecow" wrote in message ...
|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!