Hello,
I have a Large data sheet.
There I use a Search String for filter as you type.
When I type on the Search Box the data filter and show only the specific result which matched with the search box data.
Now I have to copy this filter row (Specific Cell Suppose Cell B, C and D) to another sheet name "result sheet" leaving the first row blank and paste on the next blank cell by Click on a Active X control Button.
Please, any help will be much appreciated.
I have a Large data sheet.
There I use a Search String for filter as you type.
When I type on the Search Box the data filter and show only the specific result which matched with the search box data.
Now I have to copy this filter row (Specific Cell Suppose Cell B, C and D) to another sheet name "result sheet" leaving the first row blank and paste on the next blank cell by Click on a Active X control Button.
Please, any help will be much appreciated.
Note In the Search Box just left of the work sheet to use auto filter data. Now when a filter is done to find the specific data suppose we type 29074 then it shorted out and show the only 29074 related row. Now I want to copy this row just click the Active x control button to copy this row (Specific Cell) to other Sheet Name "Result Sheet" leaving the first row blank then to the next blank row. By this I want to create a Search Result for my work. | |||||
<<<<< SEARCH HERE | |||||
Search by Br. Code or Name | |||||
BR. CODE | |||||
SL. | Br. Code | Branch Name | PO_RO_CORP | GMO | Column1 |
1 | 29017 | GERH RNCH | GERH | KHULN | 129017GERH RNCHGERHKHULN |
2 | 29033 | CHILMRI RNCH | GERH | KHULN | 229033CHILMRI RNCHGERHKHULN |
3 | 29157 | CUR UILDING RNCH | GERH | KHULN | 329157CUR UILDING RNCHGERHKHULN |
4 | 29041 | FKIRH RNCH | GERH | KHULN | 429041FKIRH RNCHGERHKHULN |
5 | 29058 | GILL RNCH | GERH | KHULN | 529058GILL RNCHGERHKHULN |
6 | 29066 | GURM ZR RNCH | GERH | KHULN | 629066GURM ZR RNCHGERHKHULN |
7 | 29074 | KCHU RNCH | GERH | KHULN | 729074KCHU RNCHGERHKHULN |
8 | 29082 | ZR RNCH | GERH | KHULN | 829082ZR RNCHGERHKHULN |
9 | 29090 | MLLH RNCH | GERH | KHULN | 929090MLLH RNCHGERHKHULN |
10 | 29108 | MNGL RNCH | GERH | KHULN | 1029108MNGL RNCHGERHKHULN |
11 | 27284 | MNGL PR RNCH | GERH | KHULN | 1127284MNGL PR RNCHGERHKHULN |
12 | 29116 | MRELGNJ RNCH | GERH | KHULN | 1229116MRELGNJ RNCHGERHKHULN |
13 | 29124 | RMPL RNCH | GERH | KHULN | 1329124RMPL RNCHGERHKHULN |
14 | 29132 | RYEND ZR RNCH | GERH | KHULN | 1429132RYEND ZR RNCHGERHKHULN |
15 | 11015 | LI KDM RNCH | NDRN | CHIGNG | 1511015LI KDM RNCHNDRNCHIGNG |
16 | 11023 | NDRN RNCH | NDRN | CHIGNG | 1611023NDRN RNCHNDRNCHIGNG |