Excel Functions Linking two pull-downs (drop-downs) without macros (for linking only one set) Excel (Excel)
この記事ではExcelで2つのプルダウンを連動させる方法を解説します。部署選択後に該当社員のみ表示したいけど作り方が分からず悩んでいませんか？実はINDEX関数とMATCH関数で簡単に連動可能。Excel専門家が伝授します。
Excel Functions 
Excel Macro (VBA) How to use the property of variable type "Workbook" Excel (Excel) Macro (VBA)
You can read more about how to use the variable type "Workbook" in this blog. How to use the variable type "Workbook" Excel(Excel)Macro(VBA)Here we will explain the "Workbook" property in a little more detail.Wo...
Excel Functions Excel RIGHT and LEFT functions to extract a specific number of characters from the right or left of a string
I want to display only the four characters from the right of the data entered in a cell, or I want to display the rest of the data without displaying the left few characters. Conversely, I want to display only 4 characters from the left of the data entered in a cell, or I want to display the rest of the data without displaying the few characters on the right. Thus...
Excel Functions Name a cell Excel
There are many times when you need to refer to a cell with coordinates such as "=A1" or "=C50". However, when you try to get the value from another sheet or another book, the coordinates are not always the same.
Excel Macro (VBA) How to use the input screen "InputBox" Excel Macro (VBA)
If you want to use values or arbitrary characters that do not exist in Excel, the "InputBox" is useful to easily create an input screen during macro execution. In this article, we will briefly explain how to use this "InputBox".
Excel Functions How to find function references with trace arrows Excel (Excel)
If you are confused about reference relationships in Excel functions, you have come to the right place! This article details how to find references using trace arrows. In fact, you can easily visualize the relationship between cells from the formula tab. This article will help you understand complex functions.
Excel Functions Insert rows without breaking formulas (using spil) Excel (Excel)
With Microsoft365 and Excel 2021 or later versions, you can insert, delete, and rearrange rows without breaking the formula by using a feature called Spill. In this article, we will show you a specific example...
Excel Macro (VBA) How to delete a sheet by specifying the sheet name VBA(Macro)Excel(Excel)
As the number of unneeded sheets grows, browsing becomes worse, and Excel itself becomes slower. In such cases, you can use VBA to automatically delete unnecessary sheets. In this article, we will show you how to use VBA to delete sheets at high speed...
Excel Functions Automatically create invoices from sales invoices 2 Excel (Excel)
Creating Invoices Automatically from Previous Sales Statements1 Continuing from Excel (Excel), we will create an invoice. Putting the details on the invoice (using a function)*Using the "FILTER" function using Spil*This one uses the Spil function, so you will need to use Microsoft365 or E...
Excel Macro (VBA) VBA "Overflow occurred." Error cause and remedy (runtime error '6′:)
Cause of ErrorThis error occurs when the data type is not in a format that can be handled, or when the data type exceeds the range of numbers that can be handled. First, let's reproduce the error. As shown in the figure above, we have set up the code to copy the numeric value in cell "B3" to cell "B4".
English 
日本語