VB to specify criteria then paste to a new worksheet
 

I need to find a way to in a sense query off of a spreadsheet in excel.

I have 4 criteria that a user will need to enter (for 4 separate columns)
into a sheet and then paste rows matching that criterion to a new worksheet.

I was thinking to use activeX text boxes to allow entry of the said
criteria, but not sure how to make VB look at a certain cell for criteria
instead of a fixed refernce.

Any help / guidance would be greatly appreciated.

VB to specify criteria then paste to a new worksheet
 

Are you familiar with the Autofilter?


Dennis

"CH" wrote in message
...
I need to find a way to in a sense query off of a spreadsheet in excel.

I have 4 criteria that a user will need to enter (for 4 separate columns)
into a sheet and then paste rows matching that criterion to a new
worksheet.

I was thinking to use activeX text boxes to allow entry of the said
criteria, but not sure how to make VB look at a certain cell for criteria
instead of a fixed refernce.

Any help / guidance would be greatly appreciated.