Export multiple sheets as pages in 1 pdf, doc, still rough and not elegant as ...
2018Aug8
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
How to type special characters in keyboard using ALT + keypad numbers I also ...
2021Oct13
Imports rows from multiple sheets of a workbook into final sheet along with ...
2020Nov11
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
This is an interesting approach to export a range of cells into picture using ...
2020Dec21
Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...
2018Jul7
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Gets total of folder size in bytes. With some tweaks, you can modify it to use ...
2020Apr20
Dropdown list for input box works as Autocomplete Multi-column, themeable ...
2019Jun25