Search results 60

Sorted from new to old.
Card image
ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Card image
ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

Card image
ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

Card image
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

Card image
ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

Card image
CreateUniqueList

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

Card image
Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

Card image
Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

Card image
ConcaUFO_RowsfromSheets

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

Card image
Graphbar

Interactive graph bars, will go deeper when you click on the bar Originally ...

Card image
Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

Card image
Most recent in Oracle DB

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

Card image
CSS Charts

Great articel about making charts in CSS. It has 3 main types, bar, column, ...

Card image
FilterSheet_1By1 + FilterSheet_Clear

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

Card image
all_tab_columns

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