Browse codes

ANmarAmdeen 901

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

Removes duplication in table in 1 or more columns. Will work in sheet, ...

2022Sep25

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