VLookup - Multiple Rows with Exact Matching Column 1

H

Howeecow

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!
 
N

Niek Otten

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

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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!
 
H

Howeecow

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....
 
Top