Question: how to extract specific data from one sheet to another in excel using vba?
Answer: Enter data in Sheet1.
Create a criteria range.
Copy the required headers from Sheet1 where your data is entered to another worksheet, let's say Sheet2.
Click away from the headers in Sheet2.
Click on the Data tab.