Search across sheets in function
Just when you need to search for a thing across sheets in a workbook. I am bored, so I am adding articles from my old archive.
Just when you need to search for a thing across sheets in a workbook. I am bored, so I am adding articles from my old archive.
I don’t believe I don’t have this here yet. This is one of my oldest tricks When we have to do links between two workbooks (One cell in Workbook1 to …
I think if there is a single function that would be a huge threat to VBA and macros from user perspective, it would be INDIRECT() Yes, it wasn’t long enough …
This is the iframe in Excel, if you are familiar with the HTML concept of iframe, you will understand this one right away, it is basically the same project as …
Rotating table (Transpose) using functions so that the table is updated once the source table is updated. Also can be used as automatically rotating tables with variable number of rows …
Here you will see how to work with functions to insert a blank row every certain number of rows in a table using a blank sheet to copy all values …