Convert All Sheets Data Into Excel Tables with VBA
Simple line of VBA Code allow you to convert all the sheets data into Excel Tables just by one click.
#FarazShaikh #ExcelExciting #VBA #Macro #ExcelForMac #ExcelForWindows
Category: Excel
Multiple Results using VLOOKUP and INDEX + MATCH formulas
Search for Multiple LOOKUP Values and Return Multiple Results using VLOOKUP and INDEX MATCH formulas
Get All Sheets Names In Workbook with VBA Excel for mac and windows
This VBA code allows you to get this of all sheets name in current workbook by creating new worksheet.
#FarazShaikh #ExcelExciting #VBA #Macro #ExcelForMac #ExcelForWindows
Excel LET Function
When we are constructing a simple or complex formula LET function will be very handy, just imagine it works like a variable/parameter where you can declare your value or formula with a meaningful name and reuse it with the name within the formula construction each time required
How to protect VBA code in Excel (windows & mac)
Simple steps shows how to lock the VBA code
Convert number to words as per currency ISO Code
Copy Spell Number VBA Code for FREE ..!! No more worries about converting the number to word manually in Excel. It happens often time we wish to convert number to text, currently, there is no built-in function in Excel but yet with the help of VBA we can manage to do it. This is the customized code as per currency
How to make Dependent Dropdown list with XLOOKUP
XLOOKUP made the life easy to make the dependent dropdown list, we would have never imagined that it would be so simple to construct the formula. Check out post & get you sample file for free of download
Get Data From OneDrive Excel File Using Power Query
Use Power Query (Get & Transform Data) to connect the Excel File from OneDrive Location.
Excel IF Function
IF function performs a logical test and return one value for a TRUE or FALSE result. For example, to “pass” scores must be above 35, So the constitution of the formula reads as below
Convert Numbers To Word In Excel (Spell Number)
Copy Spell Number VBA Code for FREE ..!! No more worries about converting the number to word manually in Excel. It happens often time we wish to convert number to text, currently, there is no built-in function in Excel but yet with the help of VBA we can manage to do it.