Copy data to other data base on requirement

[yukioh]

Hi all friends and experts,

I would like to ask your help,
I have some data, which is need to show the data from sheet DATA to sheet TARGET, when we change some code in B1 sheet TARGET
then the data in sheet data will show in TARGET sheet.
Is there any macro that will help make it faster than do it manually,?

I have explain my require with my attached file below:

[MarvinP]

Hi yukioh,

Instead of using two different sheets, I'd suggest you use an AutoFilter on your Data sheet only. That way you can use any of your column heads to filter your data.

https://www.timeatlas.com/excel-autofilter/

https://support.office.com/en-us/art...6-27B932E186E0

[yukioh]

any Others way to instead of filters ? some time I have to copy manual to target sheet...