Search results 66

Sorted from new to old.
Card image
ANmaSQL_InsertStatement

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

Card image
Export2CSV

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

Card image
CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

Card image
Frm6 - ANmaMultiSelect

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

Card image
RandomUniqueID_Sheet

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

Card image
Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

Card image
Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

Card image
SumOf_3Filters

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

Card image
Generate_PowerPoint

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

Card image
ConcaUFO_RowsfromSheets

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

Card image
CellSave and CellRead

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

Card image
DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

Card image
Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

Card image
FilterSheet_1By1 + FilterSheet_Clear

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

Card image
Add2Column

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

Card image
Bootstrap 4 cheat sheet

Bootstrap 4 cheat sheet, quick direct link as image