VB to specify criteria then paste to a new worksheet

C

CH

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cutting and pasting data within a worksheet, from one sheet toanother, using selection criteria 1
multiple cells copy & paste 1
Passing Criteria to a Pivot Table from combo boxes 3
Looping over a worksheet 8
Any ideas on how to do this? 7
Deleting Values in a Row based on a Certain Criteria 2
so close but not quite there on an insert rows and copy paste spec 1
Copying rows from worksheet A to worksheet B based on criteria 2

Top