Data Selection using Vlookup
 

I have a spreadsheet with 20K rows. I need to select the employee ID and the
respective rows of data from the spreadsheet and put it into another
worksheet. Example, the employee is C123456 and I want all the rows of data
where his ID is referencend in a particular column. I tried vlookup, match,
index but have had no luck with these. This is a process we'll be running
monthly which basically tracks no of tickets an employee handles in that
period. Any suggestions are appreciated. Thanks.

Data Selection using Vlookup
 

The easy way: Just use Data--Subtotals. Then hit the 2 in the upper-left
corner to get everyone's totals.

The hard way:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=318
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"pomalley" wrote in message
...
I have a spreadsheet with 20K rows. I need to select the employee ID and
the
respective rows of data from the spreadsheet and put it into another
worksheet. Example, the employee is C123456 and I want all the rows of
data
where his ID is referencend in a particular column. I tried vlookup,
match,
index but have had no luck with these. This is a process we'll be running
monthly which basically tracks no of tickets an employee handles in that
period. Any suggestions are appreciated. Thanks.

Data Selection using Vlookup
 

So far a pretty terrific tool. Thank you so much for your time. I couldn't
have done it without you.

"pomalley" wrote:

I have a spreadsheet with 20K rows. I need to select the employee ID and the
respective rows of data from the spreadsheet and put it into another
worksheet. Example, the employee is C123456 and I want all the rows of data
where his ID is referencend in a particular column. I tried vlookup, match,
index but have had no luck with these. This is a process we'll be running
monthly which basically tracks no of tickets an employee handles in that
period. Any suggestions are appreciated. Thanks.

Data Selection using Vlookup
 

Pivot Table is a nice second function to use (available from the same data
menu). It is a little complicated at first, but basically you run it, and
then drag and drop the items you want. There is abundant help available on
this Excel feature ... and over time, you will want to use it more and more.

One nice feature of Pivot Table is that if you double-click on a result (at
least in my version) ... say, that employee number you mentioned ... it will
automatically create a spreadsheet with just data from that employee.

Also, if you are going to use Subtotal ... MAKE SURE you have sorted your
data by the record(s) you are subtotaling. Unlike Pivot Table, which sorts
the results automatically, Subtotal will not do this ... and therefore the
results can appear in more than one place. Below are my results using
subtotal when I DID NOT sort my data first.

Name Amount
Bill 10
Bill Total 10
John 10
John Total 10
Frank 10
Frank Total 10
Mary 10
Mary Total 10
Bill 10
Bill 10
Bill Total 20
John 10
John Total 10
Grand Total 70


In addition to what
"pomalley" wrote in message
...
So far a pretty terrific tool. Thank you so much for your time. I
couldn't
have done it without you.

"pomalley" wrote:

I have a spreadsheet with 20K rows. I need to select the employee ID and
the
respective rows of data from the spreadsheet and put it into another
worksheet. Example, the employee is C123456 and I want all the rows of
data
where his ID is referencend in a particular column. I tried vlookup,
match,
index but have had no luck with these. This is a process we'll be
running
monthly which basically tracks no of tickets an employee handles in that
period. Any suggestions are appreciated. Thanks.