Thanks for the Code but it sorts complete sheet i only want to sort the visible row in filtered sheet for example if data is filtered with Column E / Model / C 200, then i want to sort the data by Column B / WIP NO , is it possible. Thanks
Testbox1, has filter as you type code.
check attached file before sort their is no issues. where testbox1 is working for example if you type S 500 you can see the filter.
Hi All,
I have an excel file where type to filter search box VBA is running, when i sort the data then type to filter box is not responding and complete sheet is getting highlighted , can you please fix this problem. Thanks
Find attached both files after sort and before sort.
I have an excel file where i has a VBA for highlight active cell row and column and on this file Redo/Undo function is not working
can you please provide me a solution on this. Thanks
Attached is excel file.
Previously I shared with little data as a sample but now when i compiled the file ( see the attachment) which has total 7000 and above rows and now search is very slow and screen freezes for few seconds , for example if you search word ''Released'' then you will see the search is very slow and...
@p45cal
Only one issue i encountered the filter drop down button gets invisible after search, so what is hapeening i have to clear the comlete filter where i loose the filtered column.
can filter drop down be visible always so that without clear i can do filter on top of another filtered column...
Dear All
I have an excel file where i have a text box with VBA code to filter the search.
This excel has 4 column B.C.D.E.F
I have 2 Concerns
first the text box searches in column B only, i want to change code to search in complete sheet
for example if i search S 400 which is in column E...
Actually i have to copy this text and put it in our company program when i copy and paste this text then it is showing complete text without line break , for instance i copy this text and put it in notepad no difference.
Sorry regarding column adjustment no i do not want to wrap text as per column adjustment i need line break after every 30 characters regardless column width.
Hi All
I want line break after every 30 characters in excel, attached is example file where i have done manually line break by ALT+ENTER
Can someone please provide me the VBA or some kind of formula to do it automatically, Appreciate your response