I have two customer A and B and i filter there statics using fliter(inbuilt excel function) but i want to filter by just one click on some kind of hyperlink instead of using filter function and select one of them by checking the box

in other words

i want to make a link or function to select all in fliter and one link to select customer A and one for customer B

actully i have too many customers and it is annoying to find and select one of them

There are a few ways this can be done but it is difficult to give one of the options without seeing a sample sheet. If you are using the Auto-Filter currently can you just type the customer name in the search box that comes up when you click on the filter arrow and then select your customer? If that wont work then I can write something where you click on a button and then inputbox will come up asking for the name. You type in the name and then the filter will give you the results it finds. This however does not always work because you may have more than 1 customer named John etc. Posting a sample sheet with the desired result will allow me to get a better idea on what solution to provide.

Thanks

Thanks for the reply

sample file attached

I tried to type the name in search box (assuming that is the drop box cell) it gives me option to select the name but when i press enter it does not filter the data

Actually it does change the cell text but does not filter the data

please make it clear if i am doing anything wrong.

Attached Files

sample.xlsx (13.7 KB, 12 views)

I dont think you are doing anything wrong. I think the 2007 version does not have the type of autofilter feature that I previously described. I have attached a working version of the idea. This worksheet will only work to filter the first column. If you look at the code by pressing ALT + F11 when the workbook is open you can see that the code is very very basic. You dont need to worry too much about the if statements those are just in there so the program does not error out.
You will have to excuse my older version of office I use a lot of different options and this computer happens to have 2003. Let me know how it works out or if you have any questions.

Thanks

Attached Files

FilterWorksheet.xls (59.0 KB, 19 views)

that worked prefect and exact what i want... Thanks

although i could not understand the formula you used , but since i dont need anything except this formula i even dont much need to understand it.

I would try to add this in my original workbook

you really deserve ++ reputation

Thanks again

Thanks for the kind words. The formula used was Visual Basic code and it's a whole other bear it can use the regular worksheet functions but basically makes it possible to do anything with Excel ( I havent found something Excel cant do it yet)

Thanks please feel free to mark as solved.

i am trying make this work in my original worksheet but i am so noob that i could not do that(shame on me) i even do not know how to make a button to run this micro or visual basic code

if you please guide me how do i do that i will be highly thankful to you

also tell me why it is asking to save (when going to close the file) even when no changes has been made?

Thanks again

Hi,

The button is the "Filter" button in the "CR" sheet that excelled software hase in the file he posted.
Are you wanting to move all of the code and the button to your original workbook?

i mean i want to do the same in my (diffrent) workbook

HI,

First you will copy the code that was created to the workbook that you want to use. Once you do that you can then do the following.

With the workbook you want to use the code in look for the "Developer" tab.
Click on it and this will display a drop down. You will then look for "Insert" click it and a dropdown will appear you will see options. Click the "Form Control" button. This will be the top left button in the drop down. When you select it you will then click the location in the worksheet you want the button be placed. A pop up will appear and ask you what code you want to use. You will click the desired code and then press "OK". This will see the button you just created to the code that needs to run.

If all else fails you can send the workbook to me.

hi,

This link may help you.

http://www.contextures.com/xlvba01.html

I have already enable the micros but after doing the same as you told me it says "the micro may not be available in this workbook or all micros have beeen disabled"

I have attached the file please dont mess up anything (as i would use the same file in future) i want to filter only one tab CR (tab name) and only column A in my file

Thanks in advance ( I will be here tomorrow)

Attached Files

Copy of express.xlsx (214.5 KB, 9 views)

Hi,

Check to see if ok.

Attached Files

Copy of express.xlsm (221.8 KB, 8 views)

Hi,

Your original workbook was saves as a "Excel Workbook". I do not think you can have code in that format. When you added the code you should have saved it a a "Macro enabled work book".

charles is right you need to have the workbook saved as Macro Enabled. When you select the file type as you are saving the workbook this is usually the 2nd option in the list. The main workbook format is in the top of the list.

Once you have the shape in your workbook, right click on it and then click on "Assign Macro" when you do it will allow you to select the macro to use.

Let us know what you come up with.

Thanks