Search results 60

Sorted from new to old.

ANmaPivotTable_Clear

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

2023Dec22

ChartLegendCenter

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

2023Dec21

ReNumber_IDColumn_inTable

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

2023Dec17

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

AddDatabar_ConditionalFormatting

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

2022Aug22

ANmaSQL_UpdateDateStatement

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

2022Jul4

CreateUniqueList

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

2022Apr26

Row_PixelLocation

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

2021Feb2

Hiding chart in Excel

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

2020Dec31

ConcaUFO_RowsfromSheets

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

2020Nov11

Graphbar

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

2020Aug16

Custom Excel Right-Click Menus

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

2020Mar21

Most recent in Oracle DB

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

2020Feb7

CSS Charts

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

2020Feb1

FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3

all_tab_columns

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

2019Dec22

1 2 3 4