Question: how to extract data from excel sheet using macro?
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.