my data looks like these in columns B to Q, I need to generate a list in
terms of Sales Rep. and print for each one at a time.

I have a drop down list (data validation) in cell AD3, with the choises of
all Sales Rep. I would like to setup a table below with lookup equations, so
that whichever Sales Rep is selected in AD3, only values for that Sales Rep
will be shown in a table below that. (something like the table at the bottom
of this page)

heading1 heading2 heading3 heading4 heading5 heading6 Sales Rep.
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 MNP
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 YRS
blank row
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 YRS
blank row
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 MNP
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 MNP
etc. etc.








heading1 heading2 heading3 heading4 heading5 heading6 Sales Rep.
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC

You can create a criteria table on your workbook, then used the Advanced
option under the Data tab. Create an extraction table in another location on
the same worksheet, then you can simply use your inputted criteria from the
Criteria table, select the advanced filter button, then use the 'Copy to a
new location' option to extract the records that match your criteria to the
extraction table you've already made.

"raz" wrote:

my data looks like these in columns B to Q, I need to generate a list in
terms of Sales Rep. and print for each one at a time.

I have a drop down list (data validation) in cell AD3, with the choises of
all Sales Rep. I would like to setup a table below with lookup equations, so
that whichever Sales Rep is selected in AD3, only values for that Sales Rep
will be shown in a table below that. (something like the table at the bottom
of this page)

heading1 heading2 heading3 heading4 heading5 heading6 Sales Rep.
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 MNP
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 YRS
blank row
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 YRS
blank row
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 MNP
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 MNP
etc. etc.








heading1 heading2 heading3 heading4 heading5 heading6 Sales Rep.
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC
name 1 Company 121 556 50 5463 ABC