Author: ANmar

Zipcode-State search

Enter a zip code, and Excel will tell you in which state it is It also has a list of all zip codes for all...

Extract Address into table

Convert US addresses from cells (one column with 1 line for Name, 1 line for address, one line for City, State and Zip code) into...

Multiple Dual-Validations

It is to demonstrate how to do multiple validations in the same sheet, or as we want to call it Mutliple-dual-validations that depend on each...

WorksheetName and WorksheetsNo UDFs

Once you open the sheet and enable macros, you can use function: =WorksheetsNo() To get total number of sheets in that workbook And use function:...