PDA

View Full Version : Extract data to another sheet according to different filtering conditions (using vba)



travata18
10-14-2018, 09:16 PM
Dear Vbaexpress sisters,
I know that this subject has made many people. But now, I do not have any knowledge about VBA. So you set up the thread to you help me create code filter.
Postcard: I have a document that summarizes the production data of the Company (Attachment - Sheet Detail Data). I want that when entering different filter conditions (yellow light) at sheet processdata, the data will show down below, its purpose is to analyze the data after the filter to the sheet chart.
I would like to thank you.

travata18
10-14-2018, 09:25 PM
This is manually filtered: under the conditions selected above (yellow), then copy from the source data to the target data sheet next to the processdata sheet. What I want is that you just select the conditions, and then press the button that it will appear always.