Hey i've been searching but i might not be searching for the correct words.. Well i wanted to know if there's any way to ask the user (maybe use a combobox or something) if he wishes to use a criteria for a certain field and if so to generate the table auto-filtering it as he wanted. All i could do atm it so place the autofilter thing but i still need to find a way to format the sheet acording to the filter. You guys know any way? Thanks