Browse codes

ANmarAmdeen 899

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

Creates batch file with certain content, and another function to actually ...

2022Aug25

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

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

2022Aug22

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21