VLookup - Multiple Rows with Exact Matching Column 1
 

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!

VLookup - Multiple Rows with Exact Matching Column 1
 

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!

VLookup - Multiple Rows with Exact Matching Column 1
 

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!