BoldCodes

Search results 86

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

2022Sep15

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

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

2022Aug16

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

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

2022Jul4

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

2022Jul3

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

2022May16

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

2022Apr26

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30