Search results 106

Sorted from new to old.

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

RowList_Matching

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

2021Dec27

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

RandomUniqueID_Sheet

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

2021May29

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11

ConcaUFO_RowsfromSheets

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

2020Nov11

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

CreateList_Matching

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

2020May13

1 2 ...4 ...6 7