Hi there,
I have a huge data set in 3 columns. The first column labels the datapoints
in columns 2 and 3. There are 5 labels, so there are many datapoints with the
same label. They are not in order (and can't be.) Is there anyway to use a
vlookup or something similar to go to the first column, look for label x and
return all the data rows in a list on a new spreadsheet? A bit like sumif
without the sum.
Thanks!

Sarah

How about using DataFilterAuto or Advanced and copy results to a new sheet.

You could automate it by using a macro.

Debra Dalglesih has a sample workbook that filters and moves the data to a new
worksheet.

http://www.contextures.on.ca/excelfiles.html#Filter

Scroll down to.......

FL0013 - Create New Sheets from Filtered List -- uses Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter.


Gord Dibben MS Excel MVP



On Wed, 24 Jan 2007 11:39:02 -0800, Sarah
wrote:

Hi there,
I have a huge data set in 3 columns. The first column labels the datapoints
in columns 2 and 3. There are 5 labels, so there are many datapoints with the
same label. They are not in order (and can't be.) Is there anyway to use a
vlookup or something similar to go to the first column, look for label x and
return all the data rows in a list on a new spreadsheet? A bit like sumif
without the sum.
Thanks!

Thanks
That's applicable but not for my output I don't think. I have a single
output spreadsheet for the data and I need to drop the results into specified
locations i.e. all the lines labelled B, have to go onto the new spreadsheet
from row 55, all the lines labelled D have to land from row 100 downwards etc.

"Gord Dibben" wrote:

Sarah

How about using DataFilterAuto or Advanced and copy results to a new sheet.

You could automate it by using a macro.

Debra Dalglesih has a sample workbook that filters and moves the data to a new
worksheet.

http://www.contextures.on.ca/excelfiles.html#Filter

Scroll down to.......

FL0013 - Create New Sheets from Filtered List -- uses Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter.


Gord Dibben MS Excel MVP



On Wed, 24 Jan 2007 11:39:02 -0800, Sarah
wrote:

Hi there,
I have a huge data set in 3 columns. The first column labels the datapoints
in columns 2 and 3. There are 5 labels, so there are many datapoints with the
same label. They are not in order (and can't be.) Is there anyway to use a
vlookup or something similar to go to the first column, look for label x and
return all the data rows in a list on a new spreadsheet? A bit like sumif
without the sum.
Thanks!