J
Jack
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.
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.