060 Advanced Filter Add a macro to a Sheet tab ترحيل البيانات إلى الجداول- مثال بيانات الطلاب
- Filter
- Advanced Filter
- Create a macro
- Run macro
- Add a macro to a Sheet tab
2 تحميل كتاب الإكسل للمهندسين pdf
3 كتاب مجاني شرح أكثر من 100 دالة من الإكسل
4 كتاب متقدم جدا 👌 كتاب طرق الاهلاك باستخدام دوال الاكسيل
Filter
A filter is a way to narrow down the data in a spreadsheet so that you can focus on the specific information you need. You can filter by cell values, text, dates, and more.
To filter data in Excel, follow these steps:
Select the range of cells that you want to filter.
Click the Data tab.
In the Sort & Filter group, click Filter.
Select the criteria that you want to use to filter the data.
For example, to filter for all cells that contain the value "Apple", you would select Text in the Filter by drop-down list, and then type "Apple" in the Filter box.
Advanced Filter
-----------------------------------------------------------
The Advanced Filter is a more powerful filtering tool that allows you to filter data based on multiple criteria. To use the Advanced Filter, follow these steps:
Select the range of cells that you want to filter.
Click the Data tab.
In the Sort & Filter group, click Advanced Filter.
In the Advanced Filter dialog box, select the Range that you want to filter.
In the Criteria Range box, type the criteria that you want to use to filter the data.
Click OK.
Create a macro
A macro is a set of instructions that you can record and then run to automate tasks in Excel. To create a macro, follow these steps:
Click the Developer tab.
In the Code group, click Record Macro.
In the Macro name box, type a name for your macro.
In the Store macro in drop-down list, select the workbook that you want to store the macro in.
Click OK.
Now, you can perform the task that you want to automate. Excel will record your actions as a macro.
When you are finished recording your macro, click the Stop Recording button.
Run a macro
To run a macro, follow these steps:
Click the Developer tab.
In the Code group, click Macros.
In the Macro name list, select the macro that you want to run.
Click Run.
Add a macro to a sheet tab
You can add a macro to a sheet tab so that you can easily run it by clicking the tab. To do this, follow these steps:
Right-click the sheet tab that you want to add the macro to.
Select View Code.
In the Microsoft Visual Basic for Applications window, paste the macro code into the Module1 module.
Save the workbook.
Now, when you click the sheet tab, the macro will run.