filtering data with a macro
 

Good day gurus,

I need help for the following macro I"m trying to record.

Let's assume I have two worksheets in this workbook:
Worksheet A consists of columns A:H
Worksheet B consists of columns A:Z with filtering data

I want a macro that allows me to input in worksheet A
cell A2 - a value then worksheet B will automatically
filtering that value from worksheet A under the
appropriate columns.

For example,
worksheet A (user input)
column A - company
column B - product
column C - year

worksheet B (data sheet)

If an user inputs value in the appropriate columns in
worksheet A, then worksheet B will filter the appropriate
column simultaneously.

Thank you in advance for your help.

Jack.

filtering data with a macro
 

Try recording a macro that does what you want.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jack" wrote in message
...
Good day gurus,

I need help for the following macro I"m trying to record.

Let's assume I have two worksheets in this workbook:
Worksheet A consists of columns A:H
Worksheet B consists of columns A:Z with filtering data

I want a macro that allows me to input in worksheet A
cell A2 - a value then worksheet B will automatically
filtering that value from worksheet A under the
appropriate columns.

For example,
worksheet A (user input)
column A - company
column B - product
column C - year

worksheet B (data sheet)

If an user inputs value in the appropriate columns in
worksheet A, then worksheet B will filter the appropriate
column simultaneously.

Thank you in advance for your help.

Jack.