hey guys,
I would like to ask assistance from excel experts here. Anyone knows how to filter data on all worksheets using check box or option box on the UserForm? I appreciate any help.
Regards,
Max
hey guys,
I would like to ask assistance from excel experts here. Anyone knows how to filter data on all worksheets using check box or option box on the UserForm? I appreciate any help.
Regards,
Max
do you mean o fiter tables on separate sheets for the same entry/ Why have separate sheets of data?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
hi,
thanks for the quick response. Sorry for not being clear. My bad. Here is the thing. I have a list of Employee names on Column A and list of Supervisor Names on Column B. Each employee name in column A may have the same supervisor name in column B. What I want to do is, if I click on checkbox 1 or optionbox 1 which is the name of supervisor1, it will show the list of employees under supervisor1. If I click on checkbox 2 or optionbox 2 which is the name of supervisor2, it will show the list of employees under supervisor2. I would like this to happen on all worksheets of the workbook.
Regards,
Max
Again, why have the data on different worksheets?
hi,
Ok here's how the workbook look like. Its a scheduling workbook I have. Workbook contains a sheet which has the same contents and these worksheets are named Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday. Basically all sheets contains one contents. This is why I would like to have a checkbox or option box to click and then filter all the rest of the worksheet. I dont need to copy the filtered sheets on another sheet though. I just need to filter all the sheets base on the supervisor name given.
Regards,
Max
You don't need a sheet for each day. Have all the data on one sheet, with a column to enter the days in. Then you don't need macros you can simply filter by day and/or name. The resulting workbook will be easier to manage.
Hi,
im sorry but i dont think that helps. I just want to know if this is possible or not. I appreciate your ideas but I would be much more happier if i was able to get some ideas on how to do the question at hand. right now i am at lost. thanks
max
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks