Sorry maybe I didn't explain well enough I am creating a new worksheet. I am
trying to add multiple rows with the same value in column A. I am trying to
add the data from an existing book with multiple worksheets.

On my existing worksheets, in Column A, are the months that I pay an
invoice... (april, may, june, etc.)

On my new worksheet I would like to return each row on my old worksheets
that starts with for instance April.

I can use Vlookup but I can only return data from the first row that has
April. How do I also return data from the second row that has April as the
lookup_value?

Hope that helps a little....

"Niek Otten" wrote:

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!