SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

Frm6.zip

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

Most recent in Oracle DB

List the most recently added rows based on a date column.

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

all_tab_columns

List all columns in all tables for all schemas in oracle db workbench