Search results

Great sgmpatnaik. Now it is working fine now. Thanks a lot for your help on this. Regards, Phani

Hi bobhc, Thank you very much for your reply. The suggested way of locking the scroll area is working fine. However, when I save, close and re-open the file I didn't the see the "scroll area lock" what I have applied earlier (before closing the file). Can you please suggest any solution for...

Hi oldchippy, Thanks for your quick reply. Unfortunately, it doesn't provide the information I am looking for. I need to lock the scroll area in the specified range of cells. For e.g. if I apply the scroll lock for A1:U32 range, I do not want to scroll the remaining area except A1:U32 range...

I need your help on "how to lock the scroll area" in the excel workbook. I have tried the below but it is not working when I close and re-open the workbook (I have saved the work book before closing). Alt+F11----->View---->properties window--->scroll area---> I have provided...

Excellent. This is working fine. Thanks a lot shrivallabha.

Thanks for your reply. I have tried the above mentioned formulae, however, If the "key word"is present multiple times in the "data sheet", the output is not coming properly. i.e. the same sentence has displayed multiple times. Please find the excel file in the below link with the 'data' and...

Hi, Can you please help me in adding "search by text" option in excel 2010 using VBA code. The basic idea is - with this "Search by text" option user can search the tool using specific "key word". The data is present in one excel sheet and the out put of the search should appear in another...

Hi Narayan, Excellent. Thanks a lot for your help.

Hi Narayan, Can you please provide the solution for my previous query. Please let us know if you need additional information. Thanks.

Thanks a lot. It's working fine now. I need one more small clarification. Now,I am trying to enter the data by selecting one country from dropdown box. The moment I enter the data in one cell then all country rows are getting hide. For E.g. in the file you forwarded to me, I have selected...

Hi Narayan, I am also looking for a macro code to hide the rows, which is almost similar to what Veerya asked. I haved copied the code from your previous posted file and pasted to in to the my excel work book and changed the ranges accordingly. However, it is not running in my work book and it...