VBA code to gain data of selection

[Navi_G]

Hi All Experts,
I am here with a problem. I have data sheet named "Cut Sheet" in which I have my data in columns "J:N" rows of this data could increase and decrease I want to extract data from that range in to "A:E" column I want that when I write cut # in my Search box then data of that cuts will appear in "A:E". Search box is only an idea it could be a list like filter where I can check multiple cuts at a time. Link of my file is given bellow. This is only sample data rows of this data may increase.

Cut Detail.xlsm

Thanks in advance for help.

Regards,
NAVI_G

 

[mse330]

Hi Navi,

This can be done easily with Advanced Filter ... For the below macro to work, remove merge cells, in cell G2 type "CUT #" & list below it all needed numbers to be used for the filter then run below macro

Sub test()

[J1].CurrentRegion.Offset(1).AdvancedFilter 2, [G2].CurrentRegion, [A2:E2]

End Sub

 

[Navi_G]

Hi Navi,

This can be done easily with Advanced Filter ... For the below macro to work, remove merge cells, in cell G2 type "CUT #" & list below it all needed numbers to be used for the filter then run below macro

Sub test()

[J1].CurrentRegion.Offset(1).AdvancedFilter 2, [G2].CurrentRegion, [A2:E2]

End Sub

Dear sir I know how to use filters but I need only a VBA code for this its to tough for my data

 

[mse330]

I have already provided the VBA code ... Give it a try

 

[Navi_G]

I have already provided the VBA code ... Give it a try

Dear sir I tried this code but is not working properly. When I type "CUT #" in "G2" like "353" it bring whole data of Range "J:N" in range "A:E". Selection is not working.

 

[Navi_G]

Hi All,
Pls provide help against this theory.

 

[kvsrinivasamurthy]

R2 CUT #
R3 342
R4 345
R5 353

select J2
Data--> Advanced (sort & filter)
List range already selected
Criteria range select $R$2:$R$5
Click on Copy to another location
Copy to $A$2:$E$2
Press --> OK.

If data is changed you have to refresh filter.

 

[mse330]

Hi Navi,

I have attached a copy of the workbook with the macro suggested in post # 2 & it is working fine with me ... Try the attached workbook & let me know if it doesn't work for you

DropBox File Here

 

[Navi_G]

Hi Navi,

I have attached a copy of the workbook with the macro suggested in post # 2 & it is working fine with me ... Try the attached workbook & let me know if it doesn't work for you

DropBox File Here

Dear Sir,
Thanks a lot its too amazing.

 

[mse330]

You’re welcome