Pulling entire row when criteria is met.
 

I am importing information for a database to an Excel worksheet. This
worksheet will have all the info I am working with. Other worksheets will be
open for each salespersons number and these worksheets should only have the
information for each salesperson.

Raw data: Calculated Field

Sls# date sell price commission
154 1-1-02 256.50 25.65
156 1-1-02 565.55 56.56
154 1-5-02 1255.05 125.50

I want to have the indvidual worksheets to pull any row of data that has a
particular sls# anywhere in the entire column so a sheet could be printed and
given to each salesperson. The commission field will be calculated once the
information is imported. I tried using an IF function but something is not
right with the way I am doing it because it will pull information but have
blank spaces where the other sls# are instead of shuffling everything to the
top.

Any help is much appreciated.

Thank you.

Pulling entire row when criteria is met.
 

Using another column (eg insert a new column B), you could set up this
formula:

=A2&"_"&COUNTIF(A$2:A2,A2)

and copy it down - this will give you a sequentially numbered addition
to each sls number, like this:

154_1, 156_1, 154_2 etc.

Then on another sheet you could make use of VLOOKUP or INDEX/MATCH to
bring the data across for each occurrence of a particular sls number
(often you would select this through data validation from a pull-down
list of available sls numbers).

Hope this helps.

Pete

On Feb 20, 11:30*pm, Mike Koop
wrote:
I am importing information for a database to an Excel worksheet. *This
worksheet will have all the info I am working with. *Other worksheets will be
open for each salespersons number and these worksheets should only have the
information for each salesperson.

Raw data: * * * * * * * * * * * * * * * * *Calculated Field

Sls# * * date * * *sell price * * * * * * * commission
154 * * 1-1-02 * * *256.50 * * * * * * * * 25.65
156 * * *1-1-02 * * 565.55 * * * * * * * * 56.56
154 * * 1-5-02 * * *1255.05 * * * * * * * 125.50

I want to have the indvidual worksheets to pull any row of data that has a
particular sls# anywhere in the entire column so a sheet could be printed and
given to each salesperson. *The commission field will be calculated once the
information is imported. *I tried using an IF function but something is not
right with the way I am doing it because it will pull information but have
blank spaces where the other sls# are instead of shuffling everything to the
top.

Any help is much appreciated.

Thank you.