Searching in a excel sheet with multiple conditions and multiple options

[punna111]

Hi Guys,

This is very challenging to me not for you, I am learning VBA just now....

I have excel sheet which has a lot of data in it. I am attaching a excel sheet with developed user form.
link for excel sheet.- http://www.ozgrid.com/forum/attachme...7&d=1354472396

In the user form i have given some options, features i need to explain those.

option buttons (AND/OR)

when we are selecting multiple list boxes, with these options macro can search according to these options it means- "AND" is for two conditions should match, "or" means any one condition should match.


Check boxes (Exact match / Like match with *)

Exact match means given condition should match exactly. Like match means condition can be like it means partial match.(this match will be done by * symbol)

Combo boxes / List boxes

In the developed user form i have shown 2 combo boxes and 2 list boxes those are just showing purpose only. Normally the user form should display 1 combo box and 1 list box. but when we click on '+' button macro should display the another combo box and list box and also "-" button. with '-' button we can clear the new combo box and list box.

Combo boxes should contain some criterias as given in the excel sheet headings.
In List boxes user will type the data, for what he wants to search.

Command Buttons

with command button 3 another combo box and list box should display.

with command button 1 macro should search the sheet and display the result in sheet2,
after searching sheet 2 should open automatically. total row would be display in sheet 2 if the condition satisfies in a single cell.

I need a code for this macro..

Please let me know if any queries.

Thanks in advance....I am waiting for the reply...

PRB.

[protonLeah]

This is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.

Also, we're happy to help you with your effort, but nobody here will be keen on developing a solution from scratch. This forum is about helping people learn how to use Excel, not a free development service.

Have you started any work on this project yet?
How far did you get?
Where are you stuck?

We can help you develop your own code, but if you want someone to code this for you all the way, you should try and find a commercial developer.
----------------------
Rule 8 - Crossposting
I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
--------------------------------
Post your Excel files directly to this forum.
Post a simple example of your workbook.
Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

[punna111]

Thanks for immediate reply..

But i don't a single code to workout on this.
i have done research about this on net. i found some workbooks relates to multiple criteria but not with all options. that's why i posted a critical query here..

if you want i will provide the example workbooks relates to multiple criteria.

PRB.

[punna111]

i don't know about cross posting. from next time on wards i will give the link if any are there.

[cytop]

We prefer you include them now... but, as you didn't bother:

http://www.ozgrid.com/forum/showthre...800#post638800
http://www.mrexcel.com/forum/excel-q...e-options.html

[punna111]

Excel Hero's (Ninjas) help on this issue.

Thanks,
PRB

[punna111]

Hi all,

Please find the attachment.
i have researched and given some code to do this...
but i need this with two conditions.
if we press + button we will get another criteria..i want to search with two criteria s. how can i? please help me

to open user form. please click on the pink button on the sheet 1.

[punna111]

Hi all,

Can any one help on this...

[punna111]

no one helping on this..............