Using Active x control button to copy Filter Row (Specific cell) data from one sheet to Another sheet

mamun_ges

Board Regular
Joined
Jul 21, 2016
Messages
58
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.

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. CodeBranch NamePO_RO_CORPGMOColumn1
129017GERH RNCHGERHKHULN129017GERH RNCHGERHKHULN
229033CHILMRI RNCHGERHKHULN229033CHILMRI RNCHGERHKHULN
329157CUR UILDING RNCHGERHKHULN329157CUR UILDING RNCHGERHKHULN
429041FKIRH RNCHGERHKHULN429041FKIRH RNCHGERHKHULN
529058GILL RNCHGERHKHULN529058GILL RNCHGERHKHULN
629066GURM ZR RNCHGERHKHULN629066GURM ZR RNCHGERHKHULN
729074KCHU RNCHGERHKHULN729074KCHU RNCHGERHKHULN
829082ZR RNCHGERHKHULN829082ZR RNCHGERHKHULN
929090MLLH RNCHGERHKHULN929090MLLH RNCHGERHKHULN
1029108MNGL RNCHGERHKHULN1029108MNGL RNCHGERHKHULN
1127284MNGL PR RNCHGERHKHULN1127284MNGL PR RNCHGERHKHULN
1229116MRELGNJ RNCHGERHKHULN1229116MRELGNJ RNCHGERHKHULN
1329124RMPL RNCHGERHKHULN1329124RMPL RNCHGERHKHULN
1429132RYEND ZR RNCHGERHKHULN1429132RYEND ZR RNCHGERHKHULN
1511015LI KDM RNCHNDRNCHIGNG1511015LI KDM RNCHNDRNCHIGNG
1611023NDRN RNCHNDRNCHIGNG1611023NDRN RNCHNDRNCHIGNG
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Forum statistics

Threads
1,221,821
Messages
6,162,157
Members
451,750
Latest member
pnkundalia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top